Creating OLAP and Oracle | Hyperion Database Connections

  To create a document using the document creation wizard:

1. Perform one:

   • Select File, then New, then Database Connection.

   • Click , and select Database Connection.

2. From Database Connection, select a database connection:

   • Essbase

   • Financial Management

     There is an SAP BW and Relational option. See SAP BW Features Available in Web Analysis Studio and Creating Relational Database Connections.

     The Process bar displays steps for creating a database connection: Server, Database, Formatting, and Drill-through. On the Server page, you must enter the server name of your data source server, and the log on credentials used to access it.

3. In the Database Server text area, enter the name of the data source server.

4. In the Logon Information group, enter a user ID and password for accessing the data source server.

   The current user ID and password are entered by default, in case the data source server uses credentials that match.

5. Optional: If you want to save the credentials , select Save User ID and Password.

6. Click Next.

   Clicking Next queries the data source for application and database information. The content area displays the Database page.

7. From the list of Available Databases on the right, select a database.

   Databases are listed by application. When you select the database, the application and database name are loaded into the text area on the left.

   Note that Next and Finish are enabled at the lower right of the content area. The last two steps of the database connection wizard are optional. If you do not want to specify Measures Formatting or Relational Drill-through connectivity, click Finish.

8. Select one:

   • Click Next, to specify Measures Formatting or Relational Drill-through connectivity.

   • Click Finish, to skip these optional steps. If you click Finish, skip to step 12.

     Clicking Next queries the specified database for dimension information. The content area displays the Formatting page.

9. Optional: To specify measures formatting for the database connection, select a dimension from Formatted Dimension.

10. Optional: Specify a Measures formatting definition, by selecting from these options:

    Formatting Option	Description
    Formatted Dimension	Specifies the dimension to which the formatted member belongs.
    Advanced Member Selection	Specifies the single member or single advanced member selection to which the formatting definition is applied.
    Leading and Trailing Formatting
    Currency Symbol	Inserts the currency formatting symbols into the Positive Prefix and Negative Prefix text boxes.
    Positive Prefix	Enters character to precede positive numeric values.
    Positive Suffix	Enters character to follow positive numeric values.
    Negative Prefix	Enters character to precede negative numeric values. Warning: The minus sign (-) is the default prefix. Deleting the default prefix without replacing it causes negative values to display positively.
    Negative Suffix	Enters character to follow negative numeric values.
    Numeric Formatting
    Grouped Thousands	Displays numeric digits as grouped by thousands.
    Maximum Decimals	Indicates the maximum number of decimal places to display.
    Minimum Decimals	Indicates the minimum number of decimal places to display.
    Scale	Enables abbreviated value by tens, hundreds, thousands, ten-thousands, hundred-thousands, millions, and billions.
    Use Negative Color	Indicates that negative numbers are signified by a selected color.
    Select Negative Color	Enables you to select the color representing negative values.
    Replace Missing With	Replaces missing values with a text string or zero as indicated by the option.
    Font
    Header Font	Displays the Font Properties dialog box, for specifying Font family, point size, style, and color for the dimension header label.
    Data Font	Displays the Font Properties dialog box, for specifying Font family, point size, style, and color for the cell data values.

    Note that Next and Finish are enabled at the lower right of the content area. The last step of the database connection wizard is optional. If you do not want to specify Relational Drill-through connectivity, click Finish.

11. Select one:

    • Click Next, to specify Relational Drill-through connectivity.

    • Click Finish, to skip this optional step.

      If you click Next, the content area displays the Drill Through page. See Creating Relational Drill-Through.

      After clicking Finish, the Save As dialog box is displayed. It prompts you to navigate to the repository location where you would like the database connection file saved.

12. Navigate to the folder into which you want to save your database connection file:

    • Click Up to display the contents of the parent folder in the selection frame.

    • Click Home to jump to and display the contents of the current Home folder (set in preferences) in the selection frame.

    • In Location, type the path to the repository folder whose contents you want displayed, and press Enter.

    • In Location, click the drop-down arrow and select another location from the repository drop-down list.

    • When you navigate to another folder, you can click Previous to return to the last folder displayed in the selection frame.

    • Similarly, you can click Next to display the next folder in the location series.

      As you navigate, the selection frame lists the files and folders indicated by Files of Type.

13. Optional: When you reach the location where you want to save the file, enter a name for the database connection in Filename.

14. Click OK.

    Your database connection file is saved to the specified repository location.