Business Objects WebI: Create a report with Time Interval as a pompt.

I was studying BO and suddenly something came in my mind. What if somebody asks me to develop a report where in user can select the reporting interval on the fly.
i.e. If user selects Interval as Year then report should display year wise data etc.

Here is the trick to achieve this. I am using efashion to show how to achive it.

1. Create a Object Interval in “Time Period” class of efashion universe. use CASE statement to select the interval as shown below

CASE @Prompt(‘Select Interval’,A,{‘Year’,'Quarter’,'Month’,'Week’},mono,free)
WHEN ‘Year’ Then @Select(Time periodYear)
When ‘Month’ then to_char(@Select(Time periodMonth))
When ‘Week’ then to_char(@Select(Time periodWeek))
WHEN ‘Quarter’ then @Select(Time periodQuarter)
END

2. Export the Universe.

3. Now create new webI document and add Interval and Sales revenue into query pane.

4. Run the query. It will prompt to choose interval. choose year to see year wise data, month to see month wise data.

I hope this is helpful.

Subscribe to Email to receive all the FREE updates and Business Objects Interview Questions and Answers FREE!!

Related posts:

1. Using Data Restriction Techniques in Business Objects Universe
2. Hierarchies in Business Objects Universe
3. Using @Functions with Universe Objects