Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Problem with multiple ...
Microsoft Dynamics GP (Archived)

Problem with multiple dimensions in Management Reporter

(0) ShareShare
ReportReport
Posted on by bcool 2,469

I'm having a problem combining dimensions in my column definition. My accounts consist of a 3-digit Department segment followed by a 6-digit Main segment, and a 3-digit Suffix.

I'm trying to code a Dimension Filter to include all accounts in departments 500 & 510, plus all Main segments that start with '573' no matter what department.

If I code this in the filter, I get all the 573xxx accounts, for all departments:

   +Main = [573*]

If I code this, I get all the accounts in departments 500 & 510 only:

   +Department = [500] +Department = [510]

But if I code this, I only get accounts 573xxx in departments 500 & 510:

   +Main = [573] +Department = [510] +Department {500]

It appears to be combining all the criteria together, rather than treating them separately. By the way, I entered the values on separate lines in the Dimensions window (what appears when you double-click in the Dimension Filter box).

*This post is locked for comments

  • Cory Severson Profile Picture
    Cory Severson 695 on at
    Re: Problem with multiple dimensions in Management Reporter

    Hello bcool,

    I did look into this and it appears that MR will make it so it uses all items in the filter in combination with each other.  I don't think this would be desired functionality.  

    I think what Jake mentioned may work or you could try filtering 3 columns and add them together.  If neither of these methods work I would suggest creating a support case so we can really dig into this.

  • bcool Profile Picture
    bcool 2,469 on at
    Re: Problem with multiple dimensions in Management Reporter

    I haven't been able to try your suggestion out yet...I'm in the middle of month-end processing right now.

    So, you're saying that Management Reporter can't always duplicate the Account Filter functions in FRx? In my above scenario, I could code the following in an FRx account filter to accomplish what I'm trying to do:

    500-??????-???,510-??????-???,???-573???-???

    FRx would look at each condition separately to determine whether or not to include an account on the report - all accounts starting with '500-', PLUS all accounts starting with '510-', PLUS all accounts starting with '573' in the middle segment.

    If I do something like this in Management Reporter, it combines the conditions, resulting in only those accounts starting with '500' or '510' that have '573' in the middle segment.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Problem with multiple dimensions in Management Reporter

    I wanted to check with you to see if you had any further questions on this topic.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Problem with multiple dimensions in Management Reporter

    I believe MR does look at all the dimension criteria together for a particular column. Since the two things you want conflict (all departments and only certain departments), I would recommend you break the two filters out into separate columns. If it makes sense to have the data separate, simply leave the two columns on the report and you're done. If you want to see the data together, make both columns non-printing and add them up with a separate printing CALC column.

    There might be other ways to get the data you want but it is difficult to provide information on this through the forums. If you need detailed assistance, I would recommend creating a support case.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans