Thanks Glenn...Little more information, any thoughts?March 1 2010 at 2:55 PM
No score for this post
from IP address 220.127.116.11
Response to Re: ASO Export Data
Thanks Glenn for your feedback.
A little more information on what I m trying to do…
The ASO database contains 4 years of data. 2 are history years and CurrYear & PlanYear. The ASO databases are used only for reporting purpose and data gets refreshed every hour. So far BSO was used and data export was not an issue. The history years only reside on the reporting side.
We extract all level 0 data in column format, clear all data and load the export back using a load rule and tell it to ignore CurrYear & PlanYear in the same BSO database. The CurrYear & PlanYear files are then loaded to the database from the planning database export and after that we run an aggall.
Now the plan is to change the BSO reporting database to ASO. I can export level 0 data out of ASO database, but its not in column format so the issue is how can I load this back in to the ASO database with a load rule and tell to ignore CurrYear & PlanYear. Also as I mentioned in my first post, report script seems to never end, so I m scrapping out that option.
I hope I was able to explain the scenario…any suggestions?
- Re: Thanks Glenn...Little more information, any thoughts? - Gary Crisci on Mar 2, 9:32 AM
- Thanks Gary but the historical files change every month - Anonymous on Mar 2, 1:34 PM
- Re: Thanks Gary but the historical files change every month - Gary Crisci on Mar 2, 4:40 PM
- 9.3.1 - Anonymous on Mar 2, 6:32 PM
- Re: Thanks Gary but the historical files change every month - TimG on Mar 2, 8:05 PM
- Thats the last resort...but? - Anonymous on Mar 3, 12:35 PM
- Re: Thats the last resort...but? - TimG on Mar 3, 1:53 PM
- Why not use partitioning? - Angie on Mar 3, 6:24 PM
- 2 options - Anonymous on Mar 8, 10:32 PM
- Looks promising - Anonymous on Mar 10, 2:49 PM