Clear ASO database using the members in data file

I was once working on a project where users used to do re-classification. (Data for Member 1 sometimes can be changed to Member 2) and I had to find out a way to clear the database according to the key members in the data file. (We had 5 key members to determine the region to clear).
I developed a Shell script (for UNIX lovers) and Batch script (for Windows lovers) to generate a Clear ASO Maxl script dynamically (by reading the data file). No partiality this time 😉

The script does a unique check and then creates a Maxl for clearing.

This script assumes that the data file has 11 dimensions in it. You can change this by following the below given steps
Shell Script

To change the data file dimensions, change the 131st line
while IFS=| read Dimension1 Dimension2 Dimension3 Dimension4 Dimension5 Dimension6 Dimension7 Dimension8 Dimension9 Dimension10 Dimension11

  • If you want to add more dimensions, then add them after Dimension11.
  • If you want to remove dimensions, delete them from the very end.
  • If you want to change the delimiter then change IFS
To change the key dimensions, change 132th line
echo “$Dimension1 $Dimension3 $Dimension9 $Dimension10 $Dimension11”
Batch Script

To change the Key dimensions change following line (91st Line) in ClearASO.vbs
KeyMembersfile.WriteLine(arr(0) & “|” &arr(2)  & “|” &arr(8) & “|” &arr(9) & “|” &arr(10))
  • If you want to add more Key dimensions add them as arguments after arr(10)
  • arr(0) denotes Dimension 1, arr(2) denotes Dimension 3 and so on
  • If you want to change the delimiter then change 90th Line (arr = split(Line, “|”))
You’ll have to update the script (BASE_DIR, directories) according to your needs.

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

0 thoughts on “Clear ASO database using the members in data file