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 sytem requirments
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"
If you have any quries regarding the Installation and configuration, let me know...
Hi singu
ReplyDeleteHope you are doing good.
I was recently going through your blog post on SSRS and SSAS installation guide. I have couple of questions for you.
Please go through the scenario below.
I want to have an installation like i have one running STD AX installation with DB for Ex: AXDB.
Now I want to have reporting services and analysis services configuration.
From your blog its quite evident that , you have used two different instances of DB for SSRS(reporting services) and SSAS(analysis services).
Assume i have followed, your blog and installed it, and it went well. Now i have 3 DB instances
1. AXDB
2.AX-DB-SSRS
3.AX-DB-SSAS ya.
Now in my STD installation, i make an entry for few Sales order, and the data is going sit in AXDB,
My requirement is when Area sales manager logs in into the system, i have to show him, area wise Sales for Product X, for the current quarter, in his Role center how to manage it?
The updated data is in AXDB instance, and AX-DB-SSAS does not have record of new SO generated in AXDB. how to manage that?
As per my understanding Ax-DB-SSAS should be replica of AXDB, so it should be handled through a batch job, that updates the AX-DB-SSAS periodically?
please let me know.
Hi,
ReplyDeleteI have Configured Analysis Services as per above post, but I can't above receive the Cube details of Dynamics AX(Std Cube) in Excel.
Pls Help me...(After Dployment)
I install database SQL Server 2012 on Windows Server 2012 and Dynamic AX 2012 R2 on another server and trying to install Reporting Service on 3rd server and getting the following error.
ReplyDeleteMicrosoft SQL Server reporting service web service
“Microsoft sql server report service provides access to the full functionality of the report server through XML web service web service method expose the functionality of the report server and enable you to create custom tool for any part of the report life cycle”
Waiting for the reply from the blog