| Original Message |
APindar
Posted Jul 2, 2009 5:00 AM
FYI, there is another way. We developed an SSIS package that reads through all of the 'txt' files created from a full database export. The steps were as follows:
1. Read the outline (using VBA) and generate a unique index number for each Level 0 member
2. Build Dimension tables in SQL server from the Essbase dimensions
3. Read the export files one by one from the export folder and for each (using a script process):
- Read the first line (compression dimension entries specifying the data order)
- Read the subsequent lines converting dimension members to index keys to save space
- Create output rows which are fed into a Fact table
This all took some time as we were newbies to SQL Server when we started but now works well. We have also refined the process so that we can use 'filters' to select particular Measures/Time periods to read into the tables. We then have alternative EIS Models/Metaoutlines pointing at this tables to re-read the data back into ASO cubes if necessary.
Post a reply with a contact email if you want more info |
|
|