CTS:
1. About project? Dynamic dimension build method?
Ans: Through Rule file.
2. What is dense? Example?
Ans: Read in Essbase DBA guide
3. What is conformed dimension? Examples?
Ans: the dimensions which is used across multiple datamarts are called as conformed dimensions like time.
or
Conformed dimensions are dimensions that have common fields and the respective domains of the values in these fields are the same. This we can say “Drill across”.
4. About types of OLAP? Difference between ROLAP and MOLAP?
Ans: Three types of OLAP;
1: MOLAP- Multidimensional OLAP stores all the summary information(Aggregated Data) in efficiently structured data files. MOLAP cubes normally provides best level of performance.
2: ROLAP- Relational OLAP stores all the detail level of information
3: HOLAP- Hybrid OLAP stores the summary information in the MOLAP cube format with the more detailed transactional information being available from the relational database.
5. How can u store data in cubes?
Ans: Data stores in blocks.
6. How can you build those hierarchies in the outline?
a. Country, region, area
b. Country, region, state, location
Ans: Through level reference dimension build method.
7. What is different between Essbase 6.X and 7.X?
Ans:
8. How u calculate cube size?
Ans:
9. About data loading? How can outline recognize the relationship among the members while data calc and loading?
Ans: Data loading is the process to load the data in the cube. We create a separate rule file for data loading. We define Consolidation and calculation at the time of outline building. Calculation is always start from level 0 and moving up. We load the data also at zero level.
Subscribe to:
Post Comments
(
Atom
)