Data can be analyzed by using Microsoft SQL Server Management Studio to connect to a Microsoft Dynamics AX OLAP cube.
To analyze the General Ledger cube data by using Microsoft SQL Server Management Studio you must connect to the cube data that is deployed and processed in a SQL Server Analysis Services (SSAS) database.
Follow these steps to analyze cube data:
1. Open Microsoft SQL Server Management Studio.
2. On the Connect to Server page, for the Server type field, select Analysis Services. Enter the name of the server that contains the Analysis Services database for the General Ledger cube, enter the
credentials used to access the server, and then click Connect.
3. Right-click Databases > Dynamics AX > Cubes > General ledger cube and then click Browse.
NOTE: The name of the database that contains the General Ledger cube can vary.
4. In the General ledger cube [Browse] window, drag Measures >Ledger transactions > General ledger amount - transaction currency onto the data region area.
5. In the General ledger cube [Browse] window, drag Chart of accounts > Main Account onto the row field area.
NOTE: The available dimensions will vary depending on your Analysis Services
Project.
6. Browse the data.
Regards,
Hossein Karimi
Friday, July 20, 2018
Analyze Cube Data with Management Studio
+10 years of experience with hands-on lead-level background in the full life cycle of software development with demonstrated cross-functional team leadership skills.
Programming:
• ERP :Microsoft Dynamics AX 2012
• Language :X++, C#, C++, XAML, Asp.Net, Html, VB.Net, Android
• Environment : Windows XP, Windows 8, Windows 10, Windows Server
• DataBase : Oracle 9i,10g,11g and SqlServer and SQLlite
Subscribe to:
Post Comments (Atom)
Configure the Firewall on the Enterprise Portal Server
After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...
-
To integrate Microsoft Dynamics AX and Analysis Services, you must connect Analysis Services to the Application Object Server (AOS). To do s...
-
The below select query will give the both the Sales Line record count and the sum of sales quantity. static void Test_Data(Args _args) ...
-
In Reporting Services, reports and resources are processed under the security identity of the user who is running the report. If the report ...
No comments:
Post a Comment