Cleanup MRDB.DimensionValue

(3) Share

Report

Posted on by CU17071940-0

MRDB.DimensionValue table is taking up 50 GB of space on PROD for us. Is there anyway we can truncate / reset this table? I dont see much documentation on the internet regarding this table. A couple of questions asking the same thing but no helpful answer.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

André Arnaud de Cal... 301,510 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi,

There is only one option to clean this table. That is by resetting the data mart. After a new full refresh of the data, you can check the size of the table again.

See: Reset the Financial reporting data mart - Finance & Operations | Dynamics 365 | Microsoft Learn

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,539 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I hope below can help you

https://dynamics365finance.wordpress.com/2020/12/03/alert-prepare-for-dimension-table-changes-in-financial-dimension-framework/?utm

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No