Troubleshoot the reporting framework [AX 2012]

The report server cannot be validated
If you cannot validate the report server, do the following:
■ Click the Create button in the Reporting Servers form, which is located at Tools > Business Intelligence Tools > Reporting Servers, and make sure that a report folder and data source have been created on the report server. Click the Validate button.
■ Ensure that firewall settings are configured appropriately on the computer that is running the
report server.
■ Ensure that both the report manager and report server URLs are correct.
■ Ensure that the Microsoft Dynamics AX user has permissions on the computer that is running
the report server.

A report cannot be generated
If you are connecting to the Microsoft Dynamics AX SQL Server database and the system will not generate a report, do the following:
■ Ensure that the report server account configured in the report data source on the report
server has read permissions on the Microsoft Dynamics AX SQL Server database.
■ Ensure that firewall settings are configured appropriately on the computer on which the
database is installed.
If you are connecting to an external or custom data source, make sure that the user name and
password provided for the report server account in the data source on the report server are correct.

A chart cannot be debugged because of SharePoint sandbox issues
If you cannot debug a chart because of problems with the SharePoint sandbox, do the following:
■ Add a reference to the Microsoft.SharePoint.dll assembly to the project.
■ Establish the default web control to run in debug mode.
■ Edit the file named Default.aspx in the EP Chart project.
■ Add the ManagedContentItem property to the <dynamics:AxUserControlWebPart> element
and set the value to the name of the web control.

Walkthrough: Displaying KPIs in a Role Center [AX 2012]

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

The following procedure explains how to add the Sales Analysis KPI to a web part in the 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 Categories list, click Microsoft Dynamics AX. In the Web Parts list, select Business overview, and then click Add.

4. On the drop-down menu for the web part, click Edit Web Part. The properties for the web part are displayed.

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

6. Expand the Business Overview Setup node.

   Note

   The Business Overview web part points to the default Dynamics AX Analysis Services database. You can use any KPIs that ship with Microsoft Dynamics AX and any KPIs that you add to that database. If you create another database, you must create an Office Data Connection (ODC) file that points to that database. You then must specify the location of the ODC file in Data Connection.

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

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

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

   Note

   If you created a new Analysis Services database that has only the SalesAnalysis cube, you do not need to select a cube in the Business Overview - Add KPI dialog box.

10. Click Stop Editing to save the changes made to the page.

Filtering a DataSet from Code behind

Enterprise portal allows filtering the list pages using the Filter control available on the EP Grid.

The Filter control provides a UI to select the field, criteria and the values you want to filter the grid.

It is also possible to add multiple conditions.

But there may be scenarios where you want to use your own controls to filter the grid or the underlying DataSet.

The EP framework provides the following classes to do this –

- FilterObject

- ConditionType

Let’s look at how we can do the filtering from code behind.

1. Add a Filter to list only the Customer whose name that starts with “Light”

2. Using Between operator – Between operator is a special case. There are two ways to use the Between operator -

a. Using – value..value

b. Using – valueCollection class

3. How do I use more than one condition -

4. Filter on a date – which format should a date be in? Is there a single format which can always be used?

When using the Filter control available in EP Grid, the date will be in user regional settings.

But when using from the code behind, the IIS server’s regional settings will be applicable.

So if the regional settings on the IIS are ‘MM/DD/YYYY’ the date value must be specified in ‘MM/DD/YYYY’ format.