Analysis servers (form)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click System administration > Setup > Business intelligence > Analysis Services > Analysis servers.

Use this form to manage the Microsoft SQL Server Analysis Services servers and databases that are integrated with Microsoft Dynamics AX.

Note

To view all the information that is available in this form, you must be assigned to the server administrator role in Analysis Services. For information about how to assign users to this role, see Grant Server Administrator Permissions (Analysis Services) in the SQL Server documentation.

Task that uses this form

Deploy the default cubes

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

OLAP servers

Enter or view the names of the servers that run Analysis Services.

OLAP databases

View the names of the Analysis Services databases for the selected server. This tab lists only the databases that have been deployed by using the Analysis Services Project Wizard or Windows PowerShell scripts.

Advanced

Record events in a log file when you run the Analysis Services Project Wizard or use Windows PowerShell to manage Analysis Services projects and cubes.

Buttons

Button

Description

Exchange rate information

Open the System currency and exchange rate type form.

Fields

Field

Description

Partition key

The partition key.

Partition keys are defined in the Partitions form. For more information about partitions, see Data partitioning architecture.

Note

This control is available only if Microsoft Dynamics AX 2012 R2 or AX 2012 R3 is installed.

OLAP server name

Enter the name of the server that runs Analysis Services.

Description

Enter a description of the server that runs Analysis Services.

Default (OLAP servers tab)

Follow the directions that apply to the Microsoft Dynamics AX version that you are using:

  • If you are using Microsoft Dynamics AX 2012 R2, select a default Analysis Services server for each partition. A partition may have multiple Analysis Services servers. However, the partition must have only one default server.

  • If you are using Microsoft Dynamics AX 2012 or Microsoft Dynamics AX 2012 Feature Pack, select the default Analysis Services server. You connect to this server when you run the Analysis Services Project Wizard.

Database name

The names of the Analysis Services databases for the selected server.

Default (OLAP databases tab)

Select a default Analysis Services database. Key performance indicators (KPIs) are retrieved from the default database.

Enable logging

Select this check box to record events in a log file when you perform the following tasks:

  • Run the Analysis Services Project Wizard.

  • Use Windows PowerShell to manage Analysis Services projects and cubes.

Log file

Browse to the location where you want to save the log file.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).