If you know the answers for below questions. Please post here.
when I attended the interviews these are the questions they are asking.I know the answer now I am tired.some other day I will post the answers.
1) can you tell me something about yourself and explain me about your project?
2) What is your role in ur current project?
3) What are the issues that you have faced while designing the cube and how did you resolve it?
4) What are different types of build methods?
5) How do you handle null values in essbase?
6) what is the maxl script to aggregate the values in ASO?
7) How are the values Aggregated in ASO? Is there any command that you run to aggregate the values in ASO?
8) What are different types of hierachies in ASO?
9) Say for example that i am building the dimensions and some members which are at gen4 are at gen3 how do build the dimension?
10) What will be there in .CFG file in essbase?
11) Tell me the end to end procedure how do you schedule the batch?
12) what do you understand by configuratation utility while installing the essbase system 9?
13) How do you capture errors while building the dimensions?
14) Tell about alternative hierachy?
15) HAve you ever worked on calculations Scripts?
16) Tell me steps to do migratation?
17) Difference between ASO & BSO?
18) What are the different types of LOG Files ?
19) What is the Extension of Cal Scripts and Rule File?
20) What is an Attribute dimension?
21) What are filters & Why are filters used?
22) what is dense dimension and sparse dimension?
23) What are different types of attribute dimension?
24) what is substitution Variables & Where do you use them?
25) What the storge type of essbase?
26) What are different types of built methods?
27) Tell me what do you understand by Two-pass Calculation?
28) What is the differene between Calc Dim and Calc All?
29) Tell me about TB First and TB Last?
30) How do you calculate the size of the DataBlock?
31) What is the differene between calc All and AGG?
32) What is the difference between Dynamic Calc and Dynamic Calc and Store?
33) How do you do the Data Load Optimization?
34) Different types of Data Load?
35) What is the difference between Fix and IF?
36) What is Intelligent Calculation?
37) what is Dirty Block and Clean Block?
38) If i delete a member from the dense dimension will that block be a clean block or dirty block?
39) What are the different types of Restructuring?
40) What will @ISMEM function will do?
41) What is the difference between Standard dimension and Attribute Dimension?
42) Difference between UDA and Attribute Dimension?
43) Tell me what do you understand by @XREF Function?
44) What is Data Cache?
45) What is the difference between Data Cache and Data File Cache?
46) What are the things that you take the backup?
47) How do you create users in Shared Services?
48) How and where do you configure LDAP?
49) Tell me about SSO?
50) How do you handle duplicate records while loading data into the essbase?
51) Can we give Formulas to Shared Members?
52) Can we give formulas to attribute dimension?
53) How do you optimize the Calclation?
54) What is the difference between ESSCMD and MAXL?
55) What is the difference between 7.x and System 9?
56) What is the the use of navigatation without data in Excel- add-ins?
57) What is cascade option in Excel-addins?
58)Can i give the same alias name to the different member?
59) What is TB First and TB Last?
60) What is the differene between FIX and IF Command?
61) What is MDALLOCATE Function do?
62) What @XREF Function do?
63) What is the difference between Data file cache and Data cache?
64) What will uncommit access do?
65) How does essbase consolidates the data?
66) Can you give the same name to different members in UDA?
67) What are different types of dimension building?
68) What do know about partition?
69) What are different types of partition? Have you ever worked on Partition?
70) what is the Maxl Command to rename the application or database?
71) What is the MAXL Command to bring the application into read only mode?
72) What are the steps to schedule the batch in Financial Reporting?
73) I have got 10 reports in my financial reporing and i want to send all those reports in one pdf how to you do that?
74) What is the difference between MOLAP and ROLAP?
75) What is fact table in your outline?
76) Can i have more then one fact table in my outline?
77) What is the calculation order of essbase?
78) How do you decide whether the file which you have received is in generation reference or level referene or parent & Child reference?
79) IS there any situation that i get more number of text files then the number of dimensions in my outline to build the dimensions?
80) Can i build the dimension and also the shared member with one text file if yes what is the procedure ?
81) Can i build the dimension and the data load with the same rule file if yes what is the procedure?
82) Can i set my cahces using MAXL Command if yes how do you do it?
83) Can i assign storage properties in my rule file if yes how should i do it?
84) If your end user complaint in report where should u check for finding error values? and what is the procedure that you follow to close it? Do you interact with user directly? if yes what is the mode of your interaction?
85) What are the different compression techniques?
86) How many dimensions a there in your project and what are they?
87) How many members are there in your time and account dimension & What is the hierachy of your time dimension?
88) What is rule file?
89) How many flat files for data loading you used in your project?
90) How many rule files you have used for data loading?
91) Tell me errors that you get while data loading and dimension building?
92) Where do you capture data laod errors and dimension build errors?
93) How much time it will take to load data in your project?
94) What is the size of your data file?
95)What is lock and send in your excel-addins
96) While loading the data if server hangs up what will happen?
97) When does restructuring happen?
98) What is your application size? and where do you check it?
99) How is data stored in ASO a and where is it saved?
100) If the data corrupts what will you do?
101) How do you remove defragmentation?
102) Is your current project and ASO or BSO and who will decide it and at which stage of SLDC?
103) What is your team size?
104) What are the differnent optimization techniques that you have followed to imporve the performance of the Essbase and how much percentage it has improved?
105) Can you tell me the number of users in your project?
106) How do you know if everything what you have done in your project is meeting the client needs?
107) Do you interact with client?
108) What type of testing is done in your project?
109) What is your project duration? How much time is spent for Dimension building and data loading?
110) Can you name some of your calculation scripts in your project?
111) How much time it will take when your run your calculation script?
112) Do you know what your calculation script does?
113) When and how do you take the back up of the cube?
114) What are the frequently used MAXL scripts in your project?
115) What will you do when you are not able to solve when problem occurs in your project?
Subscribe to:
Post Comments
(
Atom
)
hi Koti,
ReplyDeleteBelow are some of the answers for ur above questions, remaining i will post ASAP.
6.what is the maxl script to aggregate the values in ASO?
Ans. execute aggregate process on database ASOSamp.Sample stopping when total_size exceeds 1.3;
7) How are the values Aggregated in ASO? Is there any command that you run to aggregate the values in ASO?
Ans. Using execute aggregate process Maxl command we can aggregate the values in ASO.
8) What are different types of hierachies in ASO?
Ans.Stored and Dynamic
10) What will be there in .CFG file in essbase?
Ans.In this file you can define settings that control TCP/IP ports and connections, define how detailed you would like your log files, specify cache settings for performance improvements, define query governers for the server or specific app and much more.
14) Tell about alternative hierachy?
Ans. Alternate hierarchy groups members by by an alternate grouping, with in a dimention you can group the same set of members composed of shared members in different ways.
17) Difference between ASO & BSO?
Ans.1. ASO's does not have dense/sparse concept where as BSO have.
2. ASO does not have shared member property where as BSO has.
3. BSO has duplicate name concept ASO does not.
4. BSO can associate formulas to memers in ASO can't.
5. ASO Applications can have only one DB where as BSO applications can have max 3 BD's
19) What is the Extension of Cal Scripts and Rule File?
Ans. .CSC and .RUL
Thanks,
Appu
Hi,
ReplyDelete99) How is data stored in ASO a and where is it saved?
In aso data is stored in table spaces.
temp,default,metadata,log.
log is used for saving the activites
temp temporary memory allocation
default holds data
metadata holds metadata.
95)What is lock and send in your excel-addins
It locks the required datablocks to send the data,locking helps by not sending conflicting data input bye different users.
97) When does restructuring happen?
remove fragmentation we go for restructuring,right click on the database we find restructure option there.
82) Can i set my cahces using MAXL Command if yes how do you do it?
alter database set index_cache_size string size
81) Can i build the dimension and the data load with the same rule file if yes what is the procedure?
yes can rightclick on database select load data. a new window will be opened in we select the appropiate rules and data file.there we can find error file path also.after selecting click ok.if it is successfull u will get success msg or u can see error onfile path.
85) What are the different compression techniques?
rle-runlengthencoding
bitmap encoding
zlib it is zip file in windows
index value pair encoding it depends upon block density.
in general in real time we go for bitmap.
65) How does essbase consolidates the data?
If both a dimension tagged as accounts and a dimension tagged as time exist, and if formulas are applied to members on the accounts dimension, Essbase calculates in this order:
Dimension tagged as accounts
Dimension tagged as time
Other dense dimensions (in the order they are displayed in the database outline)
Other sparse dimensions (in the order they are displayed in the database outline)
Otherwise, Essbase calculates in this order:
Dense dimensions (in the order they display in the database outline)
Sparse dimensions (in the order they display in the database outline)
64) What will uncommit access do?
in un committed access essbase holds the data blocks which are involved in calculation one by one.it releases the block after it is done.not like holding all blocks untill the transcation is complete.
70) what is the Maxl Command to rename the application or database?
alter application appname rename to stringname
alter database dbname rename to stringname
71) What is the MAXL Command to bring the application into read only mode?
alter application appname set minimum permision dbssystemrole(read or write)
Devi
hi madam, i want all question answers.
Deletemy mil id: rajendra.326@gmail.com
ph:09160525197
rajendrakumar.326@gmail.com
ReplyDeleteHi Devi madam please send the answers to my mail id please
ReplyDeletekoti.eswara@gmail.com
please madam
hi sir im koti in Hyderabad.i want answers above all questions
ReplyDeleteplease send me koti.eswara@gmail.com
please sir
Hi Koti..
ReplyDeleteI really liked the quality of the contents you have posted. Its really very helpful indeed..now to I am like referring your blog every now and then...I know the answers for few of the questions but not all of them.
Could you please share the answer for the above questions as well...as you have said that you would be posting the answers for the above questions..but dint find anywhere..Please guide me..
Thanks...
and Cheers to your intelligent work... =)