If you are unable to create a new account, please email support@bspsoftware.com

 

Setting up Time Dimension I Framwork Manager for Cognos8

Started by coledog, 12 Jun 2006 07:16:17 AM

Previous topic - Next topic

coledog

I need help in setting Time Dimension in Framwork Manager I worked with transformer for years and I have no problem there. But this is new to me. Some examples would help. But our time dimensions gos like this

year
month
day

current day
current Month
year to date

That will work for now.

I know this may sound simple but I do need the help getting started ??? ???

coledog

Quote from: coledog on 12 Jun 2006 07:16:17 AM

There has to be someone that can answer this question

I need help in setting Time Dimension in Framwork Manager I worked with transformer for years and I have no problem there. But this is new to me. Some examples would help. But our time dimensions gos like this

year
month
day

current day
current Month
year to date

That will work for now.

I know this may sound simple but I do need the help getting started ??? ???

Arpitagrawal9

Description:
This document describes how to create a Time Dimension in Framework Manager which is similar to a Time Dimension created in Powerplay Transformer.

Steps:

Right-click on the Namespace and choose Create->Regular Dimension.
From Available Items drag the date column and drop it under Hierarchies.
Click the ellipsis in Source field to open Calculation Definition windows.
Change the name of the calculation to Year.
Use 'cast' and 'extract' functions to extract the years from the date column and convert it to character string, e.g.:
cast(extract ( year, [].[].[] ) , char(8))
Back in the Dimension Definition windows, click the ellipsis in the Role field.
Assign _businessKey and _memberCaption roles.
Under Hierarchies, Add Levels for Month and Day.
Repeat the steps 3-7 for the Month and Day using expressions:
cast(extract ( month, [].[].[] ) , char(8))
cast(extract ( day, [].[].[] ) , char(8))
Note:
'cast' function has to be used to convert a numeric field to a string as _memberCaption Role cannot be numeric.