MS SQL Server OLAP - Auto Naming of Levels in Parent-Child Dimension

Author

Auto Naming of Levels in Parent-Child Dimension

Richard Bond

2005-09-28, 7:24 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

Darren Gosbell

2005-09-28, 8:24 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Sponsored Links