Tuesday, 19 April 2016

AX 2012 Reporting services extensions and Analysis services configuration

AX 2012 - Reporting services extensions

Download the Microsoft Dynamics AX 2012 Feature pack from customer/partner source.

Click on the Validate system requirements

Select the option, which you want to install and verify all the pre requisites are installed properly.

After installation of pre requisite components, install the “Microsoft Dynamics AX Components”

Select the “Reporting services extensions” check box and proceed

Select the SQL Reporting services instance name.

If you want to deploy the reports after installation select the “deploy reports” option.

How to deploy SSRS reports Manually ?

Deploy reports using MS dynamics ax 2012 power shell:

Start -> All programs -> MS dynamics AX 2012 -> MS dynamics AX 2012 Management shell

 execute the below mentioned command

AX 2012 - Analysis services configuration

Install the analysis services on SQL server instance and install the “analysis services configuration” from the AX 2012 setup

Complete the prerequisites

Select the SQL Server analysis service instance service name

 Enter the business connecter proxy account username and password

Connect to AX 2012 Database to configure the Analysis services

Deploy the Analysis Services Project:

 Select the deploy option and "Next"