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

Cross-dimensional member value in IF Statement Error

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

Summary

Cross-dimensional member value in IF Statement Error

Content

Hi,

I trying to create a Calc Script something like below and instead of using "510002"(it's an account member), I want this script to calculate for an account which users enter manually using SmartView under ACCOUNT_NBR (i created a member in Accounts dimension to grab which Account number they want to run this script for)

FIX(@RELATIVE(PROJECT, 0), @RELATIVE(POSITION, 0), @RELATIVE(Sandbox, 0),@RELATIVE(PERIOD, 0), "FORECAST");

"510002" ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->>>>I want something like THE DATA VALUE in this intersection (ACCOUNT_NBR->BEGBALANCE) FOR EACH POSITION, PROJECT and SANDBOX

(IF ((CALCULATE->BEGBALANCE) == 1)

"510002" = 25;

ELSE

"510002" = 50;

ENDIF;)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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