Skip to Content
0
Apr 13, 2014 at 09:18 AM

Creating a CR report over Bex with 2 structures

45 Views

Hi guys

I saw that there are some posts over this issue but I still couldn't find a solution to my case.

I have a Bex query with 2 structures

1 with period selection on the columns like Quarter 1, Quarter 2, Difference etc

2 simple structure with key figures.

When I see them in CR i get all key figures and an additional "Characteristic" for structure 1

I want my report to look like a crosstab as it looks in Bex, but I get a row for each element in structure 1 in stead of column

Quarter 1, Quarter 2, Difference

Sales QTY 100, 200, 100

And I get

Quarter 1

Sales QTY 100

Quarter 2

Sales QTY 200

Difference

Sales QTY 100

Please help

Shlomi