Hyperion EssBase

[anilreddy27]

Hi.. Can any one post the Interview questions on Hyperian Essbase, pls... ?

[techguru]

There is not much interview questions in essbase... if you have hands on experience, you should be able to get job

[anilreddy27]

Hey.. I have migrated to Essbase and got job in KPIT.. There are few openings in our company... Send resumes who are having exp on Essbase to my mail id. we are having few requirement on Essbase.
anilreddy0207@gmail.com

[nravishankar_r]

Hi,

Some of the interview questions for Essbase:

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 Dimension Building?
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?

[kavitha_ravi20]

What is Incremental Dimensional Built and one time Dimension Built?

[kavitha_ravi20]

What is Incremental Dimensional Built and one time Dimension Built?

[nextlevel]

I have a questions

I had too upgrade my laptop and it now has Vista

i am using 6.5.4.2 and server 7.1.6

but I can load data

I keep getting a 10054 error

Help !!!!!

[Ravilisetty]

HI friends,I am Rajesh. New member in Exforsys.com. I wanna details about Hyperion. What is the Qualification to this Hyperion? I am an B.Com, and MBA (HR). Who can do this course details. Friends please do suggest me about this course or mail me details.

[TTownPilot]

Howdy. I've been developing apps with Essbase for years, but never bothered with any certifications until now.

If this forum is active, it might be useful as a place for discussing certification requirements, questions, etc.

I'm familiar with most of the questions that nravishankar r posted last year, but not all of them. It might be worthwhile stepping through that list and discussing best answers and possible related questions. For example:

Question #1: The difference between ASO and BSO - ASO stands for "Aggregate Storage Option" and became part of Essbase with version 7.x . BSO stands for "Block Storage Option" and has been the traditional way that Essbase stores data.

ASO cubes can comfortably have significantly more dimensions and members than BSO cubes, but are limited in the ways that the data can be calculated. For example, ASO cubes are typically single-currency. (multi-currency is possible in ASO, but it's very awkward).

Question #16 A block is essentially a collection of all the stored members of all dense dimensions in an outline. To calculate block size, multiply each dense dimension's stored member counts, and then multiply that end result by 8. That's for non-compressed BSO cubes.

[Hyperion_newbie]

Hi Guys,

I want to start my career in hyperion essbase. Can somebody guide me in the right direction on how to start learning for this course..Any suggestion would help...

Thanks