COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: inu on 14 Apr 2017 05:06:31 AM

Title: How to set default value in ParallelPeriod()
Post by: inu on 14 Apr 2017 05:06:31 AM
Hi Team,
I tried a lot to set the default value, but getting internal error each time , the data item i created as below

parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year],1,#prompt ('P_ConversionRatio', 'token','[Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year]->[all].[2017]')#)

Please suggest...


Regards,
Inam
Title: Re: How to set default value in ParallelPeriod()
Post by: fry on 15 Apr 2017 07:10:10 AM
 Sometimes I find what helps is to add default value as a separate data item and then drag in your default expressions. Validate each data item individually first

parallelPeriod ( [great_outdoors_company].[Years].[Years].
[Quarter] , -1 , [2006/Aug] )
Result: 2006/Nov