Function to get the month from the date dimension using a cube

[damzI]

Hello All,

So I am creating a report using a cube. I need to extract the month from the date dimension. My month cation looks like YYYY/mmm (eg 1996/Apr). Any ideas on how to get only the month from above. Have tried to recast it to a sting and then use substring (I can only get the year but not the month). Also have tried the 'Extract' function - both don't work...

Thanks, D

[damzI]

Never mind - manage to get it using the CAST function...

cast ([CubeName].[Date].[Date].[Month] -> ?RM?, VARCHAR(10), 6)

Thanks ! - D