Distinct strings in MDX
Hi!
I have question about MDX functionality in context of IRIS Analytics.
How does IRIS MDX distinct selection works? Is there any restruqtion when analyzing strings? Like special symbols or length?
Here is an example
I have this data:
6 rows and 2 of them unique
Then we create data cube based on this model and examine it with Analyzer
Detailed listing
6 rows an ONE unique string. Which is obviously not true.
This happed only with string with symbols in it
My task is to get the right amount of unique strings
Product version: IRIS 2024.3
Hi Dmitrij,
Member keys must be unique within the first 113 characters, as documented here. It looks to me like the two strings in your table are the same for the first 117 characters, and I think this is why only one member is being inserted when you build your cube.
If you have long strings in your table that may not be unique within 113 characters, and want to create a member for each one, I wonder about using a hash of the string as the member key, creating a property with the text of the string, and using that property as the member name. However, you should avoid this if it would create an excessively large number of members (or if the member names would be so long that it wouldn't be practical to display them in pivots or dashboards).
As far as I understand from your answer, I have no choice but to apply some hacks to my data. This is unfortunate. I was thinking about using a hash too. I think I will do that.