hello everybody, i am rather new in this OLAP bussiness. i've build a cube that has both dimension tables and fact table updating from day to day. how can i update the entire cube daily? by having a Sql Server DTS make this i realized that the cube data was not reliable. I've made the data reliable by counting again dimensions members and reprocess the cube. Still, i cannot do this day by day, cause it will take long time. Any suggestions on this matter? Thank you
Take help of these articles: http://www.sql-server-performance.com/articles/biz/optimizing_incremental_update_wizard_p1.aspx http://www.sql-server-performance.com/wp_msas_5.asp http://technet2.microsoft.com/Office/en-us/library/f115bf03-7260-49b0-a1df-d240638b9be41033.mspx http://sqlserver-qa.net/blogs/bi/ar...-2005-analysis-services-operations-guide.aspx - this one covers for SQL 2005 too.
Hi, Thanks a lot for the documentation. first link realy helped. Question: updating the dimensions has the same logic as Incremental Update of the main data? I have updated a dimension, and the number of dimension members didn't get modified(i see that by counting them after) !!!
How often you refresh your fact table depends on your business needs, so be sure to check with your users. Populating the dimension tables is much trickier than populating the fact tables. Some dimensions are relatively small and static. After you have created these, you almost never have to worry about them again. When you're working with frequently modified dimensions, you have to warrant the capability to rebuild the dimension before you rebuild the fact table. Therefore, you might want to put the whole rebuilding routine in a transaction. What is the service pack of AS server you are running?
Service Pack 4. What do you mean by: "put the whole rebuilding routine in a transaction." ? A DTS package that would do Incremental Update & Incremental Update Dimensions could be a transaction or ....?
Hi again, it seems that there was a mistake into the initial concept of the cube. i removed some dimension and now i have correct data... still those missing dimensions that i have now, were important. how can i found those problems. maybe this error helps: "unable to find automatic join between the ccube fact's table and the following dimension table(s): ........ these tables must be joined manually in cube editor " thanks
Yes it is, my mistake here. If so I suggest to refer the issue to MS PSS for any fix as I don't see much information on SQL 2000 OLAP issues.
