Cognos User Group
Download
1 / 11

Cognos User Group - PowerPoint PPT Presentation


  • 65 Views
  • Uploaded on

Cognos User Group. Framework Manager and Transformer Tips August 6, 2010. Topics. Framework Manager Using filters Governors Diagram settings “As View” query subjects vs. “Minimized” Transformer Using categories for counts Creating “Bucket Dimensions” Time dimensions

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Cognos User Group' - kioko


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Cognos User Group

Framework Manager and Transformer Tips

August 6, 2010


Topics
Topics

  • Framework Manager

    • Using filters

    • Governors

    • Diagram settings

    • “As View” query subjects vs. “Minimized”

  • Transformer

    • Using categories for counts

    • Creating “Bucket Dimensions”

    • Time dimensions

    • When to use a DMR model (in Framework Manager)


Fm filters
FM - Filters

Filter Options

  • Embedded (within query subject)

    • Required

    • Optional

    • Design Mode

  • Stand-alone

    • Only way to make hard-coded filter optional

    • Use screen tip so that you know what the filter is !

  • Studios


Fm governors
FM – Governors

  • Use to improve performance by reducing system requirements

  • “Big 5” Infolink has found useful:

    • Max Rows Retrieved

    • Query time limit

    • Large Text (BLOBS) limit

    • Cross-Product joins

    • Usage of local cache


Fm diagram settings
FM – Diagram Settings

  • Context Explorer vs. Diagram tab

    • Use Navigate Diagram to control defaults

      • Shrink to fit

      • Layout control

      • Settings control


Fm as view query subject
FM – “As View” query subject

  • Default is “Minimized”

  • How does “As View” work?

    • Creates in-line view

    • Controls order of query processing

  • Why use “As View”

    • Accuracy

    • Merged query subject outer join example


Transformer category counts
Transformer – Category Counts

  • 3 types of measures in Transformer

    • Column

    • Calculated

    • Category Count

    • Category Count type measure is used to provide a distinct count of members among dimension levels of a level you specify in the Dimension Map. (note 65,536 limit)


Trans category counts continued
Trans – Category Counts continued

  • You can create a category count using multiple columns from a data source.

  • Example: Unique employee is determined by Employee ID + Employee Record. We want to count this within our dimension levels


Trans bucket dimensions
Trans – “Bucket Dimensions”

“Bucket Dimensions” are useful when you want to categorize measures (like employee count) into pre-determined buckets that you define within Transformer.

In our example, we create our buckets using calculated columns in the data source. (Note: you can do this in FM as well)


Trans time dimension
Trans – Time Dimension

  • Standard Time Dimension

    • Cognos automatically builds dimension levels from a date using a wizard.

    • Relative time

    • Adding additional drill path

    • Custom Time Dimension

    • Is a regular (non-time) dimension

    • Create your own time categories and sorting


Fm dmr
FM - DMR

  • Dimensionally Modeled Relational Data (DMR)

    • Provides OLAP Cube style reporting

    • Useful for real time reporting on small data sets that have a good framework model

    • Drawbacks:

      • Performance (typically slower than PowerCubes which are pre-aggregated)

      • Consumes database server resources with report queries


ad