Walkthrough: Displaying KPIs in a Role Center

Dynamics AX 2009

After you create a cube and define KPIs for it, you can display the KPIs in a Business Overview Web part of an Enterprise Portal Role Center.

This walkthrough includes the following tasks:

  • Deploying an ODC file

  • Displaying KPIs in a Business Overview Web part

To complete this walkthrough, you will need:

In order for users to access cube data, you must deploy an Office Data Connection (ODC) file for the OLAP database that contains the cube to the Enterprise Portal server.

The following procedure explains how to deploy the ODC file.

To deploy the ODC file

  1. Open Microsoft Dynamics AX.

  2. On the Microsoft Dynamics AX menu, point to Tools, point to Business Intelligence (BI) tools, and then click OLAP Administration.

  3. In the OLAP Administration dialog box, click Deploy ODC Files.

    NoteNote

    ODC files are deployed to http:<server name>/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx.


You can now display the KPIs that you created in a Web part on your role center page in Microsoft Dynamics AX or Enterprise Portal.

NoteNote

If you have Microsoft Office Sharepoint Server (MOSS), you can display KPIs in a MOSS KPI List Web part.


The following procedure explains how to add the Sales Analysis KPI to a Web part in the Enterprise Portal CEO role center page.

To display the KPIs in a Business Overview Web part

  1. Navigate to the CEO role center that is located at http://<server>/sites/DynamicsAx/Enterprise%20Portal/RoleCenterCEO.aspx.

  2. On the Site Actions menu, click Edit Page. Locate the Middle Column section, and then click Add Web Part

  3. In the Add Web Parts dialog box, select Business Overview Web Part, and then click Add.

  4. On the Edit menu for the Web part, click Modify Shared Web Part. The properties for the Web part displays.

  5. For the Select mode property, select KPI List.

  6. Expand the Business Overview Setup node.

  7. For the Data Connection property, click the ellipsis button (…).

  8. In the Text Entry dialog box, type Data Connections/SalesAnalysis.odc, and then click OK.

  9. For the Title property, type Sales KPIs. Click OK to save the changes.

  10. In the Sales KPIs web part, click Add KPIs.

  11. In the Business Overview - Add KPI dialog box, select the Sales Analysis cube, select the Sales Revenue KPI, select Amount for the Display value as field, and then click OK.

  12. In the Sales KPIs web part, click Add KPIs.

  13. In the Business Overview - Add KPI dialog box, select the Sales Analysis cube, select the Items Sold via Internet KPI, select Number for the Display value as field, and then click OK.

  14. Click Exit Edit Mode to save the changes made to the page.

Community Additions

ADD
Show: