Totals not updated

[Former Member]

Sometimes when people do data uploads in BPC i have happened that total accounts don't get updated.

Example

ID                Description          Parenth1

ABCTOT     ABC Tot

ABC123      ABC detail          ABCTOT

data imported on ABC123 = 10

ABC123 shows 10

ABCTOT shows 0 (should show 10)

Import was successfull regarding to Load and Process. If I modify the model everything gets correct. It's like the OLAP cube don't get updated. I can't see any connection in why this happens for some users.

I am on BPC 10 SP17. SQL server 2012

any ideas?

Brgds

Mattias

[Former Member]

Hi Mattias

This video which should give you an idea on how to narrow down the issue:

https://video.support.sap.com/OnPremise/EPM/EPM PLANNING AND CONSOLIDATION MS/2117369.mp4

Stefan

[Former Member]

Thnx Stefan,

Will take a look

Brgds

Mattias

[Former Member]

Hi Stefan,

Watched the video, in my case I would say that what I think is happening is that when users upload data during heavy load it sometimes fails to process fac2 (all is uploaded to fac2, however I can't find any proof of a failed processing of fac2).

Most of the central heavy scripts I also run against fac2 with process_fac2.

Any best practices here? would it be better to upload everything to WB table and then have light optimization running every 30 mins or something?

Brgds

Mattias