dbTalk Databases Forums  

Parent-Child Template

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Parent-Child Template in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ofri
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.