Mindmajix

Design a List Report with Model Filter in Cognos

You can use Report Studio or Query Studio list reports, designed against DMR or relational data sources. When doing so, create the report to include prompts so that when testing the model, you can test a subset of the data that would be included in the full cube build.

  • Add the following query items to the list
  • Sales territory
  • Product line
  • Quantity
  • Revenue
  • Gross profit
  • Define a group on sale territory
  • Define total on quantity, revenue and gross profit
  • From menu bar select data
  • Select the filters
  • Screenshot_775Select edit filters
  • Select detail filters tab
  • Screenshot_776Click on Create
  • Select the radio button Advanced
  • Expand Filters
  • Double click on Americas
  • Click on OK
  • Click on OK
  • Save & run the report

DESIGN A LIST REPORT WITH MODEL FILTER

Screenshot_777

Screenshot_778

Screenshot_779

Screenshot_780

Screenshot_784

Screenshot_782

Screenshot_783


 

0 Responses on Design a List Report with Model Filter in Cognos"

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.