Hi Team,
I used the following code to get the measure value for prev parallel period as follows:
tuple([Candidates Applied to Interviewed],parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year], 1, [Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year]->[all].[2017]))
Getting error : value can not be coerced into member.
Please suggest..
Regards,
Inam
Quote from: inu on 07 Apr 2017 01:19:14 AM
Hi Team,
I used the following code to get the measure value for prev parallel period as follows:
tuple([Candidates Applied to Interviewed],parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year], 1, [Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year]->[all].[2017]))
Getting error : value can not be coerced into member.
Please suggest..
Regards,
Inam
I used below syntax as well, but error coming.
tuple(parallelPeriod ([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year], 1,
currentMember(hierarchy([Hiring Process].[Requisition Raise Date].[Requisition Raise Date].[Year]))),
[Candidates Applied to Interviewed])