To insert universe query content into an Excel spreadsheet:
1. Open Microsoft Excel.
2. Click the universe query icon as shown below.
3. Clicking the universe query icon will open up the Live Office Insert Wizard.
4. Expand the universe folder in the left pane and select the appropriate universe you wish to query from.
5. Click Next.
Clicking Next displays all the class and properties of the universe.
6. Now drag and drop the necessary properties and or measure into the right pane as shown below.
You may drag and drop any filters in the filter pane.
7. Click Next.
Clicking Next prompts you to enter object name.
8. Click Finish to populate the data into the spread sheet.