Pages

How to Extract the Data from Hyperion Enterprise

Extracting Data: Steps to Extract Data from Hyperion Enterprise for a Particular Category for Particular Period. Ex: Category: "2007" and Period: "Aug 07"
  1. Login to Hyperion Enterprise with your UserID and Password.
  2. Click on DataBase Module.
  3. Set the POV bar to the desired Category (for which you want to extract the data from).
  4. Go to View --> EntityList and select entity list "ALL" to select all the entities including INP and ADJ levels.
  5. Go to View --> AccountList and select Account list "ALL" to select all the Accounts (It will open all the Entities with all the Accounts)
  6. Highlight to period for which you want to extract the data
  7. For Ex: if you require the data for August period, Click on the top of the August period column to select entire column.
  8. Go to Task --> ExtractData.
  9. Select the path by clicking on Browse button to which you want to store the extract file.
  10. Select the Format which is desired or leave the Format option to Default and also check the Include Calculated check box to include the calculated accounts data.
  11. Click OK to extract the Data from the Hyperion Enterprise.

1 comments:

Jitendra Bhagwat said...

Thnx for your effort.

Keep it up.

-Jitendra

© 2010 Datawarehousing Support | Home | Disclaimer | Privacy Policy