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

Expected format is unknown for static choice

Started by mewyeen, 10 Nov 2008 02:31:14 AM

Previous topic - Next topic

mewyeen

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?


pooja

Did take the parameter...after case..??

u should pass parameter...after case,,



pj

mewyeen

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.

mewyeen

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.