 |
|
|
|
|
|
Bridge Tables and IBM Cognos 8
A technique for modeling bridge tables. Bridge tables serve to provide many to many linking relationships between stand-alone star schemas. The zip file contains the document, sample data, and Framework Manager model.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Cognos Metrics Designer and PowerCubes Proven Practices
The purpose of this document is to provide Cognos Metric Designer (CMD) users guidance on defining time mappings for Powercube Import Sources.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Conditional Statements
This document covers best practices in creating Conditional Statements in Cognos Planning Analyst.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Configuring Framework Manager Row Level Security against LDAP
This document shows an example of how an administrator can set up row level security on a Query Subject using LDAP as the authentication source.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Currency Coversions in IBM Cognos Planning
This document offers guidelines on designing currency conversion in Cognos Planning models. Two approaches are discussed: Centralized and De-Centralized currency conversions, examples and screenshots are included.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Designing EP cubes for best use in Powerplay
It is a general collection of tips and techniques to be used when building EP cubes that are going to be queried in PowerPlay
|
|
Articles |
|
01 Jan 2009 |
|
| |
Dimensional Modeling for Time Period Analysis
A technique for Dimensionally Modelled Relational datasources that will allow for relative time period analysis within crosstabs. This technique focuses on developing period-to-date aggregates.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Durable Models
This document discusses some of the concepts behind designing a durable model to help with the lifecycle of a model in an organization.
|
|
Articles |
|
15 Oct 2009 |
|
| |
Emulating IWR User Profile Prompting for IBM Cognos 8 and IBM Cognos ReportNet
Improptu Web Reports handles user profile filters differently than the security filters that can be defined within Framework Manager. This document outlines a technique to mimic the security behavior of IWR using prompts and parameter maps.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Enabling a Multi-developer Environment
Scenarios for enabling multiple developers to simultaneously work on a combined set of Framework Manager models. Topics include Linking, Segmentation, and Source Repositories.
|
|
Articles |
|
01 Jan 2009 |
|
| |
External Repository Control
How to use an external repository to manage Framework Manager models without using the repository controls within Framework Manager as with the supported source control systems.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Field Guidance and FAQ: IBM Cognos Financial Applications and Reporting
This document provides guidelines for using Cognos 8 BI to report on data from Cognos Planning 8.1, Cognos Controller 8.1, and Cognos Finance 7.4.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Flexible Model Solutions
Theory and practice for designing models with flexibility in mind. Techniques are discussed for planning model scope to make maintenance and reporting easier for both model and report developers.
|
|
Articles |
|
01 Jan 2009 |
|
| |
General guidelines - Size Structure and Volume
This document covers some general guidelines with regards to modeling in Framework Manager.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Guidelines to Importing Data into Contoller using Data Manager and Staging Tables
This document will provide guidelines to using both data manager and staging tables to import data into Controller.
|
|
Articles |
|
01 Jan 2009 |
|
| |
How to Successfully work with FM Projects and an External Repository
Descibes how to use an external document management application to control FM models
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos Data Manager Incremental Fact Load
This document shows how a person can handle a complex incremental fact load in an ETL application like IBM Cognos Data Manager.
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos Planning as a Data Source for IBM Cognos BI Reports
This document introduces readers to the improvements in reporting from Cognos Planning and Cognos 8 bi, focused on techniques to improve presentation, navigation and enrich content.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Improved Performance by Flattening Dimensions
This document provides a technique for combining multiple dimensions into a single dimension to improve performance for large Cognos Planning models. The technique can also be used to reduce data sparsity in Cognos Planning models.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Integrating Cognos Enterprise Planning with Essbase
This document outlines the techniques and considerations for integrating Cognos Enterprise Planning with Hyperion Essbase.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Leveraging a Protected Project in a Multi-developer Environment
This document discusses the concept of how to leverage existing functionality within Framework Manager and a Repository Control application to protect a project while allowing multiple developers to access the content at the same time.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Leveraging multi-valued LDAP attributes as session Parameters
This doc shows how to expose multi-valued LDAP attributes as session parameters in IBM Cognos8.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Managing Access Tables in IBM Cognos Planning - Analyst
This document describes a method for managing Cognos Planning - Contributor Access Tables in Cognos Planning - Analyst. This technique may be useful for frequently changing or very large access tables.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Modeling Relative Time as Measures
A discussion of how to produce distinct fact data items for relative time reporting of measures. A single time dimension is used and members for the relative time periods themselves are not created.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Modeling techniques for relative time
Ensuring performance, flexibility, and reduced maintenance when using prompts and parameter maps within a Framework Manager model.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Modeling with Prompts and Parameter Maps
Ensuring performance, flexibility, and reduced maintenance when using prompts and parameter maps within a Framework Manager model.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Preparing multi fact calculations in Framework Manager
How to resolve multi fact calculations with null values in Framework Manager
|
|
Articles |
|
01 Jan 2009 |
|
| |
Prompts Macro Support in Cognos ReportNet
Discusses how to create a prompt macro using Framework Manager.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Proven Practices for Application or Manually Created FM Model XML Documents
Describes the proven practices for using models created either manually or through another application.
|
|
Articles |
|
01 Jan 2009 |
|
| |
ReportNet usage with Oracle Materialized Views
Describes how to model and create reports against Oracle Materialized Views
|
|
Articles |
|
01 Jan 2009 |
|
| |
Scenario1 - Child Tabular Model
This document outlines how to optimize a specific report via a child tabular model.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Scripting FM Metadata Updates
This document demonstrates a simple script that can be used to update a Framework Manager model with information that can be obtained from a metadata repository.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Security in Framework Manager
This document outlines the possibilities for using security within a Framework Manager model
|
|
Articles |
|
01 Jan 2009 |
|
| |
Setting up Dimensional Information in Framework Manager
Discusses some basics when performing dimensional modeling with ReportNet
|
|
Articles |
|
01 Jan 2009 |
|
| |
Summary Level-to-Detail Level Planning
This document provides an example of using Cognos Planning to create models that solicit input at a summary level to ease the burden on contributors while still providing the level of detail required for management.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Transformer in Production
A guide to building cubes in Transformer. Particular attention is given to optimizing cube building and to the performance of the resulting cubes from a user perspective.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Year-to-Date in IBM Cognos 8 Metric Studio
How to mimic CMM 2.x Year-to-date rollups in Cognos 8 Metrics Studio.
|
|
Articles |
|
01 Jan 2009 |
|
| |
