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 |