parameter dimension value cannot be null in financial report/ management reporter

(0) Share

Report

Posted on by JasdeepSingh

192

Hi All, I am getting this error on opening Financial reports in D365 finance& operations:

When I click OK or close the error dialog a new error opens: Value cannot be Null, Parameter:Dimensions

After clicking Ok applications(Report Designer) terminates.

Below are the snapshots of event viewer :

Below is the Financial reporting setup under General ledger

Kindly help me finding the issue and solution

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

Hi Jasdeep Singh,

Please try to refresh the data mart.

Check the following steps:

1.Run PowerShell as Administrator.

2.Browse to .\MRInstallDirectory.For a demo or DEV deployment, this will typically be J:\MROneBox\MRInstallDirectory.For Production or HA deployments, this will typically be J:\MRProcessService\MRInstallDirectory for the BI machine and F:\MRApplicationService\MRInstallDirectory for the AOS.

3.In the PowerShell window type the following command to import the MRDeploy.psd1 module: Import-Module.\Server\MRDeploy\MRDeploy.psd1

4.You can then run the following command to reset the data mart:

Reset-DatamartIntegration -Reason OTHER -ReasonDetail “Testing reset”

5.Stop MR Process Service.

6.Answer Yes when prompted in PowerShell to continue.

7.Start MR Process Service.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you have the financial reporting setup in the GL module of D365FO completed?

Best regards,

Ludwig

Was this reply helpful? Yes No
JasdeepSingh 192 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Yes the reporting setups are done i.e Main accounts and All financial dimensions are under Selected.

I have edited the post and added the screenshot

Was this reply helpful? Yes No
Verified answer

JasdeepSingh 192 on at

Like (0)

Report
Copy link

Link copied!

Hi everyone, I resolved this issue by resetting the Data mart through SQL Server Management Studio, since Report designer was not opening due to this error.

One can follow this link: docs.microsoft.com/.../reset-financial-reporting-datamart-after-restore

and run the queries provided.

Was this reply helpful? Yes No
JasdeepSingh 192 on at

Like (0)

Report
Copy link

Link copied!

Hi Will Wu,

Thanks, but I couldn't follow your approach because I was unable to find the initial path. I did it through SSMS , but since your solution can also work we can reset data mart using power shell too, I will verify your answer.

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

Hi Jasdeep Singh,

Thank you for your sharing!

Was this reply helpful? Yes No