Other Web Analysis Properties

Table 16. Other Web Analysis Properties

PropertyDescription
MailServerLocal host where the mail server is located
ThinClientPrintDefaultPrint type in EPM Workspace
  • ThinClientPrintDefault=PDF launches a browser instance with the output of the Web Analysis document or report object embedded in Adobe Reader.

  • ThinClientPrintDefault=HTML launches a separate browser instance that displays the selected object.

WAStudioMenuControlLocation of the XML file definition that controls the shortcut menu options that users see

For example, WAStudioMenuControl=c:/Hyperion/Analyzer/conf/WAMenu.xml.

ModuleNameModule to which the XML file defined with WAStudioMenuControl applies. Default is WebAnalysisStudio.
ShowSelectLayoutWhether a Layout dialog box appears during new document creation
UseSecurityAgentTokenWithoutDomainWhether HYAURLParamHandler.getSecurityAgentTokenParam cuts off the domain name in a fully-specified user login ID
SSOProviderSessionCookieIDName of the SSO cookie. Possible value are:
  • SMSESSION (SiteMinder)

  • OHS<fully qualified host name><port> (Oracle SSO)

  • PD-S-SESSION-ID/PD-H-SESSION-ID (WebSeal)

UseRemoteUserWhether to search for removed from HTTP request REMOTE_USER header to get Security Agent Token (Applet Parameter)

Note: Must be set to yes for Oracle AS SSO

NativeAppServerSSLSupportWhether to start the Web Analysis application server on a WebLogic server with SSL configuration
EnableTwoWaySSLWhether to enable two-way SSL authentication

When set to true with a protocol of https, users are prompted to enter the client’s keystore location, keystore password, and key password. This enables the Java client to establish a two-way SSL connection with the server. The supported keystore type is PKCS12.

ssl.keystore.filePath to the client’s certificate on the Web Analysis server. The certificate is used for establishing a two-way SSL connection from the server to other resources.
ssl.keystore.passwordPassword to the keystore file defined in ssl.keystore.file
ssl.key.passwordPassword to the personal key located in the keystore defined in ssl.keystore.file

Note: Passwords to the keystore and the personal key can be different in common case, which is why both of them are required.

SessionScopeTimeoutJava session timeout in seconds
FastResolveEssbaseSubscriptionsHow to generate dimension member lists for subscription controls
  • If yes pass-through methods are used and Web Analysis performance is improved as long as you are not conducting hybrid analysis

  • If no, standard Essbase resolve member methods are used to generate dimension member lists for subscription controls.

ExcelPathPath where Web Analysis should search for the Microsoft Excel executable file. For example:

ExcelPath=c:/my_excel_path/excel.exe.

ShowPathtoExcelDlgWhether to provide a path to the Excel executable
  • If yes, users must specify the exact path to the executable, and Excel is started with exported data loaded.

  • If no, a program associated with the exported file extension is started.

ShowPathtoMSOfficeExecutableDlgWhether to provide a path to the MS Office executable
  • If true, users must specify the exact path to the executable.

  • If false, a program associated with exported file extension is started.

This property covers all supported MS applications (Word, Power Point and Excel). If specified, the ShowPathToExcelDlg property specific to Excel takes precedence over this one.

FormatToolTipsControls the format of data value tooltips.
  • If yes, tooltips display data values in unformatted scientific notation

  • If no, tooltips display data values in a format that matches the spreadsheet grid

LogQueriesWhether to redirect the ALE query report and Essbase report specification created by ADM to the Web Analysis output log. Setting this value to no minimizes the amount of logged information.
LoadAllDataWhether to request data for all pages instead of just the current page
ExportDataFullPrecisionWhether to export data values directly from data sources to Microsoft Excel (in lieu of data values with client-based formatting)
SuppressSharedDuplicatesInSearchWhether the search in the Dimension Browser returns shared (duplicate) members
  • If no, duplicate members are returned and listed in the selected member pane.

  • If yes, duplicate members are not displayed in the Dimension Browser.

DisableSparseForSuppressMissingWhether to disable the sparse extractor when SupressMissing is selected
SQLGrid_DrillOnRowDrill behavior for rows on a grid
  • If yes, during a drill link from the SQL grid (not relational OLAP), the drill takes place on the entire row for all mapped columns.

  • If no, the drill is not performed on the selected cell or region of cells.

AnalyzerBaseURLThe base URL for Web Analysis. For example:

AnalyzerBaseURL=http://myserver.hyperion.com:19000/WebAnalysis

XLSeparateColumnsWhether different OLAP spreadsheet generations must appear in different columns during Formatted Export to Excel. Changes the default way spreadsheet columns are formed when exporting to Excel.
ClusterWhether Web Analysis works in a cluster so additional services will be initialized
atf.messaging.provider-urlExplicitly specifies the JMS provider URL as:protocol://host:port (for example: t3://example.com:16000)
atf.messaging.context-factory(Optional) JMS initial context factory class name to be used in a cluster
atf.event.broker.idle-timeHow often synchronization events are checked by the Web Analysis asynchronous processor. Minimum value is 1001.
WordPathPath where Web Analysis should search for the Microsoft Word executable file. For example:

WordPath=c:/my_word_path/winword.exe.

PPTPathPath where Web Analysis should search for the Microsoft PowerPoint executable file. For example:

PPTPath=c:/my_ppt_path/powerpnt.exe.

DecryptOldPasswordsWhether to disregard older logic so that older passwords are not readable
  • If yes, old passwords are re-encrypted with a new algorithm.

  • If no, users will be asked for a password when trying to open/import reports with old encrypted passwords.

HISPagingBarHideWhether AIS Drill-Through reports paging is disabled
SQLPagingBarHideWhether result set paging is disabled for SQL
HISPagingBarRowsPerPageNumber of rows per page for AIS Drill-Through reports
SQLPagingBarRowsPerPageNumber of rows per page for SQL spreadsheets
DisableQuickDrillUpDisables attempts of performing the "quick" or “heuristic” drill-up for a set of certain drill-up use cases which are expected to be easy to handle
ExcelExportMaxRowsMaximum rows in a Web Analysis document exported to Excel
ExcelExportMaxColumnsMaximum columns in a Web Analysis document exported to Excel
EnableExpectContinueEnables the 'Expect: 100-Continue' support for Oracle's Hyperion® Web Analysis applets. This connectivity tuning option is enabled by default.
nosecurecookieWhether to set the SECURE flag for cookies generated in an application when SSL is used
atf.session.binding.kill-with-prejudiceWhether to make terminating the user session ineffective.
  • If yes, terminating the user session is possible when a “kill” request comes from the server console or when the maximum session inactivity timeout is reached.

  • If no, terminating the user session is not possible when a “kill” request comes from the server console or when the maximum session inactivity timeout is reached.