Can we create expressions with measures based on different granularity
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
0