Cognos

Páginas: 18 (4433 palabras) Publicado: 17 de septiembre de 2012
Tip or Technique

Report Studio Workshop - Slicers
Product(s): Cognos 8 Area of Interest: Report Design

Report Studio Workshop - Slicers

2

Copyright Your use of this document is subject to the Terms of Use governing the Cognos software products and related services which you have licensed or purchased from Cognos. The information contained in this document is proprietary informationof Cognos Incorporated and/or its licensors and is protected under copyright and other applicable laws. You may use the information and methodologies described in this document 'as is' or you may modify them, however Cognos will not be responsible for any deficiencies or errors that result from modifications which you make. Copyright 2006 (c) Cognos Incorporated. All Rights Reserved. You can printselected pages, a section, or the whole book. Cognos grants you a non-exclusive, non-transferable license to use, copy, and reproduce the copyright materials, in printed or electronic format, solely for the purpose of providing internal training on, operating, and maintaining the Cognos software. This document is maintained by the Best Practices, Product and Technology team. You can sendcomments, suggestions, and additions to Best Practices, Product and Technologies.

Proprietary Information

Report Studio Workshop - Slicers

3

Contents
1 1.1 1.2 2 3 3.1 4 5 6 7 8 9 10 INTRODUCTION ............................................................................................ 4 PURPOSE.............................................................................................................. 4 APPLICABILITY ....................................................................................................... 4 SLICER OVERVIEW ....................................................................................... 4 SLICER OR CONTEXT FILTERS ...................................................................... 6 RELATIONAL VS. OLAP CONTRAST............................................................................... 7 SLICER EXAMPLES ........................................................................................ 7 WORKSHOP................................................................................................... 8 PROMPTING ................................................................................................ 16 SLICERS AS CONTEXT................................................................................. 20 CASCADING VALUE PROMPTS FOR SLICERS .............................................. 23 DATE RANGES IN SLICERS ......................................................................... 26 CONCLUSION .............................................................................................. 28

ProprietaryInformation

Report Studio Workshop - Slicers

4

1 Introduction
1.1 Purpose You may have stumbled across a query object in Report Studio called a slicer.

In this workshop we will explore the slicer and how it can be used to focus reporting to identify specific data sets. 1.2 Applicability Slicers are relevant to reporting with Dimensional data sources in Report Studio using Cognos 8.

2Slicer Overview
The slicer is used to create dimensional filters used to reduce the data included in measure rollups. In other words, in a crosstab, the slicer is a filter applied to the cells of the crosstab but not the rows or columns. Slicers require a dimensional model and cannot be used without – as they are defined by member set expressions which are only applicable to dimensionalstructures. The idea of filters in OLAP is very different from filters in SQL. First and foremost, the edge definitions are dimensional expressions determining which members appear on each edge. Therefore, the row and column edge definitions are in effect filters. When you invite certain members to your edge party, by implication, you are un-inviting all the other members.

Proprietary Information...
Leer documento completo

Regístrate para leer el documento completo.

Estos documentos también te pueden resultar útiles

  • Cognados
  • Cognados
  • cognados
  • Cognos
  • Cognados
  • Cognos
  • los cognados
  • Cognados

Conviértase en miembro formal de Buenas Tareas

INSCRÍBETE - ES GRATIS