Click on Programs and select olapunderground | Essbase Outline Extractor | Essbase Outline Extractor.

Click on the Do not show this message again checkbox and click on Proceed if you get the following prompt:

You should now see the extract utility, as follows:

Click on the Login button on the top left and enter the server you want to log in to. Enter your username and password.

Click on the Sample.Basic application and database, and click on the OK button.

You should now have the option to select a dimension from the Select Dimension combo box. Click on the Product dimension.

Click on the Load File Format radio button and the Field Options command button. Select all the checkboxes except Currency Name/Category in this menu as it is not applicable in this case.

Click on the Browser button circled in the following screenshot and select a file location and filename.

You have the option to change the file's delimiter as well, but the exclamation mark (!) character should work fine.

Click on the Export button.

A file should be produced in the location you specified, delimited by the bang or exclamation character, and in a parent-child format. The column headers in this file should be as follows: