Book Image

Extending Microsoft Dynamics AX 2012 Cookbook

By : Murray Fife
Book Image

Extending Microsoft Dynamics AX 2012 Cookbook

By: Murray Fife

Overview of this book

Dynamics AX is built on a number of foundation products from Microsoft that are used to make it bigger, better, and stronger than the average business system. Taking advantage of these products will make your life easier. Use these tools to maximize the efficiency of your business management, taking advantage of a powerful and centralized tool set. "Extending Microsoft Dynamics AX 2012 Cookbook" will show you how to use tools that you already have to extend out Dynamics AX and discover potential new directions. You will be surprised at what you can do on a shoestring budget. The book will allow you to streamline your work processes, and use the system's powerful and centralised features to the advantage of your organization. "Extending Microsoft Dynamics AX 2012 Cookbook" will show you how to maximize the potential of Dynamics AX with common and popular tools to enhance your business management systems. We will begin by exploring how to extend Dynamics AX out with SharePoint. After this, the book will guide you through important elements in maximizing business management efficiency, focusing on key aspects like reports, dashboards, and workflows. The book will then finish by teaching you how to customize your management systems, achieving a comprehensive coverage of the most important extension processes relevant to you and your business with very little programming. This is a book for those of you that want to make the most out of Dynamics AX by using what you already have, and without breaking the bank.
Table of Contents (18 chapters)
Extending Microsoft Dynamics AX 2012 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating a PowerPivot gallery in SharePoint


Up until now, we have just been creating dashboards and reports within Power View from the pre-defined cubes that are delivered with Dynamics AX 2012 R2 or later. You are not limited to those data sources for reporting though, and you can use Excel and PowerPivot for Excel to create your own data sources that you can report off. This is also an option that is available to all versions of Dynamics AX, so if you have not yet upgraded to the R2 or higher releases, then you can still take advantage of all the benefits of Power View for user reporting.

In order to use Power View in this way you need to have a PowerPivot Gallery site configured in SharePoint. This is where you will store your data sources, dashboards, and reports that you create.

If you do not currently have a PowerPivot Gallery site configured, then the following recipe will step through the process of creating the site in SharePoint.

Getting ready

Before you start on this example, you...