• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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
0
RamzyNEbeid
Asked:
RamzyNEbeid
1 Solution
 
EvilPostItCommented:
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

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

thanks,
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now