We help IT Professionals succeed at work.

Format Specific Attribute in Dimension

Dear all
I did build my CUBE using VS2008
I want to format Datetime in Dimension from “01-01-2010 00:00:000” to be “01-01-2010”.
How can I do this in the CUBE
Comment
Watch Question

IT Director
CERTIFIED EXPERT
Commented:
The T-SQL command to run to get a SQL Server date to show in the way you require is as follows.

SELECT CONVERT(VARCHAR(15),GETDATE(),105)

Open in new window

Author

Commented:
yes i know how to do this from SQL but i want to know how to do it from inside the CUBE?

thanks,

Explore More ContentExplore courses, solutions, and other research materials related to this topic.