OLAP filter with automatic last year calculation

[lieven_vanherpe2]

Hi,

We're working with BO XI 3.1 on SAP BW 7.01.

We want to create WebI reports where we want to show data from specific periods compared to the same periods from the year before.

Therefore we want to create the filter within the universe (not in BEx nor with user EXIT because we will need multiple of those filters in the same report with an OR-operator) on the report level, not on each key figure due to the large amount of key figures.

E.g. we want to see 3 columns on our report:

- Period

- Quantity

- Value

When selecting periods 01.2011, 02.2011 and 03.2011 in the filter, I want to see not only the Quantity and Value for these 3 periods, but also automatically for periods 01.2010, 02.2010 and 03.2010.

We don't want the user to have an additional prompt for the selection of the last year periods due to possible mistakes.

What should be the syntax of the filter.

We're able to create the filter for the current periods, but we don't know how to automatic calculate the last year periods.

Here's our existing filter:

<FILTER KEY="@Select(Calender month\L01 Calender month)"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="@Prompt('Enter Period','A','Calender month\L01 Calender month',Mono,Constrained,Not_Persistent)"></CONSTANT></CONDITION></FILTER>

Thanks

[Former Member · Accepted solution]

It can be done only when you have 3 different prompts for each period.

In that case, we can apply conditions and required. If you have only one prompt for multiple periods, you can't do this.