![microsoft sql business intelligence development studio microsoft sql business intelligence development studio](https://www.mssqltips.com/tipimages2/3428_InstallSSDT.jpg)
Dynamics AX CubesĪ cube is made up of measures and dimensions.
MICROSOFT SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO HOW TO
BIDS would need to be installed in order to be used. We can create another blog that explains how to use BIDS in more detail. Dynamics AX delivers a set of standard default cubes. General Ledger, Human Resource Management, Sales, Purchase, and Accounts Payable are a few of them. These cubes can be used as is, or they can be customized to better fit the business needs. Another option is to use Microsoft SQL Server Business Intelligence Development Studio (BIDS). Many people are most comfortable using excel as the analysis tool. One way is to export the data into excel. AX has a couple of tools that can be used to view the report information. In AX, the end product can be both reports and dashboards. A dashboard is a visualization tool that can display a set of metrics and/or KPIs (key process indicators). Examples of scenarios are: predictive analysis, product trends, and inventory management, to name a few. BI will take data from your business and organize it so it becomes useful information that can meet business needs. I would define BI most simply as getting the right data to the right people in the appropriate timeframe so they can make business decisions. Being a new user to AX, I wanted to spend some time researching BI in AX. I am fairly new to Microsoft Dynamics AX, but have years of experience in the Business Intelligence (BI) world. Dynamics GP to Dynamics 365 Business Centralīy Eric Meissner | Business Intelligence in Dynamics AX Overview.Dynamics NAV to Dynamics 365 Business Central.