I am trying to get a list of elements (using a mdx statement) that have the “incident count” measure in a cube above 0. When checking the mdx in the expression window, I get the correct result whereas in Canvas, the result is completely different.
How about if you save the above MDX into a Subset, and access the the subset instead via the tm1-subset attribute of the tm1-ui-element-list, does it give the elements as per Architect?
Saving the MDX into a subset worked. I got the correct result as per Architect.
For now I will use this work around if it is the only possibility to get the correct result. However, I would prefer to use the MDX in Canvas directly. Please let me know if you find a solution.
Can you please contact your Cubewise Local office, send them the relevant TM1 objects if possible, so they can help create and submit a ticket to support for this.