New post
Question
· Mar 25

Distinct strings in MDX

#Analytics #Analyzer #MDX #InterSystems IRIS #InterSystems IRIS BI (DeepSee)

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
Discussion (2)2
Log in or sign up to continue
Sam Duncan · Mar 25

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).

1 0