-
Lookupcube ??
Hi,
I need to get a Production Qty from another cube to calculate the Scrap %.
We constructed two Cubes: Production and Scrap. In the Scrap Cube, we used the LookupCube function to search and get the production qty to do that, but...when the user filter one field with two values, the function doesn't work.
See the code:
"
iif(isempty([Measures].[Scrap Qty]),null,
LOOKUPCUBE("[Production]","([Measures].[Prod Qty],
[Date].[" + [Date].currentmember.name + "],
[Material].["+ [Material].currentmember.name + "],
[Formula].["+ [Formula].currentmember.name + "],
[Item].["+ [Item].currentmember.name + "],
[Line].["+ [Line].currentmember.name + "],
[Reference].["+ [Reference].currentmember.name + "])"))
"
When the end-user filter the [Date] with day 01, 02 and day 03, the pivot table raturn #VALUE.
Have another way to do that or we shouldn't filter that way?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|