Author Topic: Setting up Time Dimension I Framwork Manager for Cognos8  (Read 5867 times)

Offline coledog

  • Full Member
  • ***
  • Join Date: Jun 2006
  • Posts: 32
  • Forum Citizenship: +0/-2
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 ??? ???

Offline coledog

  • Full Member
  • ***
  • Join Date: Jun 2006
  • Posts: 32
  • Forum Citizenship: +0/-2
Re: Setting up Time Dimension I Framwork Manager for Cognos8
« Reply #1 on: 12 Jun 2006 10:10:33 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 ??? ???

Offline Arpit Agrawal

  • Arpit Agrawal
  • Community Leader
  • *****
  • Join Date: Jun 2011
  • Posts: 92
  • Forum Citizenship: +5/-0
  • Have no fear of perfection--you'll never reach it.
    • Infocepts
Re: Setting up Time Dimension I Framwork Manager for Cognos8
« Reply #2 on: 14 Jun 2011 06:52:15 am »
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.
Thanks and Best regards,
------------------------------------------------------------
Arpit Agrawal | InfoCepts | www.infocepts.com
------------------------------------------------------------

 


       
Twittear