Dear all,
I have created a static choice for a value prompt to filter a the list report query. The expression data item to filter is a calculated field created in the Frame Manager.
The calculated field to be filter is support area status. The condition to generate the support area status field in FM is as below:
Case Status is current = '1' then ('Current') else ('Previous')
In the List report, will list the employee, support area status, support area name. A value prompt is build using the static choices collection of two value as below:
Use Display
---------------------------
Current Current
Previous Previous
When I run the report and choose the value from the value prompt, it show the error as below:
RQP-DEF-0354 The query contains one or more unresolved prompts. QE-DEF-0385 Invalid format for prompt 'Support Area Status'. Expected format is unknown.
How to resolve this issue?
Did take the parameter...after case..??
u should pass parameter...after case,,
pj
The case statement is to created the calculated data item in Frame Manager. Everything is fine in the FM. The data item is created correctly and it can be use to build the dimension.
My problem is when I create a value prompt to filter this data item in the report, it shown error. I even try to build the value prompt using the query on the same data item (the calculated data item) but it show the same error.
RQP-DEF-0354 The query contains one or more unresolved prompts. QE-DEF-0385 Invalid format for prompt 'Support Area Status'. Expected format is unknown.
Hi Pooja,
This error occur when a prompt report is going against a olap data source, from SDK, we should pass the MUN identifier instead of the actual value of the prompt parameter.
Thank you very much for your reply.