Latest hyperion essbase/planning interview questions

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

10 comments :

  1. Replies
    1. sir could you please send the answers to nvk5499@gmail.com

      Delete
  2. Wonderful information sir.. I appreciate your time and efforts

    ReplyDelete
  3. Sir I have drafted you an email, Please go through the same and respond as soon as possible. Thank you in advance

    ReplyDelete
  4. Excellent information Kotireddy Garu, can you please share the answers at arsr61@gmail.com

    ReplyDelete
  5. please send answers to kushi.kundu@gmail.com

    ReplyDelete
  6. pls send answers to sagarreddy.ee@gmail.com

    ReplyDelete
  7. xcelent info reddy garu please let me know the answers pls share the answers to pepcena@gmail.com

    ReplyDelete
  8. please share your valuable information with me as well sir

    shaik.essbase@gmail.com

    ReplyDelete
  9. sir,please let me know the answers pls share the answers to

    roy.khr@gmail.com

    ReplyDelete