 |
|
|
|
|
|
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 |
|
| |
Conditional Statements
This document covers best practices in creating Conditional Statements in Cognos Planning Analyst.
|
|
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 |
|
| |
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 |
|
| |
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 |
|
| |
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 |
|
| |
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 |
|
| |
ReportNet usage with Oracle Materialized Views
Describes how to model and create reports against Oracle Materialized Views
|
|
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 |
|
| |
