Saturday, September 27, 2014

How to design Cognos interactive reports 05 - Make filters flexible with operators

    1. Context

Further to solutions (How to design Cognos interactive reports 03, 04), you want to have filters to filter data based on operator. The idea is to make filter statement be flexible with prompt token. This document will demonstrate the idea to use prompt token to generate filter with operator. Please see attached report specification for review (version 10.2 with sample Package GoSales)

    1. Sample

All three pieces of filter are dynamic. Based on the choices from all three prompt, a very flexible filter can be specified by business users.
    1. Prompt

      1. First value prompt

      1. Second value prompt

      1. Third List box

    1. Query

The key to make filters flexible is to apply prompt token
#Prompt('pFilter1_Column', 'token')#  #Prompt('pOperator', 'token')#  ?pFilter1_Values?

Checking generated SQL statement as below
where coguda00.SALES_REGION_EN > 'Central Europe'
    1. Layout

No comments:

Post a Comment