Inventory Report Not Working Properly

[former_member269447]

Hi Experts,

I have a BI report based on Inventory cube which behaving unexpected manner. e.g While executing the report with Input:

Cal Day and Plant its giving the correct result in default view of the report(Plant and Material is in Default drill).

When Executing the same report with the Calday,Plant and material selection its populating the Zero Stock Qty/Val although its populating the output if we execute the Report with Plant and Cal Day selection only.

Although same report is working fine in Quality System but giving issue in Production. I guess some table might have erupted or some system setting has to be change.

Please share your view on this.

Thanks,

Prakash

[former_member269447]

Hi Experts,

Can you please share your ideas if you have faced this issue ever.

Thanks,

Prakash

[Atul_Thatte]

Hi

Inventory is indeed very tricky. I may not be able to give you precise answer to your query.

However, I have found RSRT a very useful transaction to debug BEx query execution and identify how OLAP engine is calculating values.

Please try to debug your query using RSRT

Regards

Atul