Define Hyperion?
Hyperion is Business Intelligence (BI) and Business Performance Management (BPM) tool. It is the market leader in Operational , Financial and Strategic Planning.
It contains the applications for reporting, Planning , dashboards, Analysis, scorecarding, consolidation, Workspace, Master Data Management and Foundation.
What is the Extension of Cal Scripts, Batch files, outline, and Rule File?
Rule file is .rulCalc Script is – .cscBatch files – .batoutline – .otl
What does “DOU” mean?
In reference to RPG, DOU means (Do Until).This will execute a loop matched with an End or End do
For instance
Eval X=1
DOU X=4
Eval X=X=1
EndDo
This example will go through the loop 4 times with the result of X being 4.
“DOU” is similar to Do While(“DOW”) where the difference lies in that the DOU will always perform 1 pass through the loop and DOW will perform the comparison and only continue into the loop if the condition meets else the program continues after the
End (EndDo).
For example
Eval X=1
DOW X=4
X=X+1
Enddo
The result is that the loop will not execute and the value of X will be 1.
Why are Filters used?
If you want to grant access to all dimensions then you wouldn’t use a filter. Just grant read access for the database to the user and/or group. The only reasonyou would use a filter is if you wanted to restrict access.
Can we create more than 2 dimensions using only one build rule file?
Yes, we can do that but it is recommended to use seperate rule file for eachdimension.
What is UDA (user defined attributes). How are they different thanAliases?
UDA represents the class of the members. Aliases are just other names of the members. Both are different and have different usage.
What is the role of the never consolidate operator (^)?
It stops member from becoming consolidate on all dimensions.
How is data stored in the Essbase database?
Essbase is an file based database where the data is stored in PAG files of 2 GBeach and grows sequentially.
How does UDA’s impact database size?
Absolutely no impact as UDA’s do not require additional storage space.
When do we generally use build rules files?
To automate the process of creating dimensions with thousands of members.
Can we have multiple databases in single application?
Yes, in this one database per application.
What is the meaning of a block locking system?
The Essbase Services, also called analytic will make a lock to each of the blocks that encapsulate the childs of the initial block, this is what a block locking system means.
Explain Dense and Sparse Dimensions?
Dense dimension is a dimension in which most data exists for every combination of dimension members whereas sparse dimensions are the dimensions which has low probability that data will exist for every combination of dimension members.
What are filters?
A method of controlling access to database cells in essbase. A filter is the most detailed level of security, allowing you to define varying access levels different users can have to individual database values.
What are Dense and Sparse Dimensions?
Dense: A dimension which has the high probability that data exists for every combination of dimension members.
Sparse Dimension: A dimension which has low probability that data exists for every combination of dimension members
Can we query a member for its UDA in a calculation script?
Yes. You can query a member for its UDA in a calculation script.
Explain attributes?
Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the db in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data. For example, to retrieve “coke with 8 Oz with bottles”.
How does Essbase recover from a database crash?
After a database crash or server interruption, Essbase automatically recovers a database after rolling back the transactions that were active at that time.
Can we build dimensions directly from data sources without using rule files?
No.
What are the different types of LOG Files?
So many log files are there in ess base, but the important log files are:
- Application log
- Essbase.log
- Configtool.log
- eas_install.log
- ess base server-install.log