SET B - HYPERION DRM QUESTIONS
1)
Scenario : There are 100 countries in one of the List properties “CountryList”,
client requested the list of countries, how do you take the list of countries?
2)
How do you know that the query scope is Local or Global?
3)
In one of the systems DRM is feeding metadata to staging area which is
configured with ASCII setting, how do you send the metadata which is compatible
to staging area?
4)
In Accounts hierarchy the top node is Accounts but for one of the target
systems requires “Account” instead of “Accounts”, how do you achieve that using
Exports?
5)
What happens when you don’t save the version?
6)
Is it really mandatory for a property to be a part of any one of the property
categories?
7) What is the difference between Delete and Remove in DRM?
8)
How do you decide that the node is Leaf or Limb in hierarchy?
9)
How to establish flow through (Update in one hierarchy reflects in multiple
hierarchies) concept in DRM?
10)
What is the precaution you have consider when removing the member in hierarchy
that has flow though?
SET A - HYPERION ESSBASE / PLANNING QUESTIONS
1) What is the use of Rule files in Essbase?
2) What are the differences between ASO and BSO?
3) What are the differences among CALC DIM, CALC ALL and AGG?
4) What is the difference between Calculation scripts and Business Rules?
5) Is it possible to display members in webforms that are not there in planning hierarchy?
6) How Essbase understands the selection done in SmartList drop down?
7) How do you assign SmartList to a member in planning hierarchy?
8) How to navigate from one webform to other webform without closing the current open webform?
9) How do you use POV selection in the attached business rule in the webform?
10) In one scenario Liabilities and Assets should get current month value in the quarter excluding the #Missings, how to implement this scenario in Essbase?
11) In how many ways you can increase calculation performance or optimization techniques available to improve calculation performance?
12) How to do conditional formatting in webforms?
13) What is the default storage property of the Attribute dimension members? Is it possible to change?
14) Even though intelligent calculation increases the calculation performance we forcibly turned it off. Why?
15) When you tag any dimension as Attribute dimension then Essbase will create one dimension in the backend, what is the dimension name and its member?
16) There are 5 dimensions in the outline but data file has 4 dimensions metadata alone, then how you will load the data to the cube?
17) What does Join and create using join do?
18) What is the difference between user variables and substitution variables?
19) Which build method will be used to create shared members?
20) What happens when you tag a dimension with Account dimension type?
21) Why Essbase restrict you to create more than one database in ASO application?
FOR MORE QUERIES PLEASE DROP A MAIL TO "ITISHYPERION@GMAIL.COM"
3) What are the differences among CALC DIM, CALC ALL and AGG?
4) What is the difference between Calculation scripts and Business Rules?
5) Is it possible to display members in webforms that are not there in planning hierarchy?
6) How Essbase understands the selection done in SmartList drop down?
7) How do you assign SmartList to a member in planning hierarchy?
8) How to navigate from one webform to other webform without closing the current open webform?
9) How do you use POV selection in the attached business rule in the webform?
10) In one scenario Liabilities and Assets should get current month value in the quarter excluding the #Missings, how to implement this scenario in Essbase?
11) In how many ways you can increase calculation performance or optimization techniques available to improve calculation performance?
12) How to do conditional formatting in webforms?
13) What is the default storage property of the Attribute dimension members? Is it possible to change?
14) Even though intelligent calculation increases the calculation performance we forcibly turned it off. Why?
15) When you tag any dimension as Attribute dimension then Essbase will create one dimension in the backend, what is the dimension name and its member?
16) There are 5 dimensions in the outline but data file has 4 dimensions metadata alone, then how you will load the data to the cube?
17) What does Join and create using join do?
18) What is the difference between user variables and substitution variables?
19) Which build method will be used to create shared members?
20) What happens when you tag a dimension with Account dimension type?
21) Why Essbase restrict you to create more than one database in ASO application?
FOR MORE QUERIES PLEASE DROP A MAIL TO "ITISHYPERION@GMAIL.COM"
