Develop a Report in Microsoft Dynamics AX 2012 "Define a Data Source"

A data source contains information about a connection to a database and includes
information such as the server name, the database name, and user credentials.
The following procedure explains how to define a data source so that you can
access the data from the Analysis Services database that contains the data for the
default General ledger cube.

1. In Visual Studio Solution Explorer, right-click the SampleCubeReport project, point to Add, and then click Report Datasource. The model opens in Model Editor.

2. In Model Editor, select the node for the data source.

3. In the Properties window, specify the following values:

o Name: ProfitAnalysisOlapData

o Provider: OLAP 

4. For the Connection String parameter enter the following:

Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Data
Source=localhost;Initial Catalog=Dynamics AX

NOTE: In a network with multiple servers, replace "localhost" with the name of the database server. It must be the name of the server that contains the database for the General ledger cube. In this  statement, Security Support Provider Interface (SSPI) is using Microsoft Windows user credentials for authentication. Dynamics AX is the default name of the Analysis Services database. 



Regards,
Hossein Karimi