Database Connection File (OCE) Selection For Interactive Reporting Document (BQYs)

An Interactive Reporting document files (BQY) can be created using an Interactive Reporting database connection file (.oce) selected by the user. See table below for Interactive Reporting database connection file (.oce) eligibility:

Interactive Reporting Database Connection File TypeInteractive Reporting Web ClientEPM Workspace
RelationalYesNo
CubeQuery YesYes
OLAPQueryYesNo

  To create an Interactive Reporting document file (BQY) with an Interactive Reporting database connection file (.oce):

  1. Select File, and then New Document.

    Select a Task opens.

  2. Select Create an Interactive Reporting Document, and then click Next.

    Select Data Source opens.

  3. In the Data Source field, enter the name and path of the Interactive Reporting database connection file (.oce), or click Browse to locate the file.

    For more information about using the Browse feature, see Selecting an Interactive Reporting Data Source.

  4. In the Create As field, select either Web Client or HTML.

    • Web Client—Creates the Interactive Reporting document in Interactive Reporting Web Client using a connection file using a relational, CubeQuery, or OLAP Query data source.

    • HTML—Creates the Interactive Reporting document file in EPM Workspace. If you select an Interactive Reporting database connection field .oce from a relational, or OLAP Query data source, this option is not available.

  5. Click Finish.

    A new Interactive Reporting document file (BQY) is created based on the selected Interactive Reporting database connection file.