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,