a bit confuse round here, does SSAS stored ETL result? or is it SSAS connect directly to the production databases?
+1
A:
Best to have ETL move data from production databases into data warehouse database, then SSAS connects to data warehouse database.
There's far too much to explain here about the subject, some good reading is at http://www.ralphkimball.com/
Meff
2010-05-06 14:54:17
Thanks for the link.
Irman
2010-05-30 00:08:39
another question crossed on my mind, you said that ETL moves data from production into datawarehouse, well in "restructured" form or just copy whole the original then manipulate in SSAS?
Irman
2010-06-02 10:54:44
@Irman, if you study the tutorials at the link I gave you, they explain the best way is to restructure the data. A production database will usually be normalised, but a data warehouse is usually denormalised. Good luck, and consider buying this book: http://www.amazon.co.uk/Microsoft-Data-Warehouse-Toolkit-Intelligence/dp/0471267155/ref=pd_sim_b_3/277-1431283-4145040
Meff
2010-06-24 08:15:45
i was hoping a very simple short answer, well thats ok, thanks for the recommendation.
Irman
2010-06-26 02:14:19