Hi,

I'm creating a report with a prompt page using a value prompt with the following values:

In my report page, Page1, I am able to get the correct result with report expressions:
ParamDisplayValue('pPeriod') and ParamValue('pPeriod')

When I try to use ParamDisplayValue in a filter, I receive the following error message:
XQE-GEN-0032 The function 'ParamDisplayValue' is an unknown function.
Text to expand:
[Month key] = #ParamDisplayValue('pPeriod')#

Using [Month key] = #ParamValue('pPeriod')# is irrelevant, but it does not throw any error such as unknown function.

Any idea?

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

#CognosAnalyticswithWatson

You probably just need your filter to be:

[Month key] = ?pPeriod?

------------------------------
Chris Turner
------------------------------

Original Message:
Sent: Tue May 03, 2022 04:27 AM
From: Patrick Neveu
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

Hi,

I'm creating a report with a prompt page using a value prompt with the following values:

In my report page, Page1, I am able to get the correct result with report expressions:
ParamDisplayValue('pPeriod') and ParamValue('pPeriod')

When I try to use ParamDisplayValue in a filter, I receive the following error message:
XQE-GEN-0032 The function 'ParamDisplayValue' is an unknown function.
Text to expand:
[Month key] = #ParamDisplayValue('pPeriod')#

Using [Month key] = #ParamValue('pPeriod')# is irrelevant, but it does not throw any error such as unknown function.

Any idea?

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

#CognosAnalyticswithWatson

Hi Chris,

I really need to use ParamDisplayValue in this case.

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Original Message:
Sent: Tue May 03, 2022 04:57 AM
From: Chris Turner
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

You probably just need your filter to be:

[Month key] = ?pPeriod?

------------------------------
Chris Turner

Original Message:
Sent: Tue May 03, 2022 04:27 AM
From: Patrick Neveu
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

Hi,

I'm creating a report with a prompt page using a value prompt with the following values:

In my report page, Page1, I am able to get the correct result with report expressions:
ParamDisplayValue('pPeriod') and ParamValue('pPeriod')

When I try to use ParamDisplayValue in a filter, I receive the following error message:
XQE-GEN-0032 The function 'ParamDisplayValue' is an unknown function.
Text to expand:
[Month key] = #ParamDisplayValue('pPeriod')#

Using [Month key] = #ParamValue('pPeriod')# is irrelevant, but it does not throw any error such as unknown function.

Any idea?

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

#CognosAnalyticswithWatson

Hi Patrick, 

ParamDisplayValue works only in the layout and not queries. For queries you have to use ParamValue method. In your case though, you can change the prompt to use Month Key as the useValue and then use ?pPeriod? or ParamValue('pPeriod') in query filter. 

Regards
Kiran

------------------------------
Kiran Passumarthi
www.linkedin.com/in/kiranpassumarthi
------------------------------

Original Message:
Sent: Tue May 03, 2022 05:07 AM
From: Patrick Neveu
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

Hi Chris,

I really need to use ParamDisplayValue in this case.

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company

Original Message:
Sent: Tue May 03, 2022 04:57 AM
From: Chris Turner
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

You probably just need your filter to be:

[Month key] = ?pPeriod?

------------------------------
Chris Turner

Original Message:
Sent: Tue May 03, 2022 04:27 AM
From: Patrick Neveu
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

Hi,

I'm creating a report with a prompt page using a value prompt with the following values:

In my report page, Page1, I am able to get the correct result with report expressions:
ParamDisplayValue('pPeriod') and ParamValue('pPeriod')

When I try to use ParamDisplayValue in a filter, I receive the following error message:
XQE-GEN-0032 The function 'ParamDisplayValue' is an unknown function.
Text to expand:
[Month key] = #ParamDisplayValue('pPeriod')#

Using [Month key] = #ParamValue('pPeriod')# is irrelevant, but it does not throw any error such as unknown function.

Any idea?

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

#CognosAnalyticswithWatson

Hi Kiran,

Thank you for the clarification. I was sure it was also available in the query, so my mistake!

Thank you also Jean-Philippe.

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Original Message:
Sent: Wed May 04, 2022 04:06 AM
From: Kiran Passumarthi
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

Hi Patrick, 

ParamDisplayValue works only in the layout and not queries. For queries you have to use ParamValue method. In your case though, you can change the prompt to use Month Key as the useValue and then use ?pPeriod? or ParamValue('pPeriod') in query filter. 

Regards
Kiran

------------------------------
Kiran Passumarthi
www.linkedin.com/in/kiranpassumarthi

Original Message:
Sent: Tue May 03, 2022 05:07 AM
From: Patrick Neveu
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

Hi Chris,

I really need to use ParamDisplayValue in this case.

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company

Original Message:
Sent: Tue May 03, 2022 04:57 AM
From: Chris Turner
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

You probably just need your filter to be:

[Month key] = ?pPeriod?

------------------------------
Chris Turner

Original Message:
Sent: Tue May 03, 2022 04:27 AM
From: Patrick Neveu
Subject: Cognos Analytics v11.2.1: ParamDisplayValue is seen as an unknown function.

Hi,

I'm creating a report with a prompt page using a value prompt with the following values:

In my report page, Page1, I am able to get the correct result with report expressions:
ParamDisplayValue('pPeriod') and ParamValue('pPeriod')

When I try to use ParamDisplayValue in a filter, I receive the following error message:
XQE-GEN-0032 The function 'ParamDisplayValue' is an unknown function.
Text to expand:
[Month key] = #ParamDisplayValue('pPeriod')#

Using [Month key] = #ParamValue('pPeriod')# is irrelevant, but it does not throw any error such as unknown function.

Any idea?

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

#CognosAnalyticswithWatson