Create a dynamic Variance & Variance % based on position and nature of accounts
Variance calculation should - > Dynamic Calculation - based on Position (eg: Actual - Budget) and also nature of account type also (eg Revenue should be positive, and expense should be negative) then variance should be dynamic based on nature of account and so on).
At present users don't want to create any calculation by creating formula (in OAC DV my calculations or in RPD/semantic layer) instead they want this to be achieved by default in DV.
Comments
-
0
-
Calculations based on data/metadata awareness should be defined in the data asset (subject area or dataset). Unlike applications or dedicated tools like Essbase, OAC does not have segment-specific behaviors like knowledge of 'Accounts' and the meanings of specific accounts but provides the tools to implement such behaviors.
0
