Adding a Hyperion Essbase server data source

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

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}