Request a Consultation

CheckPoint Consulting Blog

This blog is to illustrate and walk you through the process of creating a CSV extract file from your Hyperion applications.  For this example, I’m using Oracle’s COMMA4DIM sample application.  Additionally, this is also useful for those who wish to use their Hyperion applications as a data source.

Step 1: Create your Custom Application

 J1.png

J2.pngJ3.png

Step 2: Create import format and assign the dimensions

 J4.png

 

Now assign the dimensions …

 J5.png

 

Step 3: Configuring Application Options for your output file

J6.png

Step 4: Create a Location

 J7.png

 J8.png

 

Step 5: Create maps for your new location

For this step, I chose to use a SQL mapping script since I’m using sample data and just needed for it to pass-through.

J9.png 

Step 6: Create a Data Load Rule

J10.png J11.png

J12.png

Step 7: Customize the Output File (Optional)

J13.png

J14.png

This step is completely optional.  I put this in here for those of you that want to make advanced changes to the output file.  Maybe you don’t want the header row or perhaps you want to change the order of the columns on the output file.  The code snippet below shows you how to control the details written to the file while retaining the “Download” link from the “Process Details” screen by overwriting the system generated output.

That’s all folks! Questions?