Friday, January 30, 2009

Hyperion Planning Certification Help

Hi Guys,
here are some planning questions which could help you get certified in Hyperion Planning Certification. I intentionally didn't post answers for most of them as you can find those answers in planning administrator manual. Hope this helps.
  1. What are the required dimensions in planning?
  2. What are the steps you need to take before creating planning application?
  3. Which process state signifies that a planning unit is being reviewed by someone in the organization.
  4. What file acts as bridge between Planning and relational data source?
  5. When you tag a currency as a reporting currency, which dimensions will it be part of.
  6. What is the maximum number of plan types you can have in planning?
  7. Where are the rejected records after loading using HAL are placed in?
  8. What are the different user roles in planning security?
  9. Planning supports fiscal year calendars. It does not support mixed use of fiscal year and calendar year (True/False)?
  10. What are the data sources supported by hyperion financial reporting?
  11. Which type of tasks can you define in a task list?
  12. What are the requirements for creating a dataform?
  13. Row and column layout, business rules, POV definition, display options etc
  14. Fiscal start of year and fiscal start month defines the starting fiscal year and start month for application. You cannot change this after you have created the application (True/False)?
  15. To which application elements can you assign rights
  16. When you enter plan data in the planning web client, planning automatically distributes values from :
    · Summary periods to base periods
  17. Do you need to refresh your database once you modify the webforms?
  18. How many relational databases are needed for an application, which has 4 plantypes
  19. List of places where you can launch business rules from
  20. What is the maximum number of dimensions that a planning application can have?
  21. Which can be runtime prompts in business rules?
    Member or members
    String integer, real or percent
  22. The POV is always set to _______ for each POV dimension
    Single member
    Multiple members
  23. What is the reason for having sparse dimension? Data values are not smoothly and randomly distributed throughout the database Data values do not exist for the majority of member combinations in the database
  24. How many databases will be created for two plan types.
  25. By default account and period are dense dimensions in planning application.
  26. When creating planning application, what base time period allows you to select weekly distribution option? (Ans:Monthly)
  27. In which dimension your exchange rates are stored?
  28. An authentication directory is a centralized store of users and passwords, user groups etc.
  29. What authentication directories are supported by hyperion planning?
  30. Which type of tasks can you define in a task list?
    Business rule
  31. Because dimension members can belong to more than one plan type you can specify different aggregation options by plan type.
  32. Where does planning store application definition?
  33. What happens when you use dynamic calc for base-level members for which users enter data?
  34. Which data form tasks can you perform in smart view?
  35. Parent members set to dynamic calc are read only in target version.
  36. How many user variables can you setup for each dimension?
  37. A parent member set to label only displays the value of its first child member.
  38. In multiple currency applications, you cannot apply the label only storage option to members of the following dimensions: Entity, Version, Currency and user defined custom dimensions. To store exchange rates, these members should remain Never Share.
  39. What is the calculation order in essbase
    Account dimension
    Time dimension
    Other dense dimensions in top down order
    Other sparse dimensions in top down order
    Members that are tagged as two pass calcs
  40. The Two pass calculation option is used primarily for members of the account dimension. For other dimension, the two pass calculation option is only valid for Dynamic calc or dynamic calc and store members.
  41. What is the maximum number of alias tables you can have for a dimension?
  42. What is a planning unit?
  43. For all Hyperion system 9 products, all user provisioning and external authentication is handled through:
  44. After entering or modifying data in a dataform, you must calculate new totals for parent members in the dataform.
  45. When loading files that contain member properties, you must :
    Load parent members before children
    Have a separate load file for each dimension.


  1. Mr. Dornakal,
    I do appreciate your intention to help budding Oracle(hyperion) learners..but I would request you to not post such certification questions which will eliminate the primary purpose of learning.
    I hope you understand my concern..

  2. Dear Anonymous,
    Thanks for suggestion.
    These are only questions and to find answers one has to go to DBAG again, which prompts them to study more and moreover i never said if you memorize these questions you can get through the exam. This guides a person how to prepare for exam.

  3. Anonymous has gone mad.... dornakal you stole his thunder of being a super hero in his office were he sits in a corner and people make fun of him every morning. See to his misery now he thinks if you post these question his junior's will get certified and even they wont spare him.... LOSER he his!!!!

  4. Dear Mr. Dornakal,

    You have not yet passed the new test 1z1-533 Hyperion Planning 11 Essentials. You the best to prepare for it? What specialized literature to read? Maybe somewhere you can get sample questions. I heard that the test is very different from the old tests on planning and the complexity of its rather high.

    I would be grateful for any help!

  5. It seems, these questions will help to interview also. Thanks Friends.