EasyManuals Logo

IBM Cognos User Manual

IBM Cognos
411 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #92 background image
Procedure
1. Open the property sheet for the time dimension whose absolute range you
want to change and click the Time tab.
2. In the Earliest date and Latest date boxes, type the dates that represent the
lower and upper boundaries of the range respectively and click OK.
3. On the dimension line of the Dimension Map, click the time dimension and,
from the Run menu, click Generate Date Categories.
By default, the Range box shows the date settings you specified in step 2.
However, you can change these if you want to generate a different range of
date categories.
4. Open the Categories diagram and check for an Invalid Dates category. If this is
present, repeat steps 1 to 3, making any necessary corrections.
Set up a Custom Time Dimension
Instead of using standard date levels, with their built-in definitions and functions
for calendar and lunar time periods, you can create a time dimension that tracks
measures over custom time periods, such as work shifts and hours within shifts, or
project phases and timed sub-phases.
For example, suppose you need to track the temperatures of various pieces of
equipment in an electric generating station. The raw data is captured every two
hours, and stored in a database. The first few rows are as follows:
Shift Hour Plant Equipment Temperature
01 0200 01-6EL Primary Boiler 235
01 0400 01-6EL Primary Boiler 237
01 0600 01-6EL Primary Boiler 233
01 0800 01-6EL Primary Boiler 235
02 1000 01-6EL Primary Boiler 228
02 1200 01-6EL Primary Boiler 232
02 1400 01-6EL Primary Boiler 231
02 1600 01-6EL Primary Boiler 233
You design your model to track the data at the Hour and Shift levels, where each
work day consists of three 8-hour shifts. From this model, you create a PowerCube
that is incrementally updated every eight hours. This provides your maintenance
crews with the critical readings they need in a timely manner.
After you have created a custom time dimension, you can set up relative time
categories for the periods in that dimension. For example, if your model is
designed to show the number of patients monitored during each hour of a nursing
shift, it can also show the number monitored in the same hour of the previous
shift. For more information, see “Setting Up Relative Time Categories” on page 79.
Procedure
1. Click anywhere on the Dimension Map and, from the Edit menu, click Insert
Dimension to add a new dimension.
2. In the Dimension name box, type a meaningful name for the new dimension.
3. In the Dimension type box, select the Time option.
4. Click the Time tab.
78 IBM Cognos Transformer Version 10.1.1: User Guide

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM Cognos and is the answer not in the manual?

IBM Cognos Specifications

General IconGeneral
DeveloperIBM
Data Sourceflat files
Operating SystemMicrosoft Windows
LicenseCommercial
Input SourcesSQL databases, Excel, CSV
PlatformMicrosoft Windows