AliasTable (Method)

Applies To:

DBSpecific object (Essbase and DB2 OLAP only)

Description:

Enables you to use aliases to assign custom names to database physical members or generation/level names. Essbase stores aliases in an Alias Table in the cube. Since cubes can have multiple alias tables, you can select the alias table and modify the query based on the value you enter.

The AliasTable (Method) prompts users to process queries. The PromptOption argument determines if a dialog displays from which users specify a value of 1 (OK) or 2 (Cancel).

The PromptDialog determines if the dialog box displays. The two arguments can work together or separately. If both arguments are specified, the dialog box displays with the prompt option as the default selection (user can then change the option when prompted with the dialog box). If only the PromptOption argument is specified, no dialog displays and the prompt option is executed. If only the PromptDialog argument is specified, the dialog displays with the default prompt of OK. If neither option is specified, then no dialog appears and the default option of OK is assumed.

The AliasTable (Method) prompts a user to use the process command.

Syntax:

Expression.AliasTable(String AliasTableName,Number PromptOption, Boolean PromptDialog)

Expression Required:

An expression that returns a database specific object

Example:

This example calls the Beep function of the Kernal32.dll for 4 seconds with 5000Hz:

ActiveDocument.Sections["OLAPQuery"].DBSpecific.AliasTable("default", 2, false)