|
Home > Archive > MS SQL Server OLAP > March 2006 > SSAS 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi all,
How can I change the format of the display column of the level in the
hierarchy of a dimension in SSAS 2005. What I mean is, like if I want
to display year 2004 as 'Year - 2004' I could format it in the member
display name option provided in the SQL 2000 AS. I tried 'NameColumn'
option provided in the yukon SSAS but doesnt seem to be working. Is
there any way around?
Regards,
Gayatri Kulkarni.
| |
| Darren Gosbell 2006-03-31, 8:26 pm |
| You could create a calculated column at the DSV level and then use that
as the name column.
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1143812007.184542.122290@i39g2000cwa.googlegroups.com>,
gayatri.kulkarni@gmail.com says...
> Hi all,
>
> How can I change the format of the display column of the level in the
> hierarchy of a dimension in SSAS 2005. What I mean is, like if I want
> to display year 2004 as 'Year - 2004' I could format it in the member
> display name option provided in the SQL 2000 AS. I tried 'NameColumn'
> option provided in the yukon SSAS but doesnt seem to be working. Is
> there any way around?
>
> Regards,
> Gayatri Kulkarni.
>
>
|
|
|
|
|