TM1 Forum

Strange case here...

I have a very simple dimension, in fact I deleted everything that is not related to the issue.
I try to filter out the elements containing 'A' for the text attribute WorkCenter. Pretty easy you would imagine.

If the grandparent has children, then the 2 elements that should be returned, cannot be formed as a tuple.
If I break the links such that the grandparent has no children, then the 2 elements are returned fine.

See pictures in the Word doc please, I could only add 3 pictures I think.

The element weights are all 1.
The TM1 service has been restarted many times.
The same setup of dimension and elements and attribute works fine in a separate TM1 model.
Yet in this TM1 model, there is no dimension called 'WorkCenter' or other attribute in the model called 'WorkCenter'.
The dimension SCH_Work_Center is used only in 1 application cube and 1 element attributes cube and in its own element security cube.

Anyone has an idea ?

HI Wim,
I created the dim per the doc and added a measure called A for "good measure". Returns the two elements as you would have expected. This is on 10.2.2 FP4. Not sure that it helps you any as no errors.
The difference, besides versions, may be that I do not have the dimension associated with any cubes, or any other dimensions with an alias containing a text attribute with values of "A" (I did add an attribute to an existing dimension to test this case too-no issues elements returned as expected).
Have you tried saving the dim with a new name to test if this happens in any dim?

Thank you very much for testing George.
In a new dimension it works fine.