1 / 11

Cognos User Group

This article provides tips and tricks for using Framework Manager and Transformer in Cognos, including topics like filters, governors, diagram settings, and time dimensions.

kgerald
Download Presentation

Cognos User Group

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Cognos User Group Framework Manager and Transformer Tips August 6, 2010

  2. 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)

  3. 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

  4. 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

  5. FM – Diagram Settings • Context Explorer vs. Diagram tab • Use Navigate Diagram to control defaults • Shrink to fit • Layout control • Settings control

  6. 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

  7. 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)

  8. 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

  9. 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)

  10. 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

  11. 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

More Related