on 04-22-2010 5:12 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.