Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 02 Jan 2017 03:57:50 AM

Title: (XQE-PLN-0098) to_char function is not supported at report(DQM)
Post by: inu on 02 Jan 2017 03:57:50 AM
Hi Team
I am developing dimensional  reports using DQM.
Time filter is
[Agreement Fact - Monthly (Analysis)].[Time Dimension(Fiscal)].[Date].[Month].[Month Key] = #prompt('par_MonTo', 'token',  'cast(to_char (_add_months(current_date,-4), ''YYYYMM''),integer)')#

error: XQE-PLN-0098 The vendor specific function "to_char" is not supported.

Please suggest


Regards,
Inam
Title: Re: (XQE-PLN-0098) to_char function is not supported at report(DQM)
Post by: MFGF on 03 Jan 2017 06:51:49 AM
Quote from: inu on 02 Jan 2017 03:57:50 AM
Hi Team
I am developing dimensional  reports using DQM.
Time filter is
[Agreement Fact - Monthly (Analysis)].[Time Dimension(Fiscal)].[Date].[Month].[Month Key] = #prompt('par_MonTo', 'token',  'cast(to_char (_add_months(current_date,-4), ''YYYYMM''),integer)')#

error: XQE-PLN-0098 The vendor specific function "to_char" is not supported.

Please suggest


Regards,
Inam

Hi,

1. Don't use detail filters with dimensional packages.
2. Don't try to use relational functions with a dimensional package.

Have you looked at using the timestampMask() function with the $current_timestamp variable? That will probably give you more success.

MF.
Title: Re: (XQE-PLN-0098) to_char function is not supported at report(DQM)
Post by: Reyhan Ibrahim on 08 May 2019 03:51:43 AM
just replace to_char with varchar_format
Text only | Text with Images