Filter at report level

building reports webintelligence
1

hi,
my report has 2 prompts.

  1. hotel code and
  2. transaction date.

rate code is a column in the report along with other columns.
now the requirement is to add a report level filter on rate code as follows.
[list]once the report is run and data is fecthed,
on top corner of the report, ‘Rate code’ sholud be displayed along with drop down with all rate codes available on the report. User should b able to filter on the required rate code.
please note this is not a propmt and it is applied after data is fectched from database. this is not quick filter also.[/list]

please let me know if this is possible to do it XI R2. if yes, how?

krkris :india: (BOB member since 2010-02-22)

2

Correct me if I am wrong, you want a report which hits a database, fetches the records (in microcube) and allows a user to change values for columns (objects) dynamically (through a drop-down menu) and display the records?

If you answer ‘Yes’ then this is not possible. Web Intelligence (and Desktop Intelligence too) was never meant for such kind of reporting. However, you may like to look at Business Objects Xcelsius if you want some good visualization on reports or dig into SDK and develop .Net or JAVA web application to do some sort of that work (not recommended though).

Rajat Sapru :us: (BOB member since 2008-08-28)

3

hi Rajat Sapru,

sequence is as follows.

  1. report is run , user enters hoyeli code and date prompts.
  2. data is fetched and displayed on the report. (rate code is a column in the report)
  3. now user can see the report.
  4. on top left corner there ‘rate code’ along with list available rate codes in the report.
  5. user can select the rate code and report gets filtered accordingly. no database is hit here. this action is similiar to applying quick filter on rate code column in report.

I want to know if step 4 and 5 are possible. if yes, how?

krkris :india: (BOB member since 2010-02-22)

4

How do you intend to have this column on the report? You can only use Objects defined in the Universe. You can use Prompts/Report Filters/Conditions to transform/filter out your results. Once BO engine hits the database, it will bring all the data in the microcube (interpret this conceptually as of now) which will get displayed as columns/rows. Now, you can use Report Variables to extract out information (from this cube).

You may like to read about Drill Filters, if it would serve your purpose.

Rajat Sapru :us: (BOB member since 2008-08-28)