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?