19 Replies Latest reply: Feb 26, 2013 11:03 AM by Georg Jenichl RSS

Scheduling WebI reports for Dynamic Date Ranges

Vamsi Krishna
Currently Being Moderated

Hello Everyone,

 

Our Env is BOBJ XI 3.1 SP2 FP2.5 integrated with SAP NW  BW 7.02 EPH1

 

We are trying to schedule few WebI reports which can be used on ad-hoc basis as well. Some reports need to get data from starting of the month to today (like MTD) and few are with dynamic date ranges.

 

In case of relational universes i used to do Magic Date as mentioned here :  http://www.dagira.com/2008/07/21/using-a-magic-date-value-in-prompts

 

But for OLAP Universes i have written a MDX filter prompt as :

 

<FILTER KEY= "@Select(Debit Memo Date\Debit Memo Date LOV)">

<CONDITION OPERATORCONDITION= "Between">

      

<CONSTANT CAPTION= "IIF (@Prompt('Enter\Select DM Start Date: ','D','First day of Current Month\First day of Current Month',mono,free,not_persistent,{'First Day of Month'},,User:0)='First Day of Month','First day of Current Month\First day of Current Month',@Prompt('Enter\Select DM Start Date: ','D','First day of Current Month\First day of Current Month',mono,free,not_persistent,{'First Day of Month'},,User:0))"/>

 

<CONSTANT CAPTION= "IIF (@Prompt('Enter\Select DM End Date: ','D','Date2\Today',mono,free,not_persistent,{'Today'},,User:0) > '1/1/2100 12:00:00 AM',''1/1/2010 12:00:00 AM'',(@Prompt('Enter\Select DM End Date: ','D','Date2\Today',mono,free,not_persistent,{'Today'},,User:0))"/>

 

</CONDITION>

</FILTER>

 

We are getting MDX erros because IIF can only return numeric values. So are there any other approaches for dynamically scheduling the reports or can the above MDX prompt be modified to make it work ?

 

- Vamsi Ch

Actions