Correct Usage of Essbase Member Set Functions

Summary:

This article explains correct usage of Essbase Member set functions @LEVMBRS, @GENMBRS, @ISLEV and @ISGEN

Content (please ensure you mask any confidential information):

This is a very common mistake done be script developers when using below Essbase functions

@LEVMBRS, @GENMBRS, @ISLEV and @ISGEN

These functions are expected to use Dimension name and NOT Member name as the first parameter. 

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Incorrect syntax

IF(@ISLEV("Total Geography",0))

Correct syntax

IF(@ISLEV("Entity",0))

Assuming Customer is custom dimension

Incorrect syntax

@LEVMBRS("Total Customer", 0)