Page 1 of 1
Subset importing
Posted: Wed Jul 21, 2010 10:32 am
by ravi
Hi All,
Is it possible to import subset from one cube to another cube- if what are the steps.
Note: I have one one subset in a cube - and I want to import this subset to another cube.
Regards,
Ravi
Re: Subset importing
Posted: Wed Jul 21, 2010 11:10 am
by lotsaram
A subset is attached to a dimension not a cube. If dimensions are shared between cubes then subsets in the dimension will automatically be available for queries to all cubes of which the dimension is a part of.
Try explaining again what you want to do. With your current explanation one would just be guessing at best.
Re: Subset importing
Posted: Wed Jul 21, 2010 11:36 am
by ravi
Hi
Yes- Besically I want to share dimension between the cube.
How would i do that-
Now the cube is already created with one wrong dimension-I want import or share correct dimension which is available in some other cube.
Regards,
Ravi
Re: Subset importing
Posted: Wed Jul 21, 2010 9:04 pm
by Alan Kirk
ravi wrote:Hi
Yes- Besically I want to share dimension between the cube.
How would i do that-
Now the cube is already created with one wrong dimension-I want import or share correct dimension which is available in some other cube.
Regards,
Ravi
You can't change the dimensions once you've created a cube. The only thing you can do is (assuming that you want the corrected cube to have the same name) is export the data from the existing cube to a text file, delete the old cube, create the new one with the correct dimensions, and reimport the data.
However this doesn't have anything to do with subsets. As lotsaram said, those go along with the dimensions.