I have been working on a Management Reporter project, for which I wanted to install and configure MR2012 CU14 from the scratch.
Completed the server and client installation, completed the Configuration Console processes, imported data from GP2015R2 (sample company) and reached a point where I wanted to test the default reports.
Ran the report and got the following message:
I checked everything, including the date range, data available in sample company and everything that I could remember. All were perfectly alright.
I was, however, getting some warning messages while the report was getting generated. Messages as follow:
This one was familiar. When we install management reporter, we get default reports along with it. It’s a nice and easy way to get started with MR, learn the concepts. However, it comes with its own headaches.
To name one (also most important), each default report row definition would have link to both Dynamics AX and Dynamics GP financial dimensions. To a GP consultant’s dismay, AX dimensions link would be placed in a column before GP dimensions link, as shown below:
Now let’s go back to the warning message. It says:
The row definition contains more than one financial dimensions link. Since the report does not use the row definition for reporting tree option, the report will use the *first* financial dimensions link to generate the report.
The first here being Microsoft Dynamics AX dimensions link. Thereby, rendering all reports with the message shown in the first screenshot on this post.
Alright, so I know the cause now. I know what I must do to get past this message. However, I had no clue HOW to do that. I mean, I know I must remove AX dimensions link column from the reports, but not sure how.
This community forum post answer from Sue tells us how to remove the link column. Too bad, this post was not marked as an answer.
I would, however, like to point to the standard & the easiest method to remove the unused link (in my case AX dimensions link).
- Either you can go to the Edit menu and click on “Row Links” as shown below:
- Or you can also use the tool bar button for “Row Links” as shown below:
Once you click on “Row Links” from either of the above steps, you should get the following window:
Once deleted, your report definition would have only one dimensions link, i.e. to Microsoft Dynamics GP link.
Report would then show the data as expected.
Of course, this would be the case if you want to reuse the default reports. This post would be irrelevant for those who design reports from the scratch.