Hyperion Essbase (MOSC)

MOSC Banner

BSO - Calculation script - How to set variables/command/functions which go one year back?

edited Nov 19, 2015 3:34AM in Hyperion Essbase (MOSC) 6 commentsAnswered ✓

Hello everybody,

I want to built up a calculation script in a BSO-Cube.

The script should copy values from one measure to another when the condition is true.

Description:

When the condition in january 2014 is true, the script should write the value in January 2015

Explanation:

CY = CurrentYear

LY = LastYear

I want to calculate all the values of the past, so I need a variable/command/function with it I go one year back.

I want to replace "2014" and "2015" with variables/commands/functions to calculate it with every year.

"ValueLY"

(IF(@ISMBR ("January"))

IF("2014"->"Check-Account"->"AC"==1 ) "2015"->"ValueLY"="2014"->"Start_Value";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center