Management Reporter 2012 report may return no data after you change to Dynamics SL Data Mart Provider

Symptoms
Your Management Reporter 2012 reports may return no data after you change from the Dynamics SL data provider to the Dynamics SL data mart adapter. You may also see plus signs (+) in your row definitions under the Link to Financial Dimension column.
Cause
Management Reporter uses the dimension name to identify the segments used in your report definitions. These dimension names are pulled into the Dynamics SL data mart adapter differently than the Dynamics SL data provider. If the dimension name in the report does not match the name in Dynamics SL data mart adapter, the report will not generate correctly.

Example 1:

In Microsoft Dynamics SL, the accounts in the Chart of Accounts(01.260.00) in General Ledger are represented by their own Management Reporter dimension.
This dimension is called “Natural” in the Dynamics SL data provider.
This dimension is called “Account” in the Dynamics SL data mart adapter.


Example 2:

In a Microsoft Dynamics SL demo database, open Flexkey Definition(21.320.00) in Shared Information. Specify SUBACCOUNT in Field Type. You see that “Reporting Unit” is the description of Seg #1.
This dimension is called “Segment_02” in the Dynamics SL data provider.
This dimension is called “Reporting Unit” in the Dynamics SL data mart adapter.


Resolution
Please contact Support for assistance with synchronizing the dimension names in your Management Reporter 2012 reports with your Dynamics SL data mart database. 
More information
The Management Reporter 2012 TDBX Update tool can be used to update the dimension names. To use the tool, you must first export your reports from MR. To do this, click Company and then click Building Block Groups. Select your building block group and then click Export. Select all Reports, Rows, Columns and Trees. Click Export and then select a location to save the .TDBX file to. Once you have saved the .TDBX file, follow these steps to use the tool:

  1. Go to https://home.diagnostics.support.microsoft.com/SelfHelp
  2. Select: Dynamics AX Management Reporter 2012 TDBX Update Diagnostic. The name contains Dynamics AX, but this will work for all ERPs.
  3. Click Create and Download.
  4. Choose to Run or Save.
  5. Browse to the location of the TDBX file you created.
  6. Select the dimension name you want to change. Using Example 1 from above, you would select "Natural".
  7. Click Next and then type the new name for the dimension. Using Example 1 from above, you would type "Account".
  8. Click Next and a new .TDBX file will be created. The new file name will be Updated.tdbx and will be created at the same location as your original .TDBX file.
You can now import the updated TDBX file by clicking Company and then clicking Building Block Groups, in MR. Click New and create a new buidling block group. Click Import and browse to the Updated.tdbx file and then click Open. Once the import has completed, click Company and then click Companies. Select your company, click Modify and select the new building block group.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2807488 - Last Review: 09/08/2015 16:14:00 - Revision: 1.2

Microsoft Management Reporter 2012

  • kbmbsmigrate kbsurveynew KB2807488
Feedback