Selecting multiple data file and rules file in EAS


Learning never stops 🙂
I’m sure that many of you are already aware of the trick that I’m going to share with you.
How I can select multiple data files and rules files in EAS?
Well I always used to add multiple rows using the “Insert” button and then selected each data file and rule file. (Now that I know this trick, kind of feels dumb (sigh))
I’ve 6 data files to be loaded to a cube and they use 3 load rules. I can perform the data with just 7 button clicks (Yes including the “OK” button).
How many of you are aware that Ctrl and Shift button work when selecting rules and data files? (well I was not)
Navigate to the folder where data files are kept, use “Shift”/”Ctrl” to select multiple files.
It adds each data files in separate row.
Now I’ve Actual, Budget and Forecast rule files and I can do the same multiple selection with rule files.
If you look carefully, I’ve selected the rows (Act.txt, Bud.txt and Fcst.txt). My rule files are also in the same order.
Now that was my 4th click.
After selection
I did perform the same steps with next set.
End result
7th click will start the load 🙂
The order (data files and rule files) must match.
Isn’t it cool? As I said learning never stops 🙂
Advertisements

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 “Selecting multiple data file and rules file in EAS