Configuring a PerformancePoint workspace to connect to the Dynamics AX cubes

Once you have access to the PerformancePoint Dashboard Designer you can then connect it to the default cubes that are delivered with Dynamics AX. Dynamics AX 2012 is delivered with 10 standard cubes for reporting, and Dynamics AX 2012 R2 increases the number of cubes available to 16. The cubes that are available, as of writing this book, are:

• Accounts payable

• Accounts receivable

• Budget control

• Budget plan

• Environmental sustainability

• Expense management

• General ledger

• Inventory valuation

• Production

• Profit tax totals

• Project accounting

• Purchasing

• Retail

• Sales

• Sales and marketing (also known as, Customer Relationship Management before R2)

• Workflow

In this recipe, we will show you how you can connect these cubes to a PerformancePoint workspace so that you can start creating charts and scorecards against the data.

Getting ready

Before you start on this example, you will need to make sure that you have deployed your analysis services cubes...