Archived discussions are read-only. Learn more about SAP Q&A

Scheduling WebI reports for Dynamic Date Ranges

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

Not what you were looking for? View more on this topic or Ask a question