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

Can we create expressions with measures based on different granularity

Received Response
21
Views
1
Comments
edited Jan 18, 2024 6:00AM in Supply Chain Planning and Collaboration 1 comment

Summary:

We have following measures in SOP named :-

1 Avg Selling Price (ASP) which is created at Item Org customer(time independent) --populated using FBDI

2 Adjusted ASP which is editable and at seeded granularity

3 Final ASP which is at seeded granularity and expression is Nvl(Adjusted ASP,NVL(ASP,Price))

4 Production Plan seeded measure --at item,org,day

5 Production Plan Value --custom measure at item,org,day expression is Production Plan * Final ASP

Will this setup give correct results if we are viewing the data at item,org,customer,day

Please note that aggregation & diasggregation parameters are different as well for the measures

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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