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

XQE-QTE-0003 error

Started by pradeepbi25, 03 Aug 2015 02:01:52 PM

Previous topic - Next topic

pradeepbi25

I have report a with radio button filter with static values 'Current Month' and 'Previous Month' and default value is 'Current Month'.
This radio button prompt is in report page not in prompt page.
When I run the report report renders perfectly for 'Current Month'. But, When I am selecting 'Previous Month' the report is giving below error message.

XQE-QTE-0003 The transformation "V5QueryRelationalPlanningTransformationLibrary - SetDetailContextOfV5DataItem" was applied but did not modify the query plan.

I am using this radio button filter as below on the query:

DATE >=
(case
when
?param_month? = 'Current Month'
then
(case
when
extract (day ,current_date) = 1
then
_first_of_month (_add_days (current_date,-1))
else
_first_of_month (current_date)
end)
when
?param_month? = 'Previous Month'
then
_first_of_month (_add_months (current_date,-1))
end)
and
DATE <
(case
when
?param_month? = 'Current Month'
then
current_date
when
?param_month? = 'Previous Month'
then
_first_of_month (current_date)
end)

Thanks in advance

pradeepbi25

I think the issue is with repeater table. I am using two repeater tables in the report. These two repeater tables contains graphs.
When I deleted one repeater table from the report I am not getting the issue.