@REMOVE(@DESCENDANT(Product),@SHARE(@DESCENDENT((Product)))
The example has multiple errors (misspellings, parenthesis issue) and I was thinking “Why can’t they give a correct working example!!!!”
But then I was so lazy in correcting those and I tried (I thought I could raise a documentation bug) the same command and to my surprise it validated.
Then I thought if this one works, why not this @IDESCENDNATS. To my surprise (that was a big one) that worked too.
This was also a part of the above (@share) discussion and John Booth pointed out that Essbase only matches the first four characters of a function.
I experimented more on it and then figured out that what John said is partially true!!!!!
Essbase recognizes all functions with first 4 letters if the argument is a mbrname
So @CHILDNER works. Try it if you don’t believe me.
I don’t know how many of you got a hoax mail which claims that “Brain can read jumbled words if the first and last letters are not jumbled.”
Now I can spread one which says “Essbase can read functions if first 4 letters are correct”
Celvin,
Thank you for your kind words.
Did you catch this Essbase Surprise?
EXCLUDE(@SHARE(@RELATIVE("Product", 0)))
"Connecticut" = "Connecticut" + 100 ;
ENDFIX
I just validated it and ran it in 11.1.2.1. I haven't tried it in 11.1.2.2 but I'll bet it works.
Re only the first three characters are valid (ENDFIX vs ENDEXCLUDE)?
But that rule about the first four characters also isn't always true as this does NOT validate or run:
EXCL(@SHARE(@RELATIVE("Product", 0)))
"Connecticut" = "Connecticut" + 100 ;
ENDFIX
So some functions (maybe only functions instead of commands?) Nope, because this fails:
EXCLUDE(@SHARE(@RELA("Product", 0)))
"Connecticut" = "Connecticut" + 100 ;
ENDFIX
Bizarre. I'm not giving up on writing the whole function or command out completely.
Regards,
Cameron Lackpour
@Cameron
with EXCLUDE @SHARE works!!!
the rule of first four character works for functions which accepts just mbrname as argument works. @RELATIVE has more than one argument(mbrname, genLevNum | genLevName).
After writing this I tried @ALLANCESTORS however it doesn't follow the four character rule. It becomes first five character rule @ALLANC works!!
I've seen people using @IDESC for @IDESCENDANTS, but I always write the whole command/function