How To: Check if Member Already exists in a Dimension

Summary:

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