Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
FDMEE - Run Calc Script Before Data Load

Hi,
Were are on 11.1.2.3 which is technically FDMEE, but not sure where to post this question. We have an Essbase calc that clears some data named 'ClrPrjCl.csc'. This calc runs only when we load data for 4 scenarios (0+8 , 1+7 , 2+6 , 3+9). In the Target application section on the 'Setup' tab, we setup this calc on the 'Calculation Scripts' tab to run for two scenarios so far (1+7 and 0+8). We chose:
Script Name: ClrPrjCl
Script Scope: Data Rule
Script Entity: CLARITYEMPLOYEE_1+7PROJECTION
Event: Before Data Load
Sequence: 1
Script Name: ClrPrjCl
Script Scope: Data Rule
Script Entity: CLARITYEMPLOYEE_0+8PROJECTION
Event: Before Data Load
Sequence: 3
Back on the 'Workflow' tab, we load our data file with these selections:
Location: CLARITYEMPLOYEE
Period: Apr-2014
Category: 1+7PROJECTION
Rule: CLARITYEMPLOYEE_1+7PROJECTION
The load is successful. However when we view the Process Details, we see that the Calc Script 'ClrPrjCl' executed successfully but it executed twice. I was skeptical so I went to Essbase log and sure enough the calc ran twice.
Since my data load was for Rule 'CLARITYEMPLOYEE_1+7PROJECTION' shouldn't it have only executed the calc script for Script Entity 'CLARITYEMPLOYEE_1+7PROJECTION' and not 'CLARITYEMPLOYEE_0+8PROJECTION'?
If this is normal behavior, how do you get certain calc scripts to only run before a data load for a specific Script Entity/Rule depending on which one is being loaded?
I'm posting this on Network 54 also.
Thanks
Answers
-
Hi,
it should not execute twice.
1. Can you try changing the name of the second script to see if it is actually executing it? If so, it should fail as script does not exist in Essbase Server.
2, Can you try changing the scope for the second script (you can change to other location)? You test then if it's an issue related to data load rule scope.
Regards -
Hi,
I have found exactly the smae issue but in a differen set up.
I have two locations and depending on the location I want to fire a specific calculation script. It now fires both of them.
Regards
-
Hi,
I would suggest raising a SR with Oracle as it seems to be a bug
Regards
-
The only way to work around this is by solving this in your Essbase script. Below is an example:
SET RUNTIMESUBVARS {
POVlocation = "FDMEElocation";
POVcategory = "Actual";
};FIX(&POVcategory)
"ABC"(
IF(@HspStringCompare (&POVlocation,"abcdefg"))
...........;ELSEIF(@HspStringCompare (&POVlocation,"hijklmnop"))
...........;
ENDIF;)
ENDFIXRegards,
Marco Vissers
-
Hi Marco,
thanks for the workaround.
Besides, I would suggest raising the SR in order to be solved for next patch.
Regards