How To: Check if Member Already exists in a Dimension — Cloud Customer Connect
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

How To: Check if Member Already exists in a Dimension



Today, in FCCS or for that matter any EPM Cloud service that uses Essbase, when we try to create a member in a dimension, and if it already exists, then dimension editor throws an error message "Object with name <Member Name> already exists". This message does not help much, because, it does not tell in which dimension said Object already exists.

This tip explains how Groovy business rule can be leveraged to help determine if a member already exists is a dimension.

Content (please ensure you mask any confidential information):

We can leverage a Groovy business rule, to iterate over a cube's dimensions and determine if member is already present or not, when we encounter "Object with name <Member Name> already exists". Below is code snippet that iterates over FCCS Consol cube's dimensions. This is a Groovy based ODR, that takes a global String variable MemberName as RTP and determines if it exists in any of the dimensions

Howdy, Stranger!

Log In

To view full details, sign in.


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