Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Webi Document Filtering

Status
Not open for further replies.

tip4you

Programmer
Aug 12, 2005
5
US
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?
 
Not with the current version of WebI. I'll be testing XIr2. Perhaps it's there.

Steve Krandel
Symantec
 
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.
 
Just saw a slide show that shows exactly what you're looking for in XI r2.

Steve Krandel
Symantec
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top