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
Formula explain
-
- Posts: 3
- Joined: Mon Apr 14, 2014 12:35 pm
- OLAP Product: Essbase
- Version: 11.1.2.1
- Excel Version: 2007
- jim wood
- Site Admin
- Posts: 3650
- 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
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.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2