If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

To find the prev parallel period in dmr reporting

Started by inu, 07 Apr 2017 01:19:14 AM

Previous topic - Next topic

inu

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

inu

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])