Skip to Content

Updating Context Defaults using SQL Script


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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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,


    Add comment
    10|10000 characters needed characters exceeded