Please note! Pivotal Analytics is not available for all subscription plans. Please contact our Sales Team for further info.
Inventory History has stock levels however doesn't have any Purchase order information. Those values happen to be in a different cube - Purchase Orders cube. We can query one cube from another using LOOKUPCUBE calculated measure function:
1) Create a new report using the Inventory History cube.
2) Add SKU to Rows.
3) Add Last Stock Level to measures.
4) Create a new calculated measure.
LOOKUPCUBE("Purchase Order",
"([Measures].[Quantity],
[Purchase Order Fact].[Status].&[OPEN],
[Inventory Products].[SKU].&[" + [Inventory Products].[SKU].CurrentMember.Properties("Key")+"]
)")String expression syntax
LookupCube(Cube_Name, String_Expression )
The actual expression is a standard MDX expression that is essentially evaluated for every value (cell) of the report, therefore we can inject values (keys, names etc) from our current cube query into it. In the example above we are injecting Key for the SKU.
5) Add newly created calculated measures.