Tm1 REST api - filter all subset except one dynamic subset
Posted: Tue Sep 11, 2018 8:30 am
Hello everyone,
Is it possible to filter all the subsets from dimension except one subet.
DIM
- subset1
- subset2
- excludesubset_username #It a dynamic subset, Username will be created dynamically.
above wil exclude subset when I give with full subset name.
but i want something like,
because username will be appended dynamically.
Kindly post ur suggestion.
Is it possible to filter all the subsets from dimension except one subet.
DIM
- subset1
- subset2
- excludesubset_username #It a dynamic subset, Username will be created dynamically.
Code: Select all
http://host:8001/api/v1/Dimensions('DIMName')/Hierarchies('DIMname')/Subsets?$filter=Name ne 'excludeSubset__User1'
but i want something like,
Code: Select all
http://host:8001/api/v1/Dimensions('DIMName')/Hierarchies('DIMname')/Subsets?$filter=Name ne 'excludeSubset__*'
Kindly post ur suggestion.