dbTalk Databases Forums  

Auto Naming of Levels in Parent-Child Dimension

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


Discuss Auto Naming of Levels in Parent-Child Dimension in the microsoft.public.sqlserver.olap forum.



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

Default Auto Naming of Levels in Parent-Child Dimension - 09-28-2005 , 06:53 AM






Within our organisation we have local cubes, created directly using create
cube DDL syntax, and Server cubes, produced through the Analysis Services.
Both have parent child dimensions, but the level naming convention seems
different.

When creating a Local Cube we have level names with the LevelName Prefix

e.g.
ProductLevel
ProductLevel 01
ProductLevel 02
ProductLevel 03

However our Server cubes produce the following:

Level 01
Level 02
Level 03
Level 04

Is there a way to make the level names the same / gain some degree of
control of level naming of local cube and server cube parent-child dimension
naming.

regards,

Richard


Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Auto Naming of Levels in Parent-Child Dimension - 09-28-2005 , 07:27 PM






There is a property of the Level under the Advanced Tab called
LevelNamingTemplate. If you have a look in Books On Line it will give
you more info, but basically in your example you could change the
template to "ProductLevel *" and you should be in business.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

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.