web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 Management Rep...
Microsoft Dynamics AX (Archived)

AX 2012 Management Reporter - Wildcard Range Not Functioning As Expected

(0) ShareShare
ReportReport
Posted on by PaladinSteve 290

Hello all,

I am having a problem getting groups of cost centers to report correctly in Management Reporter.

As an example, I have three rows defined as follows (the last 2 digits define the department, such as Accounting, while the first 2 are a location identifier):

+MainAccount = [50000:59999], CostCenter = [??10:??29]

+MainAccount = [50000:59999], CostCenter = [??30]

+MainAccount = [50000:59999], CostCenter = [??40:??99]

The row containing [??30] calculates correctly. The other two rows are returning results for all combinations from ??10 - ??99 - the same results on both rows.

Current MR version is 2.1.8001.0.

Any help or suggestions would be appreciated, especially if anyone knows if this has been fixed in a Hotfix or Cumulative Update - I'm not finding it if it has.

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello PaladinSteve, Rather than using Wildcards have you tried using the "from ... to" specifications that you can make for the different main account - financial dimension combinations? Ludwig

  • PaladinSteve Profile Picture
    PaladinSteve 290 on at

    Hello Ludwig, The problem with that solution is that because those ?? wildcards are replacing 3 locations currently, it would triple the number of definitions for many of the lines in the income statement row definition, if I am understanding your suggestion correctly. It also means I would have to manually add definitions when a new location is added, which is likely.

    Am I correct that you are proposing I do something like this for every affected line?

    +MainAccount = [50000:59999], CostCenter = [0040:0099] + MainAccount = [50000:59999], CostCenter = [0140:0199] + MainAccount = [50000:59999], CostCenter = [0240:0299]

  • Suggested answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    I believe that it is another engine running this then the standard AX querry utility. Reason being that the syntax is different then in AX.

    Also the syntax seems to be a bit odd if you want from/to values... ??xx:??xx would result in multiple ranges.

    Does *xx:*xx work?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello PaladinSteve,

    The use of wildcards as you intend is not recommended / supported in each and every MR version. Please have a look at the following whitepaper (page 19) where it says that you should better use ranges.

    www.google.de/url;rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwjA2biem5jKAhXECiwKHWthAAAQFggrMAE&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F7%2F8%2FA%2F78A3710A-9D72-4908-B302-CD54B5130096%2FDynAXDataProvInstGuide.pdf&usg=AFQjCNERTj6-7P261yZuzxJ8JOskR4RdBA&bvm=bv.110151844,d.bGg

    Best regards,

    Ludwig

  • PaladinSteve Profile Picture
    PaladinSteve 290 on at

    Apologies for the delay in replying.

    Ludwing, I am unable to open the link you sent. I get a 404 Page Not Found error.

    Fredrik, using *xx:*xx does not work. I get a little red stop sign next to each line where I put *xx. ??xx appears to be the correct syntax, but as Ludwig noted, it is perhaps not supported in the context I am trying to use it.

    Using ??xx alone, not as part of a range definition, works as expected.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans