Yes but you might want to update or rebuild the dimensions so that they pick up data from the TEST region.

Jez

Kimball's books are about data warehousing and not about cubes. The way I look at DW is that star schema is implemented in a database (in our case SQL...

If you have done only what you have said then it will still show the DEV data. You will need to change the connection properties for each data source...

Steve,

I confess to being a bit a lazy and not wanting to create a new partition each month. I want this to be as automated as possible so if...

Dave,

Thanks for the info.

This is work is part of a larger project to migrate a database from SQL 7 to (don't laugh) SQL 2K - I know it doesn't make...

Dave,

I am running MSAS on a virtual server with a single processing core. I plan to create partitions for the current month and other partitions based on year (the...

Sandra,

Did you get an answer to this?

Jez

You cannot create a workflow between a task and a connection. Select the task and then select (using ctrl) the data pump task to add the workflow.

Jez

Probably the best option.

You can always come back for more tips on tuning.

Jez

Tuning is a massive subject and no one solution fits every situation. There is lots of discussion on this site about tuning so have a browse around the site...

Do you know what part of the DTS package takes the time? I suspect that it is the transfer of data from Oracle. Are the users experiencing blocking...

What indexes do you have on the fact table?

I typically have a composite primary key consisting of the keys from the dimension tables and I cluster this index with the...

There is no way to run the queries in parallel within a stored proc.

There are a couple of things you could consider:

1. Create a DTS package with each query...

In AS 2000 (not sure about AS 2005), when you right click on a cube and select process, the next screen has three radio buttons: incremental update; refresh data; full...

I had this situation before and it was caused by parameter sniffing.

Imagine a table of everybody in the world:

select *

from world

where country = 'Belgium'

Assuming an (non clustered) index on country,...