In my report I am taking Item as dynarange and the data comes from two cube- Stock on hand from one cube and Forecast numbers for the item from another cube.
I want all those item that have Stock on hand+forecast>0.
In Data tab for item dynarange if I select Stock on hand cube and do slice operator as <>0 then only those items come who have stock on hand not equal to zero but I also want those items that have forecast not equal to zero. How can I get this sorting from other cube too?
I want all those item that have Stock on hand+forecast>0.
In Data tab for item dynarange if I select Stock on hand cube and do slice operator as <>0 then only those items come who have stock on hand not equal to zero but I also want those items that have forecast not equal to zero. How can I get this sorting from other cube too?