Skip to Content

Updating Context Defaults using SQL Script

Dec 19, 2016 at 09:01 PM


avatar image


I am updating "tblDefaultContext" SQL table to update Time in the Context Defaults of the model.

When I run update statement in SQL, it updates values successfully in "tblDefaultContext" table and also when I open Context Defaults in Admin Console, it shows updated value.

But when I open BPC web client, it does not show updated new value unless I click on "Apply" in the Context Default dialog in Admin Console (Please see the screenshot)

Is there any other query requires to show updated default value in the BPC web client?

Please let me know if I need to give more details.


contextdefault.png (33.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dorra KHEZAMI Jan 07, 2017 at 03:00 PM

Dear Dipal,

I'm afraid that the only way to update the context defaults in BPC is in the Admin client and then click on "Submit" to save the changes.

You can refer to KBA

1834629 - Reset default Member Display in Journals

which is not relevant to your case but that mentions this only way to update context defaults.

Best Regards,


10 |10000 characters needed characters left characters exceeded