'Chart OpeningBalance' Rul Set Execution
- Do we need to every time select the parameters in order to execute 'Chart OpeningBalance' Rule Set from PBM Or can we create a Job something similar to Currency Conversion job?
Also If I select the Rollup Entity for running this Rule Set I dont see numbers generated, however when I select the Child Entity where the data is posted for running the Rule Set then I see the numbers getting generated for OPE and MVT flow members.
Am I missing anything?
Thanks,
Ajay
Answers
- For you first question, you can create a job for "Chart_OpeningBalance". Select "Create job template for rule set or rule" on the Business Rules page, then when scheduling/creating a job of type CalculationRule Job you should see the corresponding job template. (For most rules with parameters you could also avoid the problem of selecting parameters each time by setting a reasonable default value for each parameter, but in this case you cann't do this since the rule is read-only.)
Hi Jay
You can run the rules directly during your ETL process say from within SSIS by calling the sproc directly. They are stored on the RefDB and will be called something like this:
bsp_GeneratedCalc_ModelNameHere_Rule:Chart_CarryForward_9F1B9169_30C3_4C35_87FD_F9983BF80672
and
bsp_GeneratedCalc_ModelNameHere_Rule:Chart_GAP_Movement_9F1B9169_30C3_4C35_87FD_F9983BF80672
I run them as part of me ETL process and then only process the model afterwards so that the data is correct. This way you can control the parameters or even replicate the sproc for your own mods.
Regards
Paul
All Replies
- For you first question, you can create a job for "Chart_OpeningBalance". Select "Create job template for rule set or rule" on the Business Rules page, then when scheduling/creating a job of type CalculationRule Job you should see the corresponding job template. (For most rules with parameters you could also avoid the problem of selecting parameters each time by setting a reasonable default value for each parameter, but in this case you cann't do this since the rule is read-only.)
Hi Jay
You can run the rules directly during your ETL process say from within SSIS by calling the sproc directly. They are stored on the RefDB and will be called something like this:
bsp_GeneratedCalc_ModelNameHere_Rule:Chart_CarryForward_9F1B9169_30C3_4C35_87FD_F9983BF80672
and
bsp_GeneratedCalc_ModelNameHere_Rule:Chart_GAP_Movement_9F1B9169_30C3_4C35_87FD_F9983BF80672
I run them as part of me ETL process and then only process the model afterwards so that the data is correct. This way you can control the parameters or even replicate the sproc for your own mods.
Regards
Paul
- Thanks Brian for providing the information on creating Job using template so that it can be run from Modeler.Thanks Paul for the information on the stored procedured which can be used whenever data load is done from external source.Thanks,Ajay
