Parent-Child Template -
01-03-2005
, 06:43 AM
Hi
In Analysis-Service (SQL-2000) you have the possibility to define a template
for a parent-child dimension, which means you deliver a list of
comma-separated values that are used to name the levels of the dimension.
How can I do this in a local cube? My createcube-statement is
CREATECUBE=CREATE CUBE [Order] (DIMENSION [Group] DIMENSION_STRUCTURE
PARENT_CHILD, LEVEL [All Groups] TYPE ALL, LEVEL [Group] ROOT_MEMBER_IF
ROOT_IF_PARENT_IS_BLANK_OR_SELF_OR_MISSING, MEASURE [Quant] FUNCTION SUM);
Where do I have to insert the template? I tried to use the information in
http://msdn.microsoft.com/library/de...dldml_3n1w.asp, but didn't get to work it.
Thanks for your help.
Regards,
Olaf |