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
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
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.