Hello,

I am trying to create a local cube with parent-child hierarchy using CREATE
GLOBAL CUBE syntax. The Parent-Child dimension is created with the Level
Naming Template used in the source Analysis Server cube but it does not work
if only some of the levels are included.
I tried the following:

CREATE GLOBAL CUBE [LocalHR]
STORAGE 'C:\Temp\CreateLocalCube\Test.cub'
FROM [HR] (

MEASURE [HR].[Org Salary],
MEASURE [HR].[Count],

DIMENSION [HR].[Employees] (
LEVEL [CEO],
LEVEL [Senior Management],
)
)

I received this error: “Unable to open cellset. Column expression associated
with ‘_TemplateLevel’ is not found”

1. Is there any way in which I can include only some levels of a Parent-Child
hierarchy?

2. Otherwise how can I check if a dimension or a hierarchy is a Parent-Child?

Thanks,
Yones


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1