D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Deleting History from Management Reporter

  • 1.  Deleting History from Management Reporter

    Posted May 07, 2019 05:06 PM
    Hello everyone.

    I've been hitting my head against the wall for a while trying to solve this.

    I've been requested by our Finance Department to delete some history from the Management Reporter database. I've tried to write a script that will tell me how many records are in the db, but I'm hitting a wall.

    Has anyone done this before and if so how did you do it?

    Thanks in advance.

    Brent

    ------------------------------
    Brent Dawson
    Sr. Application Analyst
    Edmonton Airports
    Edmonton AB
    ------------------------------


  • 2.  RE: Deleting History from Management Reporter

    GOLD CONTRIBUTOR
    Posted May 08, 2019 04:04 PM
    Hi Brent,

    To query MR please try this, it could help as a guide.



    https://www.gpug.com/blogs/steve-erbach/2015/10/29/how-to-delete-management-reporter-history

    I hope this helps!!

    ------------------------------
    Michael Gonzalez
    Account Executive
    Dynamics Resources
    Venon Hills IL
    ------------------------------



  • 3.  RE: Deleting History from Management Reporter

    Posted May 08, 2019 04:48 PM
    ​Hi Michael.

    Thanks for your response. I am trying to use that specific script, but I'm getting a conversion error between date and integer...that's where I'm stuck.

    Brent

    ------------------------------
    Brent Dawson
    Sr. Application Analyst
    Edmonton Airports
    Edmonton AB
    ------------------------------



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