COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: jj on 29 Mar 2010 06:40:24 AM

Title: Mapping two different time dimensions between two cubes
Post by: jj on 29 Mar 2010 06:40:24 AM
Hi Everyone,

I'm very new to TM1 and have a simple question.

Source cube contains a months dimension as follows: Jan-10, Feb-10, Mar-10 etc
Target cube contains a month dimension as Jan, Feb, Mar etc

I'm trying to match up the elements in both dimensions between the cubes in a rule when moving data. My initial thought was to add an alias attribute to the months dimension in the source cube. The alias would be Jan, Feb, Mar etc.

How do I match an alias in a source dimension to the elements of the target dimension in a rule? Is there a function to do this?

Also, am i tackling this the right way?

Thank you!
Title: Re: Mapping two different time dimensions between two cubes
Post by: MichelZ on 29 Mar 2010 07:02:40 AM
Hi,

Do all cubes using the 'Jan', 'Feb', etc. time dimension contain one year of data (all 2010)?
If so, you could use an alias.
Another option is to use the SubSt() function to only select the first three characters of the elementname: SubSt(!dimname, 1, 3).

Michel
Title: Re: Mapping two different time dimensions between two cubes
Post by: jj on 29 Mar 2010 07:10:04 AM
Yes, there is just one year of data in the time dim in the source cube: Jan -Dec. What would be the syntax to use to match up an alias (Jan, Feb....) in the source dim to the elements in the target dim (Jan, Feb....)?

Thank you!
Title: Re: Mapping two different time dimensions between two cubes
Post by: Matya on 02 Apr 2010 09:39:12 AM
Hi!

You should use the ATTRS function.

Example:

[Target element]=DB('Source cube',!Dimension1,!Dimension2,ATTRS('Dimension3','Dimension element','Alias'));

KR,
Matya
Title: Re: Mapping two different time dimensions between two cubes
Post by: jj on 03 Apr 2010 08:36:19 AM
Thanks everyone for your help. The ATTRS function worked perfectly!