You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

@SUBSTRING function not working in FCCS

Accepted answer

This formula works in Planning (and in pure Essbase) but not in FCCS. The validation in the formula editor is successful but, I get an error message that the the form is invalid in Smart View. This seems like a bug in FCCS, since all the functions are supported in FCCS based on documentation. The @SUBSTRING part is the one that fails. There is another similar question posted here, but no answers or solutions have been submitted. Oracle support refuses to address this issue.

IF(@ISMBR("Entity1" AND @ISMBR("ICP_Entity2")) /*the IF statements have been written so that no members that don't exist would be produced by the functions below*/

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!