Month Modelled as a Key Figure
I have a requirement. I have a char Production Month which is a char and holds value like 09.2012 for example. I need to create a Key Figure for this Production Month so that I can map it from a Production date .This is needed as my report needs to have a maximum month against the maximum production date from the set of records.I have modelled Production date a as a KF and have mapped the Production date (char) to my Production date(KF). But how do I map the production Month(char) in cube to a Z KF created to hold month.
plant prodmonth prod date prod qty
01 02.2012 12.02.2012 57
02 03.2014 15.03.2014 34