Hi all,
I have a dimension composed by the following elements:
A(2012)
B(2012)
C
D(2012)
E
F14
Create a subset with elements that end with(2012) is easy: I use FILTERBYPATTERN and a string with jolly character *(2012)*
But I would like create a subset composed by
C
E
F14
i.e. elements that DON'T end with (2012).
How can i perform this?
Thanks in advace
Regards
Filter dimension by difference
-
Rosanero4Ever
- Posts: 54
- Joined: Thu Oct 18, 2012 5:08 pm
- OLAP Product: Cognos TM1
- Version: 10.1.1
- Excel Version: 2010
- Location: Italy
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Filter dimension by difference
Lookup MDX Except function.