Page 1 of 19112345678910...2025303540...Last »

Management Reporter – This report view contains no data.

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:

Screen Shot 2016-02-10 at 09.44.58 AM

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:

Screen Shot 2016-02-10 at 09.47.43 AM

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:

Screen Shot 2016-02-10 at 09.56.46 AM

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:

Screen Shot 2016-02-10 at 10.08.15 AM

  • Or you can also use the tool bar button for “Row Links” as shown below:

Screen Shot 2016-02-10 at 10.06.30 AM

Once you click on “Row Links” from either of the above steps, you should get the following window:

Screen Shot 2016-02-10 at 10.13.02 AM

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.

Screen Shot 2016-02-10 at 10.16.26 AM

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.

Happy Reporting!

VAIDY

Filed under: #MSDYNGP, GP Reporting, Management Reporter, Reporting, Troubleshooting, Uncategorized

Originally posted here:
Management Reporter – This report view contains no data.

February 10, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 5

Find All Custom SQL Objects In Database | azurecurve

CREATE VIEW uv_AZRCRV_GetCustomObjects AS /* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons … MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View …

Read More:
Find All Custom SQL Objects In Database | azurecurve

February 3, 2016 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 8

GPUG farewells Kim “Mamma” Peterson as she takes up a new role

David Meego - Click for blog homepageToday is a sad day in the GPUG community. We are losing Kim “Mamma” Peterson from the Dynamics Communities team where she has been GPUG Program Director for the last five years.

Kim has done an awesome job and leaves GPUG on a high as she takes up a new role as Director of User Experiences for InterDyn BMI.

Thank you Kim for all the support you have given to the community and the advice and encouragement you have given to me. GPUG would not be where it is today without your work, smiling face and great laugh.

GPUGAllStar6
Kim at GPUG Summit 2015 awarding GPUG All Stars myself, Viola and Steve

Here are some videos of Kim’s fun side:

Tim Tam Slams at Convergence 2012 (direct link)

 

Kim Peterson doing the Tim Tam Slam at Microsoft Convergence 2015 in Atlanta (direct link)

 

Have a read of the posts on the GPUG blog:

Good luck with the new role, hope to see you soon at the conferences.

David

PS: Kim, I will still need my hugs.

PPS: Please post in the comments if you have something to say to Kim.

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: GPUG, News Tagged: GPUG, News

Read the article:
GPUG farewells Kim “Mamma” Peterson as she takes up a new role

January 29, 2016 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 15

#Skyworks2016 – Australia Day 2016

David Meego - Click for blog homepageI am back in Perth after enjoying time in Sydney with family and a cruise (with other family) from Sydney around New Zealand.

Time to work on catching up with the email backlog and getting back into projects for 2016. But it might be a couple more days before the work really gets going….

Tomorrow (Tuesday, 26th January 2016) is the Australia Day 2016 public holiday, and so many people are taking today (Monday) off as well to create a four day long weekend. I know this also happens in the US around their equivalent, Independence day.

While Sydney is know around the globe for its New Year’s Eve fireworks, Perth waits for Australia Day for its Skyworks fireworks and laser show, put on by the City of Perth and Mix 94.5fm. For additional info click here.

Below are some photos from previous year’s shows as well as some videos of the 2015 show:

Skyworks2013BenNewport
Skyworks 2013

Skyworks2014
Skyworks 2014

Skyworks2015NeilLaw
Skyworks 2015

Skyworks2015ThomasDavidson
Skyworks 2015

Perth City Skyworks 2015 (direct link)

 

Australia Day Skyworks 360 Video (direct link)

 

Perth City Australia Day 2015 Skyworks HD (direct link)

 

For those of you in Perth going to see the show live, have fun.

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Fun, News Tagged: Fun, News

More:
#Skyworks2016 – Australia Day 2016

January 25, 2016 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 28

Happy New Year 2016

To the GP Community:

Happy New Year 2016!

This year is slated with lot of interesting releases for GP impending. I am absolutely as excited as all of you.

Let’s wish this year be an excellent year for Dynamics GP and its success.

VAIDY

Filed under: #MSDYNGP, New Year, Off-Topic, Uncategorized

See the original post:
Happy New Year 2016

January 1, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 56

Customization Maintenance: “Unable to open … – azurecurve

Management Reporter Is Unable To Connect To The Company · Form Customisation … Media & Other Sites. MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View azurecurve on facebook View azurecurve on Google+ azurecurve Development azurecurve WordPress Plugins …

Visit link:
Customization Maintenance: “Unable to open … – azurecurve

December 30, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 41

Changing The Logical File Names Of A SQL Database | azurecurve

Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). … MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile …

Continued here:
Changing The Logical File Names Of A SQL Database | azurecurve

December 28, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 36