Building a CubeQuery

  To import a published Interactive Reporting database connection file (.oce):

1. In Explore, select File, and then Import File.

2. Select Browse, navigate to the folder where the Interactive Reporting database connection file is located, and click Open.

   The File field is populated with the Interactive Reporting database connection file name.

3. Click Next.

   The OCE Properties Import dialog box is displayed.

4. Specify a user name and password, and any appropriate data source access settings.

5. Click Finish.

  To import an Interactive Reporting document file (BQY):

1. Select File, and then Import.

2. Click Browse, navigate to the folder where the Interactive Reporting document file (BQY) is located, and click Open.

   The File field is populated with the Interactive Reporting document file name.

3. Click Next.

   The Interactive Reporting Properties Import dialog box is displayed.

4. Specify a connection option in the Apply Option to All Queries field

5. Select an Interactive Reporting database connection file (.oce) to associate with the Interactive Reporting document file in the Query/DataModel Connection drop-down, and specify an user name and password.

6. Click Finish.

  To create a new CubeQuery section based on a previously published Interactive Reporting document file (BQY):

1. In Explore, select an Interactive Reporting document file (BQY) that contains a CubeQuery section.

2. Enter your name in the Host Name field and password in the Host Password field and click OK.

3. Select Actions, then Insert, and then Query.

4. Check Existing Essbase Connection to select the current Interactive Reporting database connection file (.oce), or select another from the drop-down and click OK.

   A new Interactive Reporting document file is created.

5. To populate the Catalog List, select Actions, then Retrieve Dimensions.

   The Catalog List shows the dimensions available to add to the query.

6. If prompted, enter your database user name and password in the DB User Name and DB Password fields and click OK.

7. From the Catalog List, select a dimension.

   To toggle the Catalog List between single and all dimension modes, click .

8. In the Catalog List, select a member dimension and select Query, then Add to Rows or Query  , then Add to Columns.

   Note:

   Members from the same dimension cannot be split across columns, rows and filters.

9. In the Catalog List, select a measure dimension and select Query, then Add to Rowsor Query, then Add to Columns.

10. To filter a member, select a member in the Catalog List and select Query, then Add to Filters.

11. Click Process.

    Note:

    If missing values are not displayed, it is possible that the Suppress Missing and Suppress Zero options are enabled. These options are enabled by default and can be disabled in the Query Options