dbTalk Databases Forums  

Server Time Dimension

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


Discuss Server Time Dimension in the microsoft.public.sqlserver.olap forum.



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

Default Server Time Dimension - 08-02-2006 , 09:45 PM






All,

I'm using a server time dimension in an SSAS cube. How do I change the
display name? It currently displays "calendar mm/dd/yyyy" and I would like
to get rid of the "calendar" description.

Thanks for the help!

Scott Mescall

Reply With Quote
  #2  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: Server Time Dimension - 08-03-2006 , 02:51 PM






Unfortunately the format isn't customizable -- one solution for you may be
to use the BI Studio to create and populate a table with the time dimension
(there is a wizard to do this) and then update the names in the table to use
your own format.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Scott Mescall" <ScottMescall (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I'm using a server time dimension in an SSAS cube. How do I change the
display name? It currently displays "calendar mm/dd/yyyy" and I would
like
to get rid of the "calendar" description.

Thanks for the help!

Scott Mescall



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.