Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Executing Calculation Script using FDMEE

JanGLiJul 6 2017 — edited Jul 6 2017

Hi,

I wanted to execute a calculation script from FDMEE after my data is loaded in essbase.

This is my script....

//ESS_LOCALE English_UnitedStates.Latin1@Binary

/* GLOBALRANGE */

SET RUNTIMESUBVARS

{

sp_year = "Year";

sp_period = "Period";

sp_version = "Version";

};

FIX (

"Local",

"00000000-CC",

"00000000-RCC",

"No Future 1",

"B/S",

"Common B/S",

"FFL",

"Closing Balance - Actual",

"Actual"

)

"52070004"= "52070004" + "52010001";

ENDFIX

and this is how i am using the parameters in FDMEE.

pastedImage_1.png

pastedImage_2.png

The issue is, this rule is getting executed for every month. Kindly guide what i am doing wrong.

Regards

This post has been answered by Jeo123 on Jul 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details