Webi Document Filtering

[tip4you]

I have a universe created with many different date fields (dimensions) that a user can used for filtering the records on Webi document.

I also created a view that manipulates the current system date to return a set of start and stop dates; such as Today, Yesterday, 30 Days Ago, etc. This is so when I schedule the documents to run, the start/stop date can be automatically updated.

So far what I have found is that I have to create a seperate filter for each of Start/Stop dates types for each date dimension in my universe.

For example:
Date1 Between (@Select(Date Range\Today)) and @Select(Date Range\Today)
Date1 Between (@Select(Date Range\Yesterday)) and @Select(Date Range\Yesterday)
Date1 Between (@Select(Date Range\30 Days Ago)) and @Select(Date Range\Today)

Date2 Between (@Select(Date Range\Today)) and @Select(Date Range\Today)
Date2 Between (@Select(Date Range\Yesterday)) and @Select(Date Range\Yesterday)
Date2 Between (@Select(Date Range\30 Days Ago)) and @Select(Date Range\Today)


My question is this: As you can see from above, maintaining this course, I would have soo many filters it would in the end confuse my users who are going to be using this universe. Is there any way I can create a custom filter while creating the Webi document that takes a dimension and compares it to another dimension? Or maybe take a dimension and a partial filter and concatenate the two?

 

[skrandel]

Not with the current version of WebI. I'll be testing XIr2. Perhaps it's there.

Steve Krandel
Symantec

 

[tip4you]

That's what I was afraid of. During your testing of r2, will you please keep me updated as to whether or not this is possible? Thanks.

 

[skrandel]

Just saw a slide show that shows exactly what you're looking for in XI r2.

Steve Krandel
Symantec