FDMEE - Run Calc Script Before Data Load

2605010

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

Francisco Amores

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

Marco Vissers

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

Francisco Amores

Hi,

I would suggest raising a SR with Oracle as it seems to be a bug

Regards

Marco Vissers

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;

        )
ENDFIX

Regards,

Marco Vissers

Francisco Amores

Hi Marco,

thanks for the workaround.

Besides, I would suggest raising the SR in order to be solved for next patch.

Regards