Creating new dimensions based on existing dimensions

[fml55555]

Hi Gurus,

***Warning-This is the first time I am trying to make changes in FM so this could be the ultimate stupid question******

I am trying to create a dimension in FM which has the following structure

Year
Month
Day

I existing structure has been imported from SAP BW cube. In the existing structure there is a dimension for Year with the structure:

Year(dimension)
Year(Hierarchy)
Year(All Level)
Attributes
Year(Level)
Attributes

Members look like : 2001, 2002...etc

There is a Month dimension with the following structure

month(dimension)
month(Hierarchy)
month(All Level)
Attributes
month(Level)
Attributes

Members look like : 01/2001,02/2002 etc

I want the Year level in the new dimension to be the same as the year level in the Year dimension, Month to be just a collection of months

I.e.

2004
01
02
03
..
12

2005
01
02
03
04
..
12

2014

How can this be achieved

Thanks

[saumil287]

Hi,
please go through ibm documentation
dimensional concepts(dmr) in framework manager.





Regards
saumil287