Skip to Content
0
Former Member
Apr 07, 2010 at 01:28 PM

Reorganizing Dimensions using remodeling tool

42 Views

Hi ,

I am looking to reorganize the dimenisions in the cube filled with data for perfomance reasons ( entries in dim table vs. fact table % ) and what I found was :

Remodeling tool "cannot" be used and the only way to perform the above task would be to :

1) create a copy of the existing cube

2) transfer data from old to the new cube,

3) reorganize the dimensions in old cube and

4) transfer data from new to old cube .

Can anyone confirm my findings ?

Thanks .

Hitesh