We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
26
Views
1
Comments
edited Dec 18, 2019 12:53AM in Reporting and Analytics for SCM 1 comment

Summary

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

Content

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.

Register

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