×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You have the following analysis requirement. Products roll up to Product Family which rolls up to Product Category. You also need to group Products by Product
Manager. Product Managers may manage one or more Products across product families. You do not need to create reports with Product Manager by Product
Family. You need to secure products by Product Manager for planning submissions.
You consider Shared members as a solution because of which two options?
2.
Identify four disadvantages / considerations when using a transparent partition.
3.
Assuming Sales and Year are sparse and Actual is dense, what two actions will the following calc script perform?
FIX (Actual, @CY, Sales)
DATAEXPORT "BINFILE" "data.txt";
ENDFIX
4.
A calculation script is performed on a database for which Create Block on Equation is OFF. The command SET CREATEBLOCKONEQ ON is issued immediately before an equation in the script.
Which statement accurately describe when blocks will be created?
Which statement accurately describe when blocks will be created?
5.
Market size is an attribute dimension with the following members: Large, Medium, and Small.
Which of the following options below represent valid syntax statements in a calc script?
6.
Moving a stored entity member in a sparse dimension causes_________.
7.
During a multidimensional analysis getting data from a supplemental data source is an example of________.
8.
Identify the two true statements about expense reporting tags.
9.
You are building a sales analysis model. In this model there is no requirement for calculation. The user needs to aggregate data across all dimensions and wants to archive many years of data. Archived data will be analyzed once in while.
What types of cube would you build using Essbase for this kind of requirement?
What types of cube would you build using Essbase for this kind of requirement?
10.
The data block density for a particular BSO database is between 10% and 90%, and data values within the block do not consecutively repeat. Which type of compression would be most appropriate to use?