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

To compare two strings in PBCS

Received Response
21
Views
10
Comments
edited Aug 2, 2018 2:36AM in Essbase 10 comments

Summary

To compare two strings in PBCS

Content

Hello Experts,

I am working on pbcs and i have a requirement that i need to compare two subvars which basically holds the member of Year dim like FY17, FY18 etc. And if both are same then do some logic & if not then do some thing else so i tried using @CalcMgrCompare but its not giving the desired out put. Below is the logic i tried to use

IF(@CalcMgrCompare("&ActYear","&BudStartYear",@_TRUE))

Logic 1;

else

Logic 2;

ENDIF

I have made both the variable "&ActYear" and "&BudStartYear" as FY17 so ideally it should use the logic 1 but still its going in else condition its executing the logic 2. I am not sure whether IF(

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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