Problem with multiple dimensions in Management Reporter

(0) Share

Report

Posted on by bcool

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

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

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.
Community Member on at

Like (0)

Report

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.
bcool on at

Like (0)

Report

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.
Cory Severson on at

Like (0)

Report

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.

Community site session details

Problem with multiple dimensions in Management Reporter

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates