Date in report studio

[kady]

Hello,

I am new on BI. I am using report studio, i am doing on report (cross table) based on a cube. I have the previous month in this format on the cube 2016/Oct. For example, I only want to display October in my report. Please someone have an idea of what can I do?

Thanks in advance for your help

[superdesi]

Change the label to October

[kady]

I have many months.

[BigChris]

Looks to me like the structure of the cube needs to be looked at.

[kady]

Thanks BigChris. I don't have access to the cube. So I can't do anything in report studio?

[venkat01]

Can't you apply dataformat on it as date display months long display years/days no

Sent from my GT-N8000 using Tapatalk

[New_Guy]

Hi,
Try the below in a layout calculation and place it beside the actual memberCaption and do a box type none on the memberCaption.
case
substring([Query1].[Months],6,3) when 'Oct' then 'October'
substring([Query1].[Months],6,3) when 'Nov' then 'November'
....
for every month

Good luck
New guy

[kady]

No Venka, I can't. It is not a date type.

[kady]

Thanks New_Guy, it's working.  ;D ;D