Display of properties when dimension contains multiple members with the same name

[Miljen Stankovic]

Hi,

Let's say I have dimesion table with the following data (two dimension members with the same name, but different ID and Property values):

ID Name Property
1 X A
2 X B

I've noticed two things:

1) If I choose to show properties in tooltip, but not in report and if I am connected from Excel directly to SQL Server Analysis Services, Excel displays X twice and when I hover over X it dislays A for the property on first dimension member, and B for the other, as it should. On the other hand if I connect to Mondrian/Pentaho using XMLA Connect, Excel displays X twice but it displays A for the property on both dimension members, which is NOT OK. Is it a bug in XMLA Connect or something else?

2) If I choose to show properties in report and if I am connected from Excel directly to SQL Server Analysis Services, Excel displays X twice and then A in the cell next to first dim. member and B next to second member. On the other hand if I connect to Mondrian/Pentaho using XMLA Connect, Excel displays X ONLY for the first dim. member but blank for the other. At the same time, properties A and B are displayed OK in the adjacent cells. Is it by design or a bug?

[hassoalbert]

Add extra attributes to each member to provide more context. These attributes could include unique identifiers, descriptions, or other relevant information Auto Huren Dubai that helps differentiate between members with the same name.

[phednourtensua]

When dealing with properties in data structures or programming languages where a dimension contains multiple members with the same name, it can lead to confusion and ambiguity in accessing or manipulating these members rena monrovia when you transport something by car .... This issue typically arises in contexts like multidimensional arrays, databases, or object-oriented programming where names must be unique to ensure accurate identification and operation.