Mindmajix

Creating static and parameterized filters

MODEL FILTERS:

  • A filter is a restriction that reduces the no. of records returned from the database
  • A condition is created with three elements
  • Query item, Operator, Operand
  • Model filters are reusable
  • Model filters are categorized into 2 types

          a) Static model filters

          b) Parameterized model filters

In this section, let us have a quick glance about Static model filters, as well as about parameterized model filters.

STATIC FILTERS:

  • From project viewer pane
  • Select the MODEL
  • Right click
  • Select Create
  • Click on Filter
  • Enter the name ORDER METHOD
  • From left pane
  • Expand MODEL
  • Double click on the query item order_method_en
  • Type the operator in
  • Type the operands as (‘web’,’telephone’)
  • Click on OK

TESTING FILTERS:

  • From MODEL
  • Expand the SALES namespace
  • Select order_method query subject
  • Right click
  • Click on Edit definition
  • Select the filter
  • Drag the filter to the filters window
  • Select the test tab
  • Click on test sample
  • From filters table
  • Clear the filter
  • Click on OK

Screenshot_42

Screenshot_43

Screenshot_44

Screenshot_45

Screenshot_46

Screenshot_47

Screenshot_48

Screenshot_49

Screenshot_50

Parameterized filters:

  • A parameterized filter lets the user/prompts the user to select the value/enter the value to restrict the data returned from the database
  • A parameterized filter is also known as prompt/dynamic filter
  • Prompt lets the user to select the value at query runtime
  • A prompt is a user interactive object

Syntax:

Query item      operator      ?parameter?

Order_method      in      ?ord?

http://bit.ly/1Oa0zn2

 

Enroll for LIVE Instructor LED ONLINE COGNOS TRAINING


0 Responses on Creating static and parameterized filters"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.