cube help | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

cube help

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

Have you observed the same error even though after refreshing the cube?

yes
So have you joined them manually as per the message using the BIDS?

i think BIDS is a 2005 tool. i’m working in 2000.
still, yes i joined them manually

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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |