Updating Context Defaults using SQL Script

[dipalpatel]

Hello

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

[Former Member · Accepted solution]

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,

Dorra.