Layout Issue Bex Analyzer

[Former Member]

Hello,

I would like Display Data in the following Format.

                      
                           Average Time 2014  |   Average Time Week 1 2015 | Average Time Week 2 2015 | ....             
   Workcenter

The Query has the time characteristic Week. Is there a way to do the drill down per week only on 2015 ?

I dont want to make 52 Selections..

BR Matthias

[Loed · Accepted solution]

Hi Matthias,

What do you mean by "do the drill down per week only"? What are the fields shown?

Regards,

Loed

[Former Member · Accepted solution]

This is what it should look like. Average value for total last year, average value for each week in current year.

[Loed · Accepted solution]

Hi Matthias,

Just create two (2) queries: 1 for VALUE 2014 and another 1 for your WEEKLY query..Just join the two (2) queries in ANALYZER, you must create a WORKBOOK..

Your two (2) queries will only differ in COLUMN field (in the keyfigures part) and they should have the same fields in ROW..After inserting the queries in your workbook, just HIDE some columns to achieve your desired layout..

Regards,

Loed

[cornelia_lezoch]

Hi Matthias,

could you build up a hierarchy, which has on the same level one node for 2014 and 52 nodes for 2015? then below the node for 2014 you put the 52 weeks from 2014.

In the query you limit the levels to be opend so that the weeks for 2014 are not shown.

regards

Cornelia