Microsoft Dynamics AX (Archived)

in which database and table does management reporter save the accounting figures?

(0) Share

Report

Posted on by Abdo Khoury

14,855

in the management reporter , we have two databases

Managementreporter
ManagementreporterDM

I am trying to find in which database / table does Management reporter save the Figures ?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Patrick, It should be the second one. You can easily identify this. If you are in the SQL Management Studio, just open the database and browse some of the tables that you see there. You should be able to identify the Transactions recorded in AX. All the best, Ludwig

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

that is all true , but i don't see the table where the figures are stored , that is why i asked , what is the table name ?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Patrick,

Have you checked the dbo.DimensionsPeriodBalanceTable in the ManagementReporterDM?

Also check

* dbo.ConvertedAmount

* dbo.FactAttributeValue

* dbo.TranslatedPeriodBalance

* dbo.TranslatedPeriodBalanceChanges

Ludwig

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report
The ManagementReporter database holds the report templates and

the ManagementReporterDM database carries the figures, but i am not able to recognize the table the holds the figures themselves,

appreciate your feedback

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report
thank you ludwig, for your prompt reply

as a matter of fact i did, but what is weird is that all the tables you mentioned are EMPTY

Why are they empty?

And if they are empty, where is my report generating those figures

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

make sure your integration service is running and its synching from AX to Management Reporter.

Also have look at log of DataMartIntegartion

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Patrick,

As Sohaib said, please check whether your MR services are running.

Maybe one of the following documents available for download via the next link helps:

www.microsoft.com/.../details.aspx

All the best,

Ludwig

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

i have checked the integration service several times and it is RUNNING fine ,

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

it seems that the only thing that actually fixes any problem with management reporter is rebuilding the data mart

Was this reply helpful? Yes No