D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

How to add more Financial Dimension to MR?

  • 1.  How to add more Financial Dimension to MR?

    GOLD CONTRIBUTOR
    Posted May 02, 2018 09:05 PM

    Hi ALl, 

    Currently, Management Report has only 5 financial dimensions. 

    1. Business unit

    2. Cost Center

    3. Department

    4. Item group

    5. Main account. 

    How do I add more financial dimension to the list?  Thanks



    ------------------------------
    Lisa Ng
    Business Analyst
    NA
    HOUSTON TX
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: How to add more Financial Dimension to MR?

    SILVER CONTRIBUTOR
    Posted May 03, 2018 08:16 AM
    Hi Lisa, you will need to add the new Financial Dimensions outside of MR via the General Ledger module (General Ledger>Setup>Financial Dimensions>Financial Dimensions). Once the new Financial Dimension and corresponding Financial Dimension Values are set up they will be available in MR. Note we are on AX2012 R2 CU7.

    ------------------------------
    Dan Naser
    Controller
    Crow Holdings
    Dallas TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: How to add more Financial Dimension to MR?

    TOP CONTRIBUTOR
    Posted May 03, 2018 09:59 AM
    Hi Lisa,

    Are you in D365?  If so then you have to go to General Ledger> Ledger setup> Financial reporting setup and select the dimensions you want to use within Management Reporter.

    ------------------------------
    Stacy Black
    Senior Application Consultant
    MCA Connect
    Denver CO
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: How to add more Financial Dimension to MR?

    GOLD CONTRIBUTOR
    Posted May 03, 2018 03:28 PM
    Ah!  Thanks, Stacy.

    ------------------------------
    Lisa Ng
    Business Analyst
    NA
    HOUSTON TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: How to add more Financial Dimension to MR?

    GOLD CONTRIBUTOR
    Posted May 03, 2018 04:07 PM
    Hi Stacy,
    I came in and added a few more financial dimensions.  it did not reflect in MR. \

    It still has the same financial dimensions.  The ones that I've updated such as region, worker, vendor, and customer, they did not show up in MR.  Am I missing something?  Thanks


    ------------------------------
    Lisa Ng
    Business Analyst
    NA
    HOUSTON TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: How to add more Financial Dimension to MR?

    MICROSOFT MVP
    Posted May 04, 2018 01:35 AM
    Hello Lisa,
    I had a similar issue in one of my demo environments.
    At the end of the day we resetted the data mart.
    Are you in a demo/test environment and can you easily do it there or do you experience this in live?
    In the latter case I would suggest to coordinate with your system admins clarifying when a data mart reset can be initiated.
    Best regards,
    Ludwig

    ------------------------------
    Ludwig Reinhard
    Sycor
    Goettingen
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: How to add more Financial Dimension to MR?

    GOLD CONTRIBUTOR
    Posted May 04, 2018 05:51 PM
    Ah.  Thank you. Ludwig.

    ------------------------------
    Lisa Ng
    Business Analyst
    NA
    HOUSTON TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: How to add more Financial Dimension to MR?

    Posted May 02, 2020 02:13 PM

    Hi Ludwig 

    how much time usually reset data mart takes?

    ------------------------------
    Regards
    Mohamed Ali
    ------------------------------



    ------------------------------
    Mohamed Siddiq
    Pioneers IT
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: How to add more Financial Dimension to MR?

    Posted May 04, 2020 01:14 AM
    Hi Mohamed,

    It primarily depends on how many records you have, but there are other variables.  There are several integrations that reset  and usually all except one reset quickly.  GL to fact integration usually takes the longest.  Once you reset the datamart, you can monitor progress by checking integration status under the tools menu option in MR designer.  You will want to log into the MR designer and check Integration Status under tools menu option and verify ALL integrations have "ran to completion" before generating reports. ​  If you see failed status, more troubleshooting will be needed.

    In my experience 15-20 million records usually resets in about  45 minutes.  So you can use that as a gauge based on how many records you have.

    Regards,
    Bobby Kendall
    OnActuate Inc.

    ------------------------------
    Bobby Kendall
    OnActuate Consulting Inc
    OAKVILLE ON
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: How to add more Financial Dimension to MR?

    Posted May 04, 2018 09:36 AM

    Hi Lisa,

     

    You probably need to rebuild your Data Mart: https://community.dynamics.com/ax/b/dynamicsaxbi/archive/2016/02/01/management-reporter-rebuilding-your-data-mart

     

    Best regards,

    Gabor

     

    Gabor Fulop |O: +1 262.788.2239 |M: +1 760.683.4210

     




    Academy - Online Interactive Learning from Experts


  • 11.  RE: How to add more Financial Dimension to MR?

    GOLD CONTRIBUTOR
    Posted May 04, 2018 05:52 PM
    Thank you, Gabour, for the link.

    ------------------------------
    Lisa Ng
    Business Analyst
    NA
    HOUSTON TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role