In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?
You are trying to create a multidimensional model for Essbase and learn that your user wants to track commission for his sales persons, in addition to tracking sale by regions. When designing a multidimensional model, which two elements will serve as facts (measures)?
What security filter will assign security to hierarchy, filtering the members displayed to end users?
In Essbase, security can be managed in_______.
Identify the two true statements about data loads to ASO and BSO databases.
You have the following customer dimensions;You need to create a % of total (by region) calculation by customer in you aggregate storage database for Net_Revenue. Select the best syntax for member formula so that the % Total calculation works at all levels of customer dimension.