Hi Guys Please find latest hyperion interview questions asked by different MNC's
1.Every i am loading data and when ever i generate Excel report i want to see latest report with out setting up the template.i want to see latest data,how u do that.
2.is it possible to have two grids in one report?can i use two cubes for two grids?is it possible having two database connections in one grid?
3.Can you explain partitions?explain step by step?What purpose u used partition and why u need that?how many types of partition,what is the difference between these partitions(Guys do not read theory and do not explain that,if u know the answer talk otherwise tell him u never worked on this topic).
4.Now days everybody talking about catchy types and asking how we can use this for optimization.
5.What is fragmentation and how u will remove this?
6.Difference between @relative function and @levmbrs?
7.what is clustering?
8.What is sequence in hyperion esbbase( i never heard about this)?
9.How you optimize calculation script performance(Guys now days everybody asking this questions)?
10.Can you explain about intelligent calculation and explain about Intelligent calculation commands?(have to explain SET commands as well).
11.When i am running my calculation its running,how u r going to stop tht script?Do u have ever faced this scenario?
12.What is explicity sharing and implity sharing in essbase?
13.What is difference between Label,exclude and never share?
14.Difference between @shift and @Prior functions?
For answers pls mail me kreddyinf@gmail.com or u post u r answers.
For hyperion training also please contact me.
Regards
Battula Kotireddy
