Packt+ | Advance your knowledge in tech

You're reading from Extending Microsoft Dynamics AX 2012 Cookbook This is a brilliantly accessible book, packed with practical examples, that's perfect for business professionals who want to make more of the advanced features of Dynamics AX to save money and increase management efficiency.

Product type Paperback

Published in Aug 2013

Publisher Packt

ISBN-13 9781782168331

Length 314 pages

Edition 1st Edition

Tools

Dynamics AX

Concepts

Enterprise Resource Planning

Author (1):

Murray Fife

View More author details

Table of Contents (18) Chapters

Extending Microsoft Dynamics AX 2012 Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. Extending Out with SharePoint FREE CHAPTER

2. Reports and Dashboards

3. Dashboards, Charts, and Scorecards

4. Communication and Collaboration

5. Using Cases to Manage Incidents and Requests

6. Organizing Your Workflows

7. Reporting in Office

8. Talking to the Outside World

9. Creating Help

10. Web Services and Forms

11. Role Center Personalization and Customization

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.