COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: inu on 07 Apr 2017 08:09:04 AM

Title: tuple on parallel period function
Post by: inu on 07 Apr 2017 08:09:04 AM
Hi Team,

I used the following code for parallel period
parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year], 1,
[Hiring Process].[Requisition Raise Date].[Requisition Raise Date]->?Parameter2?)

i want to fetch the measure value for parallelperiod, so i used tuple function as
tuple([revenue],parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year], 1,
[Hiring Process].[Requisition Raise Date].[Requisition Raise Date]->?Parameter2?))

getting error. value expression cant be coerced into member


Please suggest
Title: Re: tuple on parallel period function
Post by: MFGF on 10 Apr 2017 02:53:56 AM
Quote from: inu on 07 Apr 2017 08:09:04 AM
Hi Team,

I used the following code for parallel period
parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year], 1,
[Hiring Process].[Requisition Raise Date].[Requisition Raise Date]->?Parameter2?)

i want to fetch the measure value for parallelperiod, so i used tuple function as
tuple([revenue],parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year], 1,
[Hiring Process].[Requisition Raise Date].[Requisition Raise Date]->?Parameter2?))

getting error. value expression cant be coerced into member


Please suggest

I'd suggest [revenue] might be a calculated value, not a measure from your package? Can you tell us what it is?