Skip to Content
0
Former Member
Apr 13, 2010 at 05:34 PM

dynamic filter on last 13 months ?

44 Views

Hello,

i've read some threads about this but not sure they can fit my requirments

BO XI 3.1 SP2 FP 2.6 on SAP BW 7.01 SP5

my requirements:

-having an dynamic filter (condition) on my fiscal periods which filter on the last 13 full loaded monthes depending on the day we are (refreshing date)

- this filter must be optional (does not concern all reports built on the universe)

- no prompt : if i have a prompt , the report cannot be scheduled or can be schedule but prompt must be updated each month => no way

- if i use a Sap customer exit declared as an optional variable (for my requirement N°2), the variable gives the 13 fiscal period interval as default values and transfer default values to BO reports . We have seen that if we remove default values in BO prompt (optional prompt) default values stays in BEX queries and the report is filtered anyway...

I know how to do that when i built reports and universe on RDBMS database but in OLAP?

please advise

Many thanks in advance,