Cognos Analytics

 View Only

 XQE-V5-0005 Identifier [Physical View].[D_ACTR_FE_SF_COMMUN_H].[PROV_DESCR_C] not found.

Guillaume Lafrance's profile image
Guillaume Lafrance posted Fri July 04, 2025 04:41 PM

I have the XQE-V5-0005 problem in Cognos Analytics. 

The report works fine and execute well in Cognos.

But when I go to the parameters page in the report. I get the error message in the subject title.

It happens when I have a column that is for different language (ex : _AN for english and _FR for french at the end of the column name).

This is the expression I have in my framework : #'[Vue physique].[D_ACTR_FE_SF_COMMUN_H].[PROV_DESCR_C' + $Language_Lookup{$runLocale} + ']' #

The $Language_Lookup have these value : _AN and _FR.

What is the problem?

Marc Reed's profile image
Marc Reed IBM Champion

your Language Lookup isn't returning an entry - [PROV_DESCR_C], rather than [PROV_DESCR_C_AN].

What does the Language_Lookup parameter map look like?

It may be that this parameter map doesn't have an entry for your $runLocale.

You could test this by providing a default entry on the parameter map such as NOENTRY.

Then if you get the error message [PROV_DESCR_CNOENTRY] you know this is the cause.

Patrick Neveu's profile image
Patrick Neveu IBM Champion

Bonjour Guillaume,

As Marc wrote, your language lookup is not returning a valid entry.

You might consider writing a macro similar to the following sample or use a default value in your parameter map:

#

case xxx
when ABC then ...

when DEF then ...

else ...
end 

#

Best regards,

Guillaume Lafrance's profile image
Guillaume Lafrance

Guillaume Lafrance's profile image
Guillaume Lafrance

Turns out that when I put a default entry in my Language_Lookup (_FR or _AN), it's working. No more error message. Thanks all.