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
Hi,
please go through ibm documentation
dimensional concepts(dmr) in framework manager.
Regards
saumil287