SSAS - Simple Date Expression

              In general the Time dimension table will contain the full date (ie, Date with Time format) which is not preferable while browsing the data from the cube. If you want to display the Date field in the Format like “June 25,2008” –follow the given below steps:

è In Data Source View ,Right Click on Time Dimension

è  Choose “New Named Calculation”

è  Enter the Column name for the new field (Ex :SimpleDate)

è  Type following Expression.

(In the following sample Full_Date is the Date Field.)

 

Syntax:

DATENAME(mm, Full_Date) + ' ' +

DATENAME(dd, Full_Date) + ', ' +

DATENAME(yy, Full_Date)