Filter Dates based on User Response

building reports webintelligence
1

This is a very basic question, and I do not know how to do it. Will appreciate your quick response.

Background: Using Web Intelligence XI 3.1 in Windows environment. Report pulls data against “Activity” Universe that comes in built with BOXI when Auditing is enabled in the servers.

Scenerio:
There is a dimension named ‘Action YYYY-MM-DD’
I need to create a prompt in WebI that will give options for selecting -

  1. Yesterday
  2. Last Week
  3. Last Month

Based on one of the above 3 selection data will be returned after filtering against ‘Action YYYY-MM-DD’.

Question:
How do I achieve this?

Note: I have 3 seperate filters created in universe that compares ‘Action YYYY-MM-DD’ and returns data accordingly. Is there any way I can use them in WebI report based on user response?

Thanks in advance
Aurobindo

AurobindoSaha :india: (BOB member since 2009-10-13)

2

Welcome to BOB.

Please do a search for prompts.

Rakesh_K :india: (BOB member since 2007-12-11)

3

Good Day AurobindoSaha,

you can achieve it without even having a prompt. in report level you can try using RelativeDate function combined with If statements.

Kindly tell me if im missing something

Regards,

John Vincent

jvmauricio :philippines: (BOB member since 2009-08-03)