Formula explain

Post Reply
Posts: 3
Joined: Mon Apr 14, 2014 12:35 pm
OLAP Product: Essbase
Excel Version: 2007

Formula explain

Post by vijaykumar.yes »

Hi all,

Can any one explain what is the meaning of below formula
IF((@ISUDA (Department, @NAME(@UDA(Department, @NAME(@PARENT(@CURRMBR(Department)))))))
@UDA(Department, @NAME(@PARENT(@CURRMBR(Department))))

where Department is Just a DIM and we don't have Department as UDA
User avatar
jim wood
Site Admin
Posts: 3953
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York

Re: Formula explain

Post by jim wood »

It's returning the value of the User Defined Attribute if one exists for the current member matching the parent name. Without the context of the formula it's difficult to say exactly what it's doing. If you're struggling with any of the formula command (@UDA for example) type them in to google and the oracle online documentation will tell you what it does,

Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply