Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

LBI data source related error

Sort:
You are not authorized to post a reply.
Author
Messages
Gus Chan
Basic Member
Posts: 5
Basic Member
3/5/2010 2:28 PM

    I am new to LBI, and I am getting an LBI Data Source Related error in the sales tab.  The error is " Query (1, 31) The 'HIERARCHY' function cannot accept a null member as the argument."

    Somebody please help.  Thanks

    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    3/5/2010 3:07 PM
      Looks like sql server error, not an LBI error. Are you seeing this error for a report published to an LBI dashboard?
      Gus Chan
      Basic Member
      Posts: 5
      Basic Member
      3/5/2010 3:16 PM

        I am seeing it in my LBI dashboard.

        Gus Chan
        Basic Member
        Posts: 5
        Basic Member
        3/5/2010 3:59 PM

          This is the error.  Chris, Can you help?

          Attachments
          mark.cook
          Veteran Member
          Posts: 444
          Veteran Member
          3/5/2010 5:25 PM
            What are you trying to put in that module (published crystal report, scorecard,ect)? I can't tell what you are putting in that box to point you in the right direction
            Gus Chan
            Basic Member
            Posts: 5
            Basic Member
            3/5/2010 5:50 PM
              It is a score card.
              I traced it to the Sales Analysis Cube, DIM Facilities, where one Facility is blank.
              How can I get rid of the blank facility? Should I go back to the BPW ?
              Chris Martin
              Veteran Member
              Posts: 277
              Veteran Member
              3/5/2010 5:57 PM
                Does the viewer window populate automatically with this error when you load the Sales tab/dashboard? If you maximize your browser, do you see a drop-menu icon in the top right of the Viewer module? If so, click the icon and select edit and let me know what's in the URL field on the Main tab.
                Chris Martin
                Veteran Member
                Posts: 277
                Veteran Member
                3/5/2010 5:58 PM
                  Or just right-click in the Viewer module, select properties, and post the URL.
                  Chris Martin
                  Veteran Member
                  Posts: 277
                  Veteran Member
                  3/5/2010 6:04 PM
                    Sorry Gus, didn't see your last reply re: scorecard.
                    Gus Chan
                    Basic Member
                    Posts: 5
                    Basic Member
                    3/5/2010 6:11 PM
                      I found the problem was related to a query that is pulling an extra record for the facility.
                      Thanks
                      You are not authorized to post a reply.