Adding a Hyperion Essbase server data source

  1. Click Admin > Work with InfoSets > Add .
  2. Select Hyperion Essbase.
  3. Specify this information:
    User Name
    Specify the administrator user ID. The user you specify must have permission to access the Hyperion Essbase OLAP server.
    Password
    Specify the password for the administrator user ID you specified.
    Domain
    Specify the location of the users for authentication. The domain is the location of the users to be used for authentication. For Essbase authentication, specify Essbase as the domain.
    Essbase Enterprise Server
    Specify the name of the server that is running Hyperion Essbase Enterprise server.
    Application
    Specify the name of the machine running the Hyperion Essbase application.
    Database
    Specify the name of the Hyperion Essbase database containing the data to be used in the InfoSet.
    ORB Type
    Specify the Object Request Broker (ORB) used to talk to the server. Hyperion Essbase Enterprise Server supports CORBA, HTTP, EJB, or TCPIP.

    If you specify HTTP or TCPIP, you must specify a port number in the Port field.

    Port
    Specify the corresponding port number. If you specified any other ORB type, you must specify 0 in this field.
    OLAP Server
    Specify the name of the Hyperion Essbase server.
    Missing Text
    Specify the text Smart Notification will use to substitute for any missing data values. For example, n/a.
    Query
    Specify the query (report specifications). For more information about Essbase report specifications, see the Essbase documentation.

    These output parameters are required:

    • TABDELIMIT The output needs to be tab delimited for Smart Notification to parse it.
    • SUPALL, COLHEADING, NAMESON, PAGEHEAD SUPALL suppresses all of the extraneous report-type output, for example, header outlines. However SUPALL also suppresses other information needed by the query. This is the shortest expression that will suppress the extraneous output, yet retain important things like column headers, page headers, and member names.
    • ROWREPEAT This parameter causes member names to be repeated across the rows and columns. This parameter eases parsing, but it also increases the amount of data returned from the server.
    • SINGLECOLUMN Essbase flag or displaying the column heading when there is only one column member.
    • SUPSHARE Required to suppress the display of duplicate shared members when generation/level extracts are performed.

      INDENTGEN 0 This parameter prevents extraneous spaces from preceding a member name (indicating its level in the hierarchy). Since Smart Notification does not do anything with levels, not requiring this parameter would result in trimming each member as it comes back from Essbase, thus causing a performance issue.

    For example, {TABDELIMIT SUPALL COLHEADING NAMESON ROWREPEAT BLOCKHEADERS PAGEHEAD INDENTGEN 0 DECIMALS VARIABLE SUPMISSING INCZEROROWS}

  4. Click Preview after you have completed the fields on the form.Smart Notification returns a data sample based on the query you provided.
    • If you have specified any parameters for the data source, a form listing the parameters along with text boxes appears. Use this form to specify a value for each parameter.
    • If Smart Notification does not return data, check your query statement for errors.