hyperion-interview-qu

Rama : Hyperion Essbase

T H U R S D A Y , S E P T E M B E R 1 8 , 2 0 0 8

Hyperion Interview Questions

A: i. We cannot create more than 1 database in ASO, but we can create more than 1 db per application.€If we have more dimensions (generally more than 10) then we will go for ASO

ii. we cannot write back in ASO, but we can write back in BSO. iii. Most of the dimensions are sparse in ASO whereas in BSO most of them are dense.

2) What is Incremental Dimensional Built and one time Dimension Built?

A: Incremental Dimensional Build: Builds and reads from different data sources for dimension builds and delay restructuring until all data sources have been processed.

3) What are the different types of LOG Files?

A: So many log files are there in essbase, but the important log files are 1. Application log 2. Essbase.log 3. Configtool.log 4. eas_install.log 5. essbaseserver-install.log

4) What is the Extension of Cal Scripts, Batch files, outline, and Rule File?

A: Rule file is .rul Calc Script is - .csc Batch files - .bat outline - .otl

5) Why are Filters used?

A: 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 reason you would use a filter is if you wanted to restrict access.

CBSSports Customized Scores

Video Bar Wk 8 · Week 9 · Wk 10 Sun. 11/8 Packers Buccaneers 28 38F Stats Recap Dolphins Patriots 17 27F Stats Recap Chiefs Jaguars 21 24F Stats Recap Texans Colts 17 20F Stats Recap Ravens Bengals 7 17F Stats Recap Cardinals Bears 41 21F Stats Recap NFL College FB NBA College BK

6) What are Dense and Sparse Dimensions?

A: Dense: A dimension which has the high probability that data exists for every combination of dimension members

Sparse: A dimension which has low probability that data exists for every combination of dimension members

7) What are attributes?

A: A classification of a member in a dimension. You can select and group members based on their associated attributes. You can also specify an attribute when you perform calculations and use calculation functions. Eg: The database in Sample Basic which has product dimension has some attributes like size, package type, and flavor. We can add these attributes to the dimensions where we can retrieve the data like for example to retrieve “coke with 8 Oz with bottles”, this is useful for generating reports.

8) What are different types of attributes?

A: Essbase supports two different types of attributes. 1. User-Defined attributes

2. Simple attributes

User-Defined attributes: The attributes that are defined by the user. Simple attributes: Essbase supports some attributes, they are: Boolean, date, number, and string.

9) What are filters?

A: 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. 10) What is TB First and TB Last?

A: TB First: in the Sample.Basic database, the accounts member Opening Inventory is tagged as TB First. Opening Inventory

consolidates the value of the first month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Jan.

TB Last: in the Sample.Basic database, the accounts member Ending Inventory is tagged as TB Last. Ending Inventory consolidates the value for the last month in each quarter and uses that value for that

month’s parent. For example, the value for Qtr1 is the same as the value for Mar.

11) How do you calculate the Size of the datablock? A:

12) What is intelligent calculation?

About Me Hello,

I did my Master's in Computer Science and I was interested in Hyperion. I thought of creating a blog for hyperion so that the professionals and sudents can share their knowlege with me. Cheers! Rama

View my complete profile

Blog Archive ► _{2009 (1)}

▼

▼

A:

13) What is data file cache?

A: A buffer in memory that holds compressed data (.PAG) files. 14) What is custom defined function?

A: Essbase calculation functions that you develop in the Java programming language and then add to the standard Essbase calculation scripting language by means of MaxL.

15) What is custom based macro?

A: Essbase macros that we write with Essbase calculator functions and special macro functions. Custom-defined macros use an internal essbase macro language that enables you to combine calculation function and operate on multiple input parameters.

16) What do you mean by dirty block?

A: A data block containing cells that have been changed since the last calculation. Upper level blocks are marked as dirty if their child blocks are dirty (that is, have been updated)

17) When do we generally use build rules files?

A: To automate the process of creating dimensions with more members, where it will take a lot of time in creating manually. 18) What are the three primary build methods for building dimensions? A:

1. Generation references 2. Level references 3. Parent-Child references

19) How does UDA's impact database size?

A: There will be no impact on the database as the UDA’s doesn’t store data in the database.

20) Can we create UDA’s and apply it to Dense as well as Sparse dimensions?

A: Yes

21) Types of Partitions available in Essbase? A: Three types of partitions are there.

1. Transparent partition: A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately

accessible to both local data target users and transparent data source users

2. Replicated Partition: 3. Linked Partition:

22) How can you display UDA’s in reports?

A: UDA's values are never displayed in the reports and hence do not impact report performance.

23) 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?

A: The record will be rejected.

24) Can we have multiple databases in one single application? A: Yes. But only one database per application is recommended. Depend on which database that you are going to create. For Example: If you are creating ASO then we can’t create more that 1 db per application. If you are creating BSO then you can create more than 1 db per application

25) How is data stored in the Essbase database?

A: Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.

26) We have created an application as unicode mode. Can we change it later to non-unicode mode.

A: No

27) What is the role of provider services.

A: To communicate between Essbase and Microsoft office tools. 28) A customer wants to run two instances of an Essbase server on a same machine to have both test environment and Development environment on the same server. Can he do that?

A: Yes. We can have multiple instances of an Essbase server on a single machine and there will be different sets of windows services for all these instances.

29) Why top-down calculation less efficient than a bottom-up calculation?Being less efficient, why do we use them.

A: 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.

some of the answers. Let me collect some more interview questions and post it.

Cheers! Rama

Labels: hyperion interview questions

1 comments:

Post a Comment

Home Subscribe to: Post Comments (Atom)

Posted by Hello, at 9:34 AM

Newer Post

amarnath said...

really good questions, thanks a lot and i will also try to post some questions on Essbase