KF in row and column

[Former Member]

Hi,

There is a scenario where, infoprovider has the following Info objects:

Characteristic Info object 'Type' has the values: A, B.

'A' represents Plan and 'B' represents Actuals.

And there are Key Figures(KF) 'Quantity1' and 'Quantity2'.

Now, I need to display a report with the below Format:

Plan

Actual

Variance

-

---

-|-----|

---

|--

---

Quantity1 | | | |

-

---

|------ -|--

---

|

---

|--

---

Quantity 2 | | | |

-

---

Note: Variance = Plan - Actual.

(KF's in rows and Variance of Plan and Actual in column)

Is this report possible in BI, If so, please let me know as KF is required to be available in Rows and Columns as well.

Thanks in advance!!

Edited by: haripriya a on Jun 16, 2011 4:38 PM

[former_member182470]

Hi,

You can create your query in normal way, say Chars in rows and KFs in columns.

In the BEx analyzer, you can swap the axes. This way you can achieve your requirement.

Hope this helps....

Regards,

Suman

[Former Member]

Hi Priya,

you can have keyfigures in rows .

you can derive the things which you have explained take a structure in rows and add the KF which r needed.

take the Actual and planed in columns.

Thanks

Naresh

[Former Member]

hi haripriya,

KF can be available either in rows or columns, but you can't have it in both places. Likewise for characteristices.

thanks.

Wond