Retrieving Results in Microsoft Excel
Microsoft Excel offers one option to retrieve and display database results, using the Essbase add-in menu in Microsoft Excel.
Note: | If the Essbase menu is not displayed in Microsoft Excel, see your Essbase documentation. |
To view result data in Microsoft Excel:
Launch Microsoft Excel.
In Microsoft Excel, select Essbase, then Connect.
From Server, select the server you are using.
Enter a valid user name and password.
Click OK.
The available Essbase databases are displayed in the Application/Database list.
Select the database from which to retrieve results and click OK.
Select Essbase, then Retrieve.
The database dimensions are displayed at the top of the spreadsheet.
To create a custom report, see your Microsoft Excel or Essbase documentation.