Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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.

↑ Back to the top

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.


↑ Back to the top

Resolution

Please contact Support for assistance with synchronizing the dimension names in your Management Reporter 2012 reports with your Dynamics SL data mart database. 

↑ Back to the top

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.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2807488
Revision : 1
Created on : 1/7/2017
Published on : 9/8/2015
Exists online : False
Views : 367