Please note! Pivotal Analytics is available for subscription plans Business and higher. Please see our Pricing page or contact our Sales team for further details.  


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.