You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to display only most recent records in an analysis

Accepted answer
edited Dec 18, 2019 12:53AM in Reporting and Analytics for SCM 1 comment


How to output only the most recent records in "Inventory - Onhand Balance" analysis


In OBIEE, Is there a way to modify the pre-built analysis "Inventory - Onhand Balance" (analysis location: "Shared Folder /Supply Chain Management/Warehouse Operations/Inventory”) so it only outputs the most recent values for each SKU instead of values aggregated since day 1 on both "Costed Onhand Amount" and "Costed Onhand Quantity" attributes ? 

I have tried the following methods but they resulted either in showing aggregated values or error:
1) Aggregated values shown instead:
• "Start Date" dimension formula:
MAX("- Inventory Valuation Details - Onhand"."As of Date")

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!