I am trying to create a local cube from a cube which has a parant child
dimension. Is the syntax for DIMENSION clause in the CREATE CUBE
statement different for a parent-child dimension ? Because when I use
syntax as with other dimensions, I am getting an error. Can Local cubes
contain parent-child dimensions ?

Thanks

There are some issues with parent child dimensions in local cubes.
If I'm not mistaking it is possible to use the create global cube syntax to
create local cubes with parent child. But then the lowest level wasn't taken?

It is not possible to use parent child and have the same result as in the
online cube.

We worked around this problem by using a view that generates a dataset from
the parent child table to a normalized model. And then import it as a
regular dimension.

I just hope that you aren't using custom members...

Regards,
Nico

"vsridhar420 (AT) gmail (DOT) com" wrote: