Problem with runtime substitution variables — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Problem with runtime substitution variables

edited Aug 2, 2018 2:36AM in Essbase 2 comments

Summary

Problem with runtime substitution variables

Content

Hello everyone.  I'm having an issue with basic runtime substitution variables.  I have a calc script (named MaxLTest) that is very simple, as follows:

SET UPDATECALC OFF;

SET CACHE HIGH;

SET CALCPARALLEL 4;

/* Declare Variables */

SET RUNTIMESUBVARS

{

     FinalValue = 0;

};

/* Main Rollup */

FIX ("Jan", "Current Year",  "Final (BU)", "Local", "United States", "Unrecognized Product", "Unrecognized Customer", "HSP_InputValue")

     "FY19" = &FinalValue;

ENDFIX

So the default value of the RSV is 0.  Everything works fine, and the value is stored correctly when I just execute the calculation through MaxL (WayneTch is the app, Sales is the db):

execute calculation WayneTch.Sales.MaxLTest;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!