OLAP universe filter with pattern matching.

[Former Member]

Hi,

I tried to create both a qaaws and a webi report which contained a filter with pattern matching on an olap universe . When I ran this it took too long to be usable. I found note 1500666 which says that pattern matching is not supported in MDX and to use BEX query variables instead.

I have created a bex query with a variable which has "Variable Represents" set to "Selection Option". I can run this query and using the search option I can do a pattern match search. I have built a universe based on this query but the filter that gets created automatically in the universe uses a "Between" operator.

Does anyone know if it is possible to change the definition of the filter in the universe so that it does a pattern match search and if so how?

The end result is that I would like to be able to do a pattern match search on the text description of a BW employee object.

Thanks

Quentin.

[Former Member]

It would be better if you post the Filter definition here...

And why don't you do Pattern matching at BO query panel level??

Where you can find Matches pattern operator to do same stuff.

Thank You!!