Displaying the Properties pane

The Properties pane displays the properties of items you select in the Database Structure or Accessories pane (for example, the value of a variable or slice selected in the Accessories pane).

To open the Properties pane, select View > Properties or press <F4>.

Click Alphabetical or Categorized to sort the properties alphabetically or by category.

Properties of a database alias

This table shows the properties of a database alias:
Property Description
Connect at Log-on If True, you connect automatically to the selected alias when you log on to Application Studio.
Command time-out Specifies the seconds the database server waits to execute a command. Not available for all alias types.
Connection string Displays the parameters of the selected connection to the database.
Connection time-out Specifies the number of seconds the client waits to be connected to the database server.
Authentication type Specifies the system of authentication used to log on the user to the database. The selection of the authentication system depends on the database provider.
  • Basic: Uses the user name and password of the user who is logged on to the repository. The ticket created by the repository is used to authenticate the user. The properties User name and Password are disabled.
  • Windows:The log-on information of the Windows account is used. The properties User name and Password are disabled.
  • Kerberos: The log-on information of the Windows account is used. The Kerberos protocol authenticates the user. The properties User name and Password are disabled.
  • HTTP: A specified user name and password are used for the authentication. The authentication is executed through the HTTP protocol.
  • Infor: Infor authentication can be used by all Infor components.
Required Status of the Event Agent (Infor OLAP Server only)
  • Any: The connection is established independent of the status of the Event Agent.
  • Running: The connection is only established when the Event Agent is running.
  • >=Paused:The connection is established when the Event Agent is paused, stopped or disabled.
  • >=Stopped:The connection is established when the Event Agent is stopped or disabled.
  • Disabled:The connection is only established when the Event Agent is disabled.
User Name Displays the name of the user who is connected to the database (only for connections through HTTP).
Database Name Displays the name of the database.
Name Displays the database alias. You can edit this name.
Server Name Displays the name of the server on which the database is located.

Properties of calculations

This table shows the properties of calculations:
Properties of calculations Description
Expression The expression which defines the calculated element.
Format String The format of the cell value.
MDX Definition The MDX definition of the calculated element.
Parent The unique name of the parent to which the calculation belongs.
Order of creation Displays the order of creation of calculated elements that are based on each other.
Visible Specifies whether the calculated element is displayed on the spreadsheet (invisible, when this value is set to 0).
Solve Order Specifies the solve order of the calculations.
XML Definition XML definition of the calculation.