How create filter in olap universe with MDX LIKE Function

[Former Member]

Hi all

I need to create a filter in a olap universe with the LIKE MDX function.

Problem:

There is a dimension with account numbers whit 10 digits like this: 5683492703 and i need to create a filter whit all account numbers whit the number 7 in the sixth position in a olap universe.

How to do this?

Thanks all

[arijit_das · Accepted solution]

Try like this :

<FILTER KEY="[Level Object Definition]">
	<CONDITION OPERATORCONDITION="Like">
		<CONSTANT CAPTION="_____7*"/>
	</CONDITION>
</FILTER>

Not sure if it is _ or ? to represent a single character. Try ? in place of _ if the above code doesn't work.

Regards

[Former Member · Accepted solution]

Thanks pumpactionshotgun that is the answer i needed. And the operator to represent a single character is "?". THANKS

[Former Member]

Hi Juan,

Hi,

Here is the list of supported operators for OLAP universe filters:

<li>Equal

<li>NotEqual

<li>Greater

<li>GreaterOrEqual

<li>Less

<li>LessOrEqual

<li>Between

<li>NotBetween

<li>InList

<li>NotInList

<li>Like

<li>NotLike

Regards

Didier