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

Issue while cascading in prompts

Started by midhl, 16 Nov 2010 04:43:04 AM

Previous topic - Next topic

midhl

Hi,

I have a requirement where in i have 2 value prompts start and end prompt.Both the prompts use tabular sql.My requirement is based on the value chosen in start prompt,end prompt should show values equal to or greater than start prompt value chosen. For ex if 200901 is chosen in start prompt end prompt should display values 200901 and above.
           To achieve this i used a filter condition in end prompt, end prompt period>= start prompt parameter and chosen start prompt parameter as cascade source for end prompt and also chose autosubmit yes for the start prompt.(Sorry if i confused). However the issue is i am getting an error message that the query contains a reference to atleast one object period that doesnt exist although period is there in the query.

Any ideas on how to resolve this issue.

Thanks in advance

midhl

The above criteria works well when we use query items pulled from package however when tabular sql is used to pull the query items error is thrown that data item not found

MFGF

Tabular SQL?  Is this ReportNet or Cognos 8??

If you want to use hand-cranked SQL in your prompt queries, then you will need to use a prompt macro in the SQL predicate of your second query in place of the query filter you are currently trying to use.

eg WHERE End_Prompt_Period >= #prompt('Start_Prompt_Parameter','token','{:1900-01-01}')#

Regards,

MF.
Meep!