Small and medium business | Business Central, N...

Update Analysis view on Posting - Resource cost?

(0) Share

Report

Posted on by KJ-03062255-0

We are starting to use Analysis Views for reporting on the shortcut dimensions, the question I have is whether we should have the /update on posting/ turned on and what the resource cost is on that vs. running the update before running reports. In the sandbox it hasn't seemed to be too bad to have it turned on, but that isn't representative of all the transactions/users being in and working. Any experience?

Kevin

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Hi, from my personal experience, this doesn't affect performance much. But if you are worried, you can manually run Update Analysis Views each time.

https://learn.microsoft.com/en-us/dynamics365/business-central/bi-how-analyze-data-dimension?wt.mc_id=DX-MVP-5004336

Hopefully other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,766 Super User 2025 Season 2 on at

Like (0)

Report

If this is turned on, You will only notice some impact on the time it takes to post transaction, when You will be posting a large number of lines. Usually for standard Invoice posting this additional time cannot be noticed by user - as it is like additional 5-10% of those 3-4 seconds the posting takes.
But when you have like 1000 or 10000 lines, the standard posting takes like a minute, and then You can notice that the posting will take like extra 5-10seconds if the Analysis view is being updated at the time of Posting.

It is recommended to turn it on for reports, that several people are using, as from my experience - even if Users know that they have to press the Update manually, in 2 out of 12 months, usually it is forgotten and not always users remember that wrong numbers in reports are because of that.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Update Analysis view on Posting - Resource cost?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Update Analysis view on Posting - Resource cost?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates