EPM GROOVY – EPBCS Deleting Level Zero Members Based on Data Storage Property Across Multiple Hierarchies

 

Deleting Level Zero Members Based on Data Storage Property Across Multiple Hierarchies

Recently, I embarked on a challenging task posed by my brother: to efficiently delete multiple alternative hierarchy level zero members and exit the hierarchy if it became empty. The challenge sparked my curiosity, and I dove into implementing a solution using a common script.

During my research, I came across insightful blogs from fellow EPM enthusiasts. Their knowledge proved invaluable, providing me with crucial insights and strategies to simplify the task.

By amalgamating their input and leveraging the best practices shared, I successfully crafted a streamlined script capable of deleting multiple hierarchy members across various levels. Additionally, I developed a sample script specifically designed for shared hierarchies, enhancing the script's versatility and utility.

This journey not only sharpened my technical skills but also underscored the power of collaboration within the EPM community. Through shared knowledge and collaboration, we can overcome complex challenges and create efficient solutions that benefit us all.

Stay tuned for a detailed walkthrough of the script and its functionalities in my upcoming blog post, where I'll delve into the nuances of deleting multiple hierarchy members and optimizing performance within EPM systems.

Here is current Hierarchy.

Let's begin by deleting shared members only from all hierarchies. Following that, I defined all 'Test' hierarchies in the script below.

Ex1: - Below is an example script that deletes members based on their "Shared" property, as opposed to the "Data storage" property. 

 

Only shared property members are deleted in the hierarchy.

Ex2: -"Below is an example script that deletes all level zero members.

Finally, it deleted all level zero members from all declared hierarchies.

Who knew deleting hierarchies could be so thrilling? Stay tuned for the juicy details and a sprinkle of hierarchy humor in my next blog post!

 

EPM GROOVY – Get EPBCS connection details using Groovy

 

Unraveling the EPBCS Password Mystery: A Groovy Breakthrough!

Inspired by the legendary exploits of "Raja Stalvin" I embarked on my own quest to retrieve the password from an EPBCS connection. Armed with determination, I began by employing a "Named connection." However, my progress came to an abrupt halt as I encountered a lock. It dawned on me that the lock wasn't associated with the Connection Class but rather with the sneaky HttpRequest Class.

No validation errors, yet no success. It was like chasing a shadow! Then, it dawned on me – the getPassword() function was playing hardball, hiding behind its "protected" status. Groovy, my trusty ally, came to the rescue!

After a bit of Groovy magic, I cracked the code! Behold, the snippet that turned the tide:

And there you have it – a simple adjustment that turned frustration into triumph. With Groovy by my side, no password is out of reach!😀