Skip to Content
0
Oct 27, 2011 at 11:26 AM

BEx Query Design:Restricted keyfigure with 2 intervallvariables on 0FISCPER

578 Views

Hi colleagues,

I do have the following question:

Scenario:

- calculated keyfigure

- 0FISCPER with intervall variable (input-ready) 1: from-to period,

- 0FISCPER with intervall variable (not input-ready) 2: exclude from selection, from current period-1 to current periode -12

example:

user selects period from 06.2011 to 012.2011 (variable 1)

current period is 010.2011

in the result columns only the interval from 010.2011 to 012.2011 shall be shown (because of exclusion variable 2)

user selection period: 6 7 8 9 10 11 12

current period: 10

Result in Query: 6 7 8 9 10 11 12

columns to be shown because of variable 2 (exclusion): 10 11 12

Question:

Why does the exclusion not work? Even changing the order in the restricted key figure, 1st exclusion 2nd user intervall does not show the period 10 11 12 ...

Thanks for any hint!

Best regards,

Heiko