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.
I did perform the same steps with next set.
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 🙂