running olap sp3, sqlserver 2k sp3 (server and client).

I have a cube with 5 dimensions, all private. 3 of the dimensions join the
fact table to other support tables...basic star schema.

I can clone the cube and all its members and properties fine. I then update
the sourcetable, fromclause and join clauses to the new fact table.

I cannot process the cube because the dimesions that join the support tables
in the new cube still have their sql queries going back to the original fact
table!!!

I tried looping through each dimension in the new cube and change the from
cause, but I get an error "Object doesn't support this action".

I also tried looping through the old cubes dimensions, and creating new
dimesions for the new cube, and then cloning the dimesion from the old
dimension.. similar error though.

How can I change the dimesions from the old fact table to the new 1?

I've gotten down to what I think is the last step in copying a cube.

I can close it, update all the fact/source table properties, then update the
private dimesions fact/source table properties, and now I'm down to the
levels of the dimesions.

It appears that the MemberKeyColumn option actually affects the
MemberNameColumn!

I can change the Name column to the new table, but not the key.

And if I only change the Key, when it updates, the Name is changed, and not
the key, even thought I didnt change the Name!

Any ideas?

Heres a piece of the code:

For Each dsoLevel In dsoDim.Levels

dsoLevel.MemberKeyColumn = dsoLevel.MemberKeyColumn.Replace("Base",
FACT_Table)



dsoDim.Update()

Next


"PCH" <pch12 (AT) hotmail (DOT) com> wrote