I don't want to sound ignorant about this, but what is the point of this?
ASO exports would be level 0 only, so if I understand correctly, you are exporting level 0 data from ASO, loading into a relational table and then using other scripts to mimic the outline is SQL so you can use SQL queries to run reports and generate aggregated values.
Doesn't that seem to defeat the entire purpose?
If you ask me, in almost all of these situations, the process is backwards. To me ASO should be the end of the line where data goes to aggregate and be reported on. In all our ASO models, all data or staged in relational models ahead of time. If anyone needs subsets of level 0 data we can easily run from SQL, aggregated values come from ASO because it is better at aggregating values.
Scoring disabled. You must be logged in to score posts.
