we are in an IS-Retail environment. hence, we work with generic materials with variants. in other words, our material master contains a generic number for a particular product (for example, generic material number 81271) and the variants for the different color and size combination (for example, material variant number 81271001 for color blue and size small, 81271002 for color blue and size medium, etc.)
now in our BW, we intend to come up with analysis that would capture the colors and the sizes and separate as navigational attribute or more preferably as info-objects. is there a standard master data extractor that would allow us to do this, such that that info-obect 0MATERIAL would have attributes for color and size and separate fields, apart from the number of the material variant?