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 ??? ???
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 ??? ???
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.