My Friend Mr.Koti has attended interview for Hyperion Essbase in HCL,Accenture,TCS,CSS,CTS etc. The following list of questions he prepared during his Hyperion Essbase interview.
1 Talk about committed and uncommitted access?Committed:
2 What is CCONV?
3 What is an Outline?
4 Can you define different types of partitions between the same two databases?
5 What is Sparse restructure?
6 Give a few examples of LRO's?
7 What is "Enterprise Analytics"?
8 What are the reasons to turn off CCTRACK?
9 What is CCTRACK?
10 Can you change the member combination associated with any linked object?
11 What is Dynamic calculator cache?
12 How do you order the Outline?
13 What is Essbase OLAP server?
14 How does a user can view data?
15 When Essbase restructures both the data blocks and the index, it uses the files described
16 What is UDA( user defined attributes). How are they different than Aliases.
17 Do shared members share LRO's?
18 How do you create ASO in the Automated Way?
19 What are the actions that improve performance for restructuring?
20 When do you use RLE over Bitmap Compression?
21 What is the use of multidimensional database such as Essbase?
22 What is the process to build a currency conversion application and perform conversions?
23 How do you create an ASO application?
24 Essbase kernel file that contains control information used for db recoverydbname.tct
25 What happens if you make all dimensions sparse?
26 Explain in detail about the features of ASO?
27 How can you turn off CCTRACK?
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?
29 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?
30 Can a single database serve as the data source or data target for multiple partitions?
31 How do you create LRO's?
32 Is overlapping partition valid in all the partitions?
33 What is the use of variance reporting?
34 do not haveindexes or data blocks.
35 What is the highest level of consolidation in the outline?
36 How does Attribute dimensions and UDA's impact batch calculation performance?
37 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.
38 When do you disable compression?
39 What is an Index entry?
40 What are the conversion methods supported by Essbase for currency applications?
41 Can we query a member for its UDA in a calculation script.
42 When does a DB restructure?
43 What is data compression?
44 What is a shared member?
45 What are the members for which Two-pass calculations can be given?
46 Can you load data or calculate data on client machine?
47 What is an alternative to create metaoutline, rule file and load data.
48 What is Data cache?
49 What are benefits of partitioning?
50 What is a Linked Reporting Object (LRO)?
51 Types of Partitions available in Essbase?
52 What is annotating database?
53 What are the three dimension that should be present in main database of currencyapplication?
54 What is the maximum number of values in the database?
55 What is transaction control file?
56 When do we generally use build rules files?
57 What happens if you make all dimensions dense?
58 What are the design considerations for calculation optimization?
59 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.
60 What are the memory caches used by Essbase to coordinate memory usage?
61 What are Database Objects?
62 What are Standard dimensions?
63 do not have two pass logic and built in time balancefunctionality.
64 ASO formulas are written in MDXsyntax.
65 What are “.sel” files?
66 What is the Design Process?
67 What is Outline-only restructure?
68 You canload data to level zero members only.
69 What are the dimensions that should be present in currency database of currencyapplication?
70 do not use calculation scripts
71 What is the process for designing a partitioned database?
72 Type of partition:
73 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.
74 Database SizeFragmentation QuotientThreshold
75 Explain the process of sparse restructure?
76 Which restructure operations are faster?
77 Can we convert the converted currency back into its local currency?
78 How can you display UDA’s in reports?
79 What is Fragmentation?
80 ASO is read-only
81 What is a calculation script?
82 What does the consolidation properties do?
83 What is a Hybrid Analysis?
84 What are substitution variables?
85 What are the memory caches used by Essbase to coordinate memoryusage?
86 What are the different types of data sources?
87 What is a dynamic Calc?
88 Explain the process of dense restructure?
89 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.
90 What is Index cache?
91 What are the ways to improve performance during data loads?
92 What are the two storage options available in Essbase and what are the differences?
93 Can we create UDA’s and apply it to Dense as well as Sparse dimensions?
94 What are the major difference between ASO & BSO?
95 When do you give an accounts tag to a dimension?
96 What is the significance of time balance properties?
97 When you convert currencies using the CCONV command, are the resulting data blocksare marked as dirty or clean?
98 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.
99 What is commited access?
100 What dimension can be given time balance properties?
101 What are the two types of internal structures in Essbase?
102 What does never consolidate operator(^) do?
103 Why do we need to have classification as dense and sparse dimensions?
104 In what case we can define generation 1 to a feild in generation build method.
105 How do you create an ASO database using ASO Outline Conversion Wizard ?
106 What are important points while building an outline?
107 What is Essbase Partitioning?
108 new kind of storage mechanism
109 What are the advantages and disadvantages of using committed access?
110 What is the difference between UDA's and Attribute dimensions?
111 How can you create a database?
112 Does adding or removing links to a cell does not affect the cell contents?
114 What is Dense restructure?
115 Can we create more than 2 dimensions using only one build rule file.
116 Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.
117 What is Metadata?
118 Can we start and stop an application individually. How ca this be used to increase performance.
119 Can we have multiple metaoutlines based on one OLAP model in Integration services?
120 What are LRO's( Linked Reporting Objects)?
121 Can you add time members that are not tagged as time?
122 What are the advantages of Dynamic calc?
123 What are the parts of partition?
124 Why do we need to limit the LRO file sizes for storage conversion?
125 How does Attribute dim impact report performance?
126 What is a Data block?
127 What is overlapping partition?
128 What is a cell/data value?
129 Can we partition an attribute dimension?No
130 What are the restructuring options in saving database?
131 What are administrative requests and client requests?
132 What is the limitation on version and mode during partition?
133 What is a transaction?
134 What are the Essbase Application tools?
135 What is LRO (Linked reporting objects)?
136 What are types of data compression?
137 What are the three options specified in Username and Password management under security tab in Essbase server proprties.
138 What are the file extensions for an outline, rule file and a calc script.
139 What is the structure of currency applications?
140 How do you rename members?
141 Is there any limitation on number of members?
142 What are data locks?
143 How does Essbase locate and retrieve linked objects?
144 Can we build dimensions directly from data sources without using rule files.
145 What are the types of Partitions available in Essbase?
146 What are the specified roles other than Aministrator to view sessions, disconnect sessions or kill users requests for a particular application?
147 As your business changes, you change the Essbase database outline to capture new product lines, provide information on new scenarios, reflect new time periods, etc. Some changes to a database outline affect the data storage arrangement, forcing Essbase to restructure the database.
148 What is a location alias?
149 How do you set dense and sparse settings?
150 How do you differentiate ASO applications?
151 How can we display UDA's in reports? How do they impact report report performance.
152 When do you use label only?
153 What is a rule file?
154 When do you use substitution variables in partitions?
155 What is Calculator cache?
156 What are different types of dimension tags?
157 How does Essbase calculate the data?
158 What are the conditions affecting Database restructuring?
159 Can we use attribute values to partition a database?Yes
160 Stop OrderPlanning ServiceRMI registryAASStart OrderAASRMI registryPlanning ServiceScreen shots of services shown below:
161 What is a formula?
162 What is Data file cache?
163 What are the ways to improve performance during data loads?
164 What is Implicit Restructures?
165 What is Explicit Restructures?
166 Which transaction is always in committed mode?
167 What is isolation level and what are the types of isolation levels?
168 What are “.EQD” files?
169 What is a Two-Pass calculation?
170 no concept as denseand sparse dimensions.