Print Page - Date in report studio

Title: Date in report studio
Post by: kady on 27 Nov 2017 03:37:28 AM

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

Title: Re: Date in report studio
Post by: superdesi on 27 Nov 2017 07:33:22 AM

Change the label to October

Title: Re: Date in report studio
Post by: kady on 27 Nov 2017 08:12:55 AM

I have many months.

Title: Re: Date in report studio
Post by: BigChris on 27 Nov 2017 08:45:30 AM

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

Title: Re: Date in report studio
Post by: kady on 27 Nov 2017 09:06:29 AM

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

Title: Re: Date in report studio
Post by: venkat01 on 27 Nov 2017 11:41:28 AM

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

Sent from my GT-N8000 using Tapatalk

Title: Re: Date in report studio
Post by: New_Guy on 27 Nov 2017 03:09:00 PM

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

Title: Re: Date in report studio
Post by: kady on 28 Nov 2017 02:33:16 AM

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

Title: Re: Date in report studio
Post by: kady on 28 Nov 2017 02:34:24 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kady on 27 Nov 2017 03:37:28 AM