Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Update Analysis view o...
Business Central forum
Suggested answer

Update Analysis view on Posting - Resource cost?

(0) ShareShare
ReportReport
Posted on by KJ-03062255-0 763
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:
Administration and permissions
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,305 Super User on at
    Update Analysis view on Posting - Resource cost?
    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.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,563 Super User on at
    Update Analysis view on Posting - Resource cost?
    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.
    Hopefully other experts can give you better advice.
     
    Thanks.
    ZHU

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans