IBM Cognos BI - Modeling with Prompts and Parameter Maps in Framework Manager

Ensuring performance, flexibility, and reduced maintenance when using prompts and parameter maps within a Framework Manager model.

16 November 2010 (First published 01 January 2009)

This document outlines proven practices for using prompts and parameter maps in ReportNet and IBM Cognos 8 (Framework Manager) to increase model flexibility, decrease maintenance, and improve performance. This document addresses the effects of parameter maps and prompts on SQL generation. Other factors such as dimensional information and determinants play a role in generating SQL, but that is not covered in this document. Differences between Model Query Subjects (MQS) and Datasource Query Subjects (DQS) will be touched on where applicable.

In this article

Topics covered include:

  • Minimized SQL
  • Metadata caching
  • Using Parameter Maps
  • Using Prompts

Download

DescriptionNameSize
Article in PDF formatmodeling_with_prompts_and_parameter_maps.pdf424KB

Resources

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Big data and analytics, Information Management
ArticleID=360583
SummaryTitle= IBM Cognos BI - Modeling with Prompts and Parameter Maps in Framework Manager
publish-date=11162010