The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Jorge_Haces
3 years agoNew Contributor II
Can I execute a BR after saving data?
I'm trying to execute a calc after an input data in a CV, when the user click in the OS default save button (giving the flexibility to use a DB, CV or Excel addin with the same CV)
Is possible?
- 3 years ago
If you are going to do this in EXCEL, your option will be to use WcfEventHandler. I wouldn't recommend using SaveDataEventHandler as that will run on every save operation.
- 1 year ago
Is your DQEH using a "StartDataMgmtSequenc" vs a "ExecuteDataMgmtSequence"? I think start just starts and moves on but execute will wait for completion, so an execute may update task activity box better.
ChrisLoran
OneStream Employee
3 years agoSample CREATE TABLE schema as used by my example:
You can create your own using Data Table Manager, or through an extender rule to "Create Solution Table" , or through a Create Table script in the SQL Table Editor component.
CREATE TABLE [CVX_CalcOnSave] (
[cvName] [nvarchar](100) NOT NULL,
[cvGroup] [nvarchar](100) NOT NULL,
[busRule] [nvarchar](100) NOT NULL,
[funcName] [nvarchar](100) NOT NULL,
CONSTRAINT [PK_CVX_CalcOnSave] PRIMARY KEY CLUSTERED ([cvName] )
) ;Related Content
- 3 years ago
- 9 months ago
- 2 years ago