Finance | Project Operations, Human Resources, ...

Financial Reports: Reset Data Mart

(0) Share

Report

Posted on by David Tailor

822

Hello,

i have accidentally reset data mart for financial reports.

All default reports now are deleted.

How to get them back?

Note: am using a local VM with F&O v 10.0.11 update 35

BR,

David

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello David,

Can you try 'tools-import default reports' in the financial report designer?

Best regards,

Ludwig

Was this reply helpful? Yes No
David Tailor 822 on at

Like (0)

Report

Hi Ludwig,

i have followed the following path:

General Ledger -> Inquiries and reports -> Financial reports -> New

i got the following error:

BR,

David

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello David,

Can you try opening the financial report designer in the old internet explorer or a different browser, possibly in private mode?

Best regards,

Ludwig

Was this reply helpful? Yes No
David Tailor 822 on at

Like (0)

Report

Hi Ludwig,

i tried opening with different browser but unfortunately same error.

BR,

David

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi David,

Do you have a system admin/ developer around who could help you with that?

You need to open and install the plug in first.

Without that you cannot reinstate the default reports.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi David,

If you have recently update the data mart then wait for some time and try clicking on new and check.

As suggested by Ludwig , please use "Internet explorer" as browser, if you still face the issue you can log a ticket to MS to resolve the same.

Was this reply helpful? Yes No
David Tailor 822 on at

Like (0)

Report

Hi Ludwig,

i had used the following command to deploy all reports but it didnt works.

C:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "C:\AosService\PackagesLocalDirectory".

Actually, i don't have a developer right now, but if you can help me with the steps to do.

BR,

David

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

if its production environment, then try to restore old date DB to sandbox and then export your MR reports from sandbox to production and suggest if it helps

Was this reply helpful? Yes No
David Tailor 822 on at

Like (0)

Report

This is a VM environment.

BR,

David

Was this reply helpful? Yes No
JoshP on at

Like (0)

Report

Hello David,

Thank you for the details provided. Please note that a data mart reset will not delete the report designs from inside of the Report Designer; however, what part of the data mart reset will do is to remove the list of previously generated reports from the D365 database and then re-synchronize this list from the Financial Reporting database. Since you do not see any reports listed in D365, something is preventing the synchronization process from happening. Also, the error you got is because the list of FR users is also not synchronized from D365. The error is not related to the ClickOnce which is for running Report Designer. There are several areas you can look for more information:

1. The data mart log -- in the Financial Reporting database, review the contents of view Scheduling.Message for synch errors

2. The Windows Event Viewer -- The custom logs are under Applications and Services Logs | Microsoft | Dynamics. There are several "MR-" logs such as "MR-Logger".

3. Also verify that the Process Service is running. This is found in the list of Windows services with the name "Management Reporter 2012 Process Service".

If you need further help, you may consider opening a support case for limited support for your local VM, or if you do not wish to take the time to troubleshoot, you can re-deploy your local VM.

Thanks!

Was this reply helpful? Yes No