Returns "Invalid MDX expression" in PAW. The Reference Guide does not list LEN as being a supported function so there is that. Has anyone else has seen this issue and, if so, are there workarounds?
You could fill up an attribute with the length of the string, probably with TI but a rule is possible too. After that you can query on the attribute. I haven’t used it in Workspace until now.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014 https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
2. If you are looking to filter on an alias you may need to make a text attribute to fill in the alias values that are blank. Its possible for alias values that have not been set to be blank in the }ElementAttributes control cube for that dimension. If that is the case for any elements then filtering on them by length becomes an issue since they are evaluated as 0 length.
3. If you want to filter by an attribute you can also shortcut that with TM1 (Assuming you don't have name conflicts with elements)
Wim Gielis wrote: ↑Wed Mar 20, 2019 7:31 pm
Hello,
You could fill up an attribute with the length of the string, probably with TI but a rule is possible too. After that you can query on the attribute. I haven’t used it in Workspace until now.
But don't forget that member properties are explicitly strings and TM1's MDX implementation doesn't allow type recasting. So if you want to treat the value as numeric then you need to query the ElementAttributes cube not get the member property.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
2. If you are looking to filter on an alias you may need to make a text attribute to fill in the alias values that are blank. Its possible for alias values that have not been set to be blank in the }ElementAttributes control cube for that dimension. If that is the case for any elements then filtering on them by length becomes an issue since they are evaluated as 0 length.
3. If you want to filter by an attribute you can also shortcut that with TM1 (Assuming you don't have name conflicts with elements)