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

Groovy - Using getEvaluatedMembers with Shared Members

Accepted answer
217
Views
3
Comments

Summary:

I am attempting to generate a custom metadata export file using Groovy to feed into some reporting solutions. We want to be able to generate a clean csv that has Member Name, Parent, and Alias: Default as three simple columns, and we want to essentially generate two files, one for the base stored hierarchy and one of for a shared hierarchy. I'm running into some issues with doing so in Groovy.

Content (required):

My initial strategy was to pull the highest level common parent's descendants using getEvaluatedMembers("@ILDESCENDANTS(mbr)", cube) and then iterate through the list of members generated to pull their respective metadata properties. Works pretty nicely for the stored base members, but not for the shared hierarchy. If I pass the top of the shared hierarchy into the function, the system still returns the properties of the base members. I assume this is because the "evaluated" part of the logic continues all the way to the base stored member.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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