Groovy - Using getEvaluatedMembers with Shared Members
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.