Mapping two different time dimensions between two cubes

[jj]

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!

[MichelZ]

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

[jj]

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!

[Matya]

Hi!

You should use the ATTRS function.

Example:

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

KR,
Matya

[jj]

Thanks everyone for your help. The ATTRS function worked perfectly!