Formula explain

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

Formula explain

Post by vijaykumar.yes » Wed Apr 16, 2014 10:28 am

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))))
ENDIF;

where Department is Just a DIM and we don't have Department as UDA

User avatar
jim wood
Site Admin
Posts: 3479
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Formula explain

Post by jim wood » Wed Apr 16, 2014 5:17 pm

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,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

Post Reply