Unified Operations & Dynamics AX Forum

Expand all | Collapse all

MR is missing months in one company but another company its ok

  • 1.  MR is missing months in one company but another company its ok

    TOP CONTRIBUTOR
    Posted 29 days ago
    HI All

    We have more than dozens companies in AX
    Runinng TB P&L report by department
    Able to run for 3 companies
    However in another 2 companies
    -in one comonay missing data from Aug - Oct
    -in another company missing data for Oct
    Also ran option - refresh financial data, didnt fixed

    please assist
    thanks and best regards


    ------------------------------
    Nazim Lalji
    Dynamics AX Analyst

    ------------------------------


  • 2.  RE: MR is missing months in one company but another company its ok

    TOP CONTRIBUTOR
    Posted 29 days ago
    Hi Nazim,
    Have you already tried resetting the complete data mart?
    Best regards,
    Ludwig

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



  • 3.  RE: MR is missing months in one company but another company its ok

    TOP CONTRIBUTOR
    Posted 28 days ago
    Hi Ludwig

    Never try this before

    Sorry can I ask documentation for this, have to see if I have the access

    thanks and kind regards

    ------------------------------
    Nazim Lalji
    Dynamics AX Analyst
    Nazim Lalji
    Los Angeles CA
    ------------------------------



  • 4.  RE: MR is missing months in one company but another company its ok

    TOP CONTRIBUTOR
    Posted 28 days ago
    Hi Nazim,
    You can find some information on how to reset the datamart here:
    https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/reset-financial-reporting-datamart-after-restore
    https://blogs.msdn.microsoft.com/dynamics_financial_reporting/2016/06/28/resetting-the-management-reporter-data-mart/
    Best regards,
    Ludwig

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



  • 5.  RE: MR is missing months in one company but another company its ok

    TOP CONTRIBUTOR
    Posted 11 days ago
    Agreed with Ludwig...we rebuild our datamart monthly to avoid issues.

    ------------------------------
    Lori Holmes
    Hamamatsu Corporation
    Bridgewater, NJ
    ------------------------------