• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

LBI data source related error

 9 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Gus Chan
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 5
Basic Member
3/5/2010 3:16 PM

I am seeing it in my LBI dashboard.

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

This is the error.  Chris, Can you help?

Attachments
mark.cook
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 277
Veteran Member
3/5/2010 6:04 PM
Sorry Gus, didn't see your last reply re: scorecard.
Gus Chan
Basic Member Send Private Message
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