Cascading Prompt using Static Choices In IBM Cognos 10 Report Studio

1. What is cascading prompt?
   Cascading prompt in such type of prompt that uses the value of one prompt to filter the value of another prompt. For example suppose you have two columns in a list like country and city. You apply prompt on these two. Declare the second prompt as a cascade of first prompt after this when you select the value from first prompt then according to this the value of the second prompt will automatically update.
   
   
   Cascading Prompt Using Static Choices:
   Steps:
   1)      Create a list report.
   2)      Create a value prompt of country.
   3)      Create another value prompt of city.
   4)      Click on first prompt and from the properties pane select “static Choices”.
   5)      Create a new.
   6)      Create 2 static choices for display and value suppose you create ‘first’ and Second static choice.
   
   
   
   
   
   
   
   7)      Select the second value prompt from the properties pane set the cascading source to the first.
   
   
   
   
   
   8)      Open the main query and edit the Detail filter expression like this.
   9)      case
   when (?Parameter1?='a') then([northwind final PKG].[Customers].[Country]='USA')
   when (?Parameter1?='b') then
   ([northwind final PKG].[Customers].[Country]='Brazil')
   else ([northwind final PKG].[Customers].[Country]=?Parameter1?)
   end
   
   
   
   
   
   
   
   
   10)  open the second prompt query and write the filter expression  like this .
   
   
   case
   when (?Parameter1?='a') then([northwind final PKG].[Customers].[Country]='USA')
   when (?Parameter1?='b') then
   ([northwind final PKG].[Customers].[Country]='Brazil')
   else ([northwind final PKG].[Customers].[Country]=?Parameter1?)
   end
   
   
   11)  Run the report.
   
   
   
   
   
   
   
   
   
   
   
   
   In the above filters we can change the logic of front end and the back end will be same. When parameter1 matches ‘a’ the at the back end ‘a’ will be replace with ‘USA’ and shows the concern cities of ‘USA’ in the second prompt. Same in the case with ‘b’. 
   
   
     For Further visit: http://www.segmentbi.com/