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: 3958
- 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
- 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.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7