hi, expert:
In infocube, there are two infoobjects 0calmonth, 0employee and one keyfigure zsaleqty, I want to display data resutl like this:
2007.01 2007.02 2007.03 .......
last_month_qty this_month_qty last_month_qty this_month_qty last_qty this nonth_qty ......
sales_manager1 100 150 150 120 120 210 ......
sales_manager2 80 100 100 110 110 90 ......
The question is, I don't want to change my infocube, for example, add a keyfigrue and in the transformation calculate the last month quantity; or add a virtual keyfigure. Did it have other way to display the result by using common query design skill?
Thanks.
Edited by: zhu zhu on May 12, 2008 3:26 PM