(XQE-PLN-0098) to_char function is not supported at report(DQM)

[inu]

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

[MFGF]

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.

[Reyhan Ibrahim]

just replace to_char with varchar_format