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?
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?