Creating Auto-Populate Dimension Documents

This is the quickest method for creating a document. It specifies the database connection, and assumes use of the highest aggregate members of the time and measures dimensions to populate the rows and columns axes of a spreadsheet. You can modify document properties and settings as needed before eventually saving the document.

Note:

You can set the Look and Feel preferences to display Data Layout, instead of assuming use of the highest aggregate members of the time and measures dimension.

  To create a Auto-Populate Dimension document:

  1. Display the View Pane:

    • Select View, then View Pane.

    • Press F6.

  2. Click the View Pane Browser tab.

  3. In the repository, navigate to a database connection file, and double-click the file name.

    If the Database Connection requires you to log on, you are prompted by the Database Login dialog box.

  4. If prompted by the Database Login dialog box, enter a User ID and password for the Database Connection. Select Save User ID and Password to store log on credentials for the Database Connection, and click OK.

    A Auto-Populate Dimension document is displayed in the content area.