Hi,
You may also like to read Essbase Interview Questions.
I have got this request from someone to post some FAQ's on Hyperion Essbase. Please do not just rely on these questions only. I recommend you read the Essbase documentation and get some hands on to understand the basics. The questions below shold guide you to narrow down your search for the topics you should focus on.
Que 1: What are the two storage options available in Essbase and what are the differences?
Ans: ASO( Aggregate Storage Option) - Used for 1. If we have large number of dimensions(generally more than 10) 2. Most of the dimensions are sparse 3. We cannot write back in ASO. I heard recently that ASO will also have the writeback capability. I don't remember.
BSO (Block Storage Option)- 1. Dimensions are less and dense(recommended values for no of dim are between 4 and 8) . 2. We can write back hence much suited for planning applications.
Financial applications are generally dense structures and normal analytical cubes are sparse. Here we also need to understand what are these dense and sparse members. When the intersections or cells of two dimensions mostly contains a value it is dense. Say for example we have two dimensions period(Month or quarter) and region and we are calculation the sales amount. Generally maximum regions(countries, cities) will have some sales value for a particular month or quarter. Hence we can say that our period dimensions would be dense. But now instead of period, consider another dimension products. Now there are some products which are sold in only some particular regions hence for them there will be no values in other regions or will have very low percentage of data values hence the structure will become sparse.
Now the question arises what is the use of calling them dense or sparse. What difference does it make. Do some research and try to find the answer.
Que 2: Can we build dimensions directly from data sources without using rule files.
Ans: No.
Que 3: When do we generally use build rules files?
Ans: To automate the process of creating dimensions with thousands of members.
Que 4: What are the three primary build methods for building dimensions?
Ans: 1. Generation references
2. Level references
3. Parent-Child references.
Que 5: In what case we can define generation 1 to a feild in generation build method.
Ans: We cannot define that as Generation 1 is not valid.
Que 6: Suppose we have assigned Generation 2 and Generation 4 as of now and think of adding generation 3 later some time. Can we build the dimension.
Ans: No. If gen 2 and gen 4 exists, we must assign gen 3.
Que 7: Can we create more than 2 dimensions using only one build rule file.
Ans: Yes, we can do that but it is recommended to use separate rule file for each dimension.
Que 8: What is UDA( user defined attributes). How are they different than Aliases.
Ans: UDA represents the class of the members. Aliases are just another names of the members. both are different and has different usage.
Que 9: Can we query a member for its UDA in a calculation script.
Ans: Yes. You can query a member for its UDA in a calculation script.
Que 10: How does UDA's impact database size?
Ans: Absolutely no impact as UDA’s does not require additional storage space.
Que 11: What is the difference between UDA's and Attribute dimensions?
Ans : Attribute dimensions provides more flexibility than UDA's. Attribute calculations dimensions which include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are calculate dynamically.
Que 12: How does Attribute dimensions and UDA's impact batch calculation performance?
Ans: UDA's- No Impact as they do not perform any inherent calculations.
Attribute dim- No Impact as they perform only dynamic calculations.
Que 13: How can we display UDA's in reports? How do they impact report report performance.
Ans: UDA's values are never displayed in the reports and hence do not impact report performance.
Que 14: How does Attribute dim impact report performance?
Ans: They highly impact the report performance as the attributes are calculated dynamically when referenced in the report. For very large number of att dim displayed in the report, the performance could drastically reduce.
Que 15: While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome.
Ans: Thw record will be rejected.
Que 16: How is data stored in the Essbase database?
Ans: Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.
Que 17: Can we have multiple databases in one single application?
Ans: Yes. But only one database per application is recommended.
Que 18: Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.
Ans 18. No. Because we define ASO or BSO option while creating the appication and not database. Hence if the application is ASO, the databases it contains will be that type only.
Que 19: What are the file extensions for an outline, rule file and a calc script.
Ans: .OTL, .RUL and .CSC
Que 20: What is the role of provider services.
Ans: To communicate between Essbase and Microsoft office tools.
Que 21: What is an alternative to create metaoutline, rule file and load data.
Answer: Integration services and in version 11, we have Essbase studio.
Que 22: Can we start and stop an application individually. How ca this be used to increase performance.
Ans: Yes. We can manage our server resources by starting only the applications which receive heavy user traffic. When an application is started, all associated atabases are brought to the memory.
Que 23: We have created an application as unicode mode. Can we change it later to non-unicode mode.
Ans: No.
Que 24: How can I migrate an application from my test environment to the production environment. Can I still do this if my test environment is a windows one and my production env is UNIX one. Also can I still do it if my test env and prod env versions are different.
Ans: Hyperion Administrative services console provides a migration utility to do this but onluy the application, database objects are migrated and no data is transferred. the answers to other two questions are Yes.
Que 25: A customer wants to run two instances of an Essbase server on a same machine to have both test env and Development env on the same server. Can he do that?
Ans: Yes. We can have multiple instances of an Essbase server on a single machine and there will be dfferent sets of windows services for all these instances.
Que: 26 suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this.
Ans: Using (~) exclude from consolidation operator.
Que 27: What does never consolidate operator(^) do?
Ans: It prevents members from being consolidate across any dimension.
Que 28: Can we have multiple metaoutlines based on one OLAP model in Integration services?
Ans: Yes
Que 29: Can we have an metaoutline based on two different OLAp models.
Ans: No.
Que 30: What is hybrid analysis?
Ans: Lower level members and associated data remains in relational database where as upper level members and associated data resides in Essbase database.
You may also like to read Essbase Interview Questions.
I have got this request from someone to post some FAQ's on Hyperion Essbase. Please do not just rely on these questions only. I recommend you read the Essbase documentation and get some hands on to understand the basics. The questions below shold guide you to narrow down your search for the topics you should focus on.
Que 1: What are the two storage options available in Essbase and what are the differences?
Ans: ASO( Aggregate Storage Option) - Used for 1. If we have large number of dimensions(generally more than 10) 2. Most of the dimensions are sparse 3. We cannot write back in ASO. I heard recently that ASO will also have the writeback capability. I don't remember.
BSO (Block Storage Option)- 1. Dimensions are less and dense(recommended values for no of dim are between 4 and 8) . 2. We can write back hence much suited for planning applications.
Financial applications are generally dense structures and normal analytical cubes are sparse. Here we also need to understand what are these dense and sparse members. When the intersections or cells of two dimensions mostly contains a value it is dense. Say for example we have two dimensions period(Month or quarter) and region and we are calculation the sales amount. Generally maximum regions(countries, cities) will have some sales value for a particular month or quarter. Hence we can say that our period dimensions would be dense. But now instead of period, consider another dimension products. Now there are some products which are sold in only some particular regions hence for them there will be no values in other regions or will have very low percentage of data values hence the structure will become sparse.
Now the question arises what is the use of calling them dense or sparse. What difference does it make. Do some research and try to find the answer.
Que 2: Can we build dimensions directly from data sources without using rule files.
Ans: No.
Que 3: When do we generally use build rules files?
Ans: To automate the process of creating dimensions with thousands of members.
Que 4: What are the three primary build methods for building dimensions?
Ans: 1. Generation references
2. Level references
3. Parent-Child references.
Que 5: In what case we can define generation 1 to a feild in generation build method.
Ans: We cannot define that as Generation 1 is not valid.
Que 6: Suppose we have assigned Generation 2 and Generation 4 as of now and think of adding generation 3 later some time. Can we build the dimension.
Ans: No. If gen 2 and gen 4 exists, we must assign gen 3.
Que 7: Can we create more than 2 dimensions using only one build rule file.
Ans: Yes, we can do that but it is recommended to use separate rule file for each dimension.
Que 8: What is UDA( user defined attributes). How are they different than Aliases.
Ans: UDA represents the class of the members. Aliases are just another names of the members. both are different and has different usage.
Que 9: Can we query a member for its UDA in a calculation script.
Ans: Yes. You can query a member for its UDA in a calculation script.
Que 10: How does UDA's impact database size?
Ans: Absolutely no impact as UDA’s does not require additional storage space.
Que 11: What is the difference between UDA's and Attribute dimensions?
Ans : Attribute dimensions provides more flexibility than UDA's. Attribute calculations dimensions which include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are calculate dynamically.
Que 12: How does Attribute dimensions and UDA's impact batch calculation performance?
Ans: UDA's- No Impact as they do not perform any inherent calculations.
Attribute dim- No Impact as they perform only dynamic calculations.
Que 13: How can we display UDA's in reports? How do they impact report report performance.
Ans: UDA's values are never displayed in the reports and hence do not impact report performance.
Que 14: How does Attribute dim impact report performance?
Ans: They highly impact the report performance as the attributes are calculated dynamically when referenced in the report. For very large number of att dim displayed in the report, the performance could drastically reduce.
Que 15: While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome.
Ans: Thw record will be rejected.
Que 16: How is data stored in the Essbase database?
Ans: Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.
Que 17: Can we have multiple databases in one single application?
Ans: Yes. But only one database per application is recommended.
Que 18: Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.
Ans 18. No. Because we define ASO or BSO option while creating the appication and not database. Hence if the application is ASO, the databases it contains will be that type only.
Que 19: What are the file extensions for an outline, rule file and a calc script.
Ans: .OTL, .RUL and .CSC
Que 20: What is the role of provider services.
Ans: To communicate between Essbase and Microsoft office tools.
Que 21: What is an alternative to create metaoutline, rule file and load data.
Answer: Integration services and in version 11, we have Essbase studio.
Que 22: Can we start and stop an application individually. How ca this be used to increase performance.
Ans: Yes. We can manage our server resources by starting only the applications which receive heavy user traffic. When an application is started, all associated atabases are brought to the memory.
Que 23: We have created an application as unicode mode. Can we change it later to non-unicode mode.
Ans: No.
Que 24: How can I migrate an application from my test environment to the production environment. Can I still do this if my test environment is a windows one and my production env is UNIX one. Also can I still do it if my test env and prod env versions are different.
Ans: Hyperion Administrative services console provides a migration utility to do this but onluy the application, database objects are migrated and no data is transferred. the answers to other two questions are Yes.
Que 25: A customer wants to run two instances of an Essbase server on a same machine to have both test env and Development env on the same server. Can he do that?
Ans: Yes. We can have multiple instances of an Essbase server on a single machine and there will be dfferent sets of windows services for all these instances.
Que: 26 suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this.
Ans: Using (~) exclude from consolidation operator.
Que 27: What does never consolidate operator(^) do?
Ans: It prevents members from being consolidate across any dimension.
Que 28: Can we have multiple metaoutlines based on one OLAP model in Integration services?
Ans: Yes
Que 29: Can we have an metaoutline based on two different OLAp models.
Ans: No.
Que 30: What is hybrid analysis?
Ans: Lower level members and associated data remains in relational database where as upper level members and associated data resides in Essbase database.
Que 31: Why top-down calculation less efficient than a bottom-up calculation?Being less efficient, why do we use them.
Ans: In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.
Que 32: On what basis you will decide to invoke a serial or parellel calculation method.
Ans: If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.
Que 33: What is block locking system?
Ans: Analytic services(or Essbase Services) locks the block and all other blocks which contain the childs of that block while calculating this block is block locking system.
Que 34: What are the types of partitioning options available in Essbase?
Ans: 1. Replicated partition. 2. Transparent partition 3. Linked partition.
Que 35: Dynamic calc decreases the retreival time and increases batch database calculation time. How true is the statement?
Ans: The statement should be just opposite. As dynamic calc members are calculated when requested, the retreival time should increase.
Que 36: A customer has a cube with 13 dimensions and the performance was fine. Now they have added two more dimensions in the existing cube and the performance becomes very very slow. Customer said logically nothing wrong with the two new dimensions they have added. What could be the reason for slowdown.
Ans: Even I dont have any clue. I experienced this few days back with a customer. If you can throw some light on this, please post your answer.
If you have more questions with answers, please post them so that all of us can benefit.
Also let me know your views and suggestions.
If you have more questions with answers, please post them so that all of us can benefit.
Also let me know your views and suggestions.
| Hyperion Essbase Interview questions |  |  |
| Essbase is a multidimensional database management system (MDBMS) that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", was originally developed by Arbor Software, which merged with Hyperion Software in 1998. Hyperion Solutions Corporation was acquired by Oracle Corporation in 2007, so Essbase is now available as Oracle Essbase. Until late 2005, it was also marketed by IBM as DB2 OLAP Server 1) Difference between ASO & BSO? 2) What is Incremental Dimensional Built and one time Dimension Built? 3) What are the different types of LOG Files? 4) What is the Extension of Cal Scripts and Rule File? 5) Why are Filters used? 6) What are dense and sparse dimensions? 7) What are Filters? 8) What are Attributes? 9) Different Types of Attributes? 10) What is Substitution Variable? 11) How is Data Stored in Essbase? 12) What is an hour glass modle? 13) Types of Build Methods? 14) What is Two Pass Calculation? 15) What is TB First and TB Last? 16) How do you calculate the Size of the datablock? 17) How many data blocks are there in your cube? 18) What is meant by Descendents and can you give me the best example to describe it? 19) How do you do the Data Load? 20) Where is IS Member Command used? 21) What is the difference between FIX and If Command? 22) What is intelligent Calcuation? 23) What is meant by Clean block and Dirty block? 24) Commands of Intelligent calcuation? 25) How do you calculate the subset of a cube? 26) Difference between standard dimension and attribute dimension? 27) Difference between UDA and Attribute Dimension? 28) What is meant by XREF Function? 29) Can you give the same name to different members in UDA? 30) What is Data Cahce ? 31) What is the Difference between the Data Cache and Data File Cache? 32) What is the Size of your cube? 33) What is Shared members? Can shared members can have children below it ? 34) What are the different storage properties in Essbase? 35) What is the difference between Dynamic calc and Dynamic Calc and Store? 36) How does Essbase consolidates the Data? 37) Different types of 38) What is Label only? Give the the example of it? 39) Difference between calc all and Calc Dim? 40) Explain me about your project? And tell me any difficulities that you have faced and how did you resolve it? 41) What is Commit Block? 42) Tell me different steps so that your can optimze the performance your cube? 43) What is Partition? 44) What are different types of Partition? Have you ever worked on partation? 45) What is MAXL ? and where is it used? 46) What is Alias? 47) How many Alias Tables can be created? 48) How is Data Retrived from Essbase? 49) How is Data Stored in ASO? 50) Different types of Attributes in ASO? 51) Tell me about your project and what is your role in your project? 52) Did you write any MDX Member formulas in your Project? 53) What are different Types of Data Blocks? 54) Where do you check the data has been loaded properly or not? 55) What is Fact Table ? What are supporting Dimensions? 56) What is your Fact Table in Cube? 57) How do you create shared members in your cube? 58) Why do you use Fix Command? 59) Can you use the same logic which are used in calculation scripts in MDX formulas? 60) You have 5 dimensions in your cube and to load the data in the cube you have got only 4 columns what do you do? 61) Why do you use set update cal on and set update calc off? 62) What is mean by free form data load? 63) When do delete one member from the outline what will be status of the block? 64) What are different Types of blocks? 65) What is the difference between Attributes and UDA? 66) What is meant by location Alias? |
Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from .Net Training in Chennai. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.
ReplyDelete