MCSI report with two dimension

[Former Member]

Hello

In MCSI, it is possible to get sales report according to a group of criterias and to drill down according to an other group of criterias. However it would be also convenient to to get a sales report with two dimensions instead of drilling down in order to analyze with Excel Pivot Table. Is there a way to create a specific structure or something to get it done?

Thanks

sb

[Former Member · Accepted solution]

In MCSI you have use the Key Figure Matrix tool to display a 2-dimensional grid for on e key figure.

From within the standard analysis, use the menu path View --> Key Figure Matrix and follow the prompts.

(This functionality is NOT generally available for the SAP delivered info structures - but anything in MCSI should work.)

[Former Member · Accepted solution]

Great thanks!

However the two dimension that can be used do come from the first drill down criterias list. However it seems not possible to select a dimension from the second lists with the matrix function. Is there a way to stil get it from the second list as well ?

thanks

sb

Edited by: STANISLAS BRESIN on May 23, 2011 10:38 AM