Inconsistent sending of zero value in Offline Template

[Former Member]

Hi,

I am on BPC 10 NW with Version: 10 SP 19 Patch 1.

We have a template, that's made offline, and sent to User A.

User A enters value, saved the template and sent it to User B who has BPC online access.

User B connects to BPC, open the offline template, and just click save (i.e. no refresh).

Then User A realizes there was some mistake with his previous entry, so he cleared some value (delete some cells with value), and resends to user B.

User B tries to send data but the value 0 is not sent, as in the value stays in the server.

However sometimes it works, i.e. value 0 is sent to the server, and the data is nullified and shows as 0 when the report is refreshed.

Any idea?

Thanks

[former_member186338 · Accepted solution]

The issue is on this step:

"Then User A realizes there was some mistake with his previous entry, so he cleared some value (delete some cells with value), and resends to user B."

Once the template is sent to server the user can't correct the previous version!!!

Example:

Original value: no record (NULL) Nothing in cache embedded in the sheet.

User A enter value: 5

User B saved the value 5. 5 is in DB!

User A change from 5 to 0 (The template was not refreshed!!!!!)

BPC assumes 0 and NULL equivalent comparing data with cache.

Nothing to save.

The only correct way:

Use the same file and mandatory refresh it after sending.

Vadim

[gajendra_moond · Accepted solution]

Hi Vadim

The scenario stated by you works fine in my case without any refresh.

Steps performed:

1. Template refreshed.

2. Entered value in a blank cell - 5 units.

3. Saved on desktop.

4. Opened offline and change to 10 units

5. Connected to system and saved. Data saved. No refresh performed.

6. Opened template offline and changed 10 to 0. Saved the template offline.

7. Connected to system and opened template. Performed save data. Value 0 was saved.

Not sure if I missed any step here.

[former_member186338 · Accepted solution]

You have to properly emulate 2 users, where user A has no bpc!

And you have to understand the general rule used by EPM to send data:

1. Each time the EPM input form is refreshed the cache is created/updated containing non zero values of the form members.

2. When user press Save data the data in the form is compared with cache and only different values are send.

Vadim

[gajendra_moond · Accepted solution]

If User A does not have EPM Addin installed at all, it will behave as you indicated.

What I assumed from the original post is that User B is having online access but not User A but both have EPM Add-in installed.

[former_member186338 · Accepted solution]

"If User A does not have EPM Addin installed at all, it will behave as you indicated." - offline is used for the users without EPM add-in! To save on BPC licenses!

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Is there any standard way to update the Cache of the Offline Template, WITHOUT refreshing the template and resaving it as a "new" offline template?

Thanks

[former_member186338 · Accepted solution]

No way!

[Former Member · Accepted solution]

Hi Vadim,

Noted with thanks.

As always, appreciate the fast reply.

Thanks