1
votes

I have found this code below, works just fine in the variant of MDX that I'm using ( Cognos TM1 ), but I can't seem to understand how it works.

what value is name give to be able to be compared to the character "}"

[}Dimensions].CurrentMember.Name < "}" )}

This particular query filters out the names that start with "}" as these are control objects. e.g. }ABCD

1

1 Answers

0
votes

Buddy answered for me today;

That's a string comparison, so would use the ascii character order to compare the 2 strings.

It compares one character at a time, left to right -- it doesn't add them up.

The leftmost character is most significant, so for example:

BBB > AAA
BAA > ABB
AAB > AAA
ABA > AAC
BAA > ACC

The number of characters compared = the length of the shortest string, so in your example, it's just comparing the first character.