How to display only most recent records in an analysis
SummaryHow 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")