Duplicate attribute values for UI

I have a cube working where the denormalized dimension has duplicate values for an attribute in the dimension table.  Users using reporting services to drag and drop the data find it annoying that if you want to filter the values that you have to click every row with the same attribute value if you want to see the data.  Even in the browser I see this behavior where if I want to filter by an attribute I have to pick every row for the same attribute value.  Is there any way to be able to see a distinct list of attribute values?

Here's an example:

Table1

Attribute1

Attribute 2

Attribute 3

Attribute 4

Levels:

Attribute1-->Attribute2-->Attribute3-->Attribute4

Attribute relationships

Attribute1--Attribute2 and 3.  Attribute2 -->Attribute4

In the browser I see multiple values for Attribute1.

If I understand you correctly, it seems like you want to use attributes as separate selectable values, independent of any relationship, as well as wanting to use them in hierarchies as well.

Realize that once you've added them to a hierarchy, they work within that structure and function slightly differently depending on the relationshiops you've created between parent and child...  you don't necessarily want the user to select a middle-tier hierarchy member as an attribute - you should hide them from view and bring only those attributes that should be independently selectable for selection.

for example in visual studio when editing a dimension:

Data source view =

Attribute1

Attribute 2

Attribute 3

Attribute 4

Attributes =

H_Attribute1 (attribute hierarchy visible = false)

H_Attribute 2 (attribute hierarchy visible = false)

H_Attribute 3 (attribute hierarchy visible = false)

H_Attribute 4 (attribute hierarchy visible = false)

Attribute1

Attribute 2

Attribute 3

Attribute 4

Hierarchies

Hierarchy 1:  H_attribute1->H_attribute2->H_attribute3->H_attribute4 (feel free to rename them in the hierarchy so they are readable)

Alternatively, if it's just a matter of presentation - creat a  perspective and hide the duplicate values (although, i doubt that this is the solution).

Hope this helps!

Fahim.

Ah, ok.  I'm new to analysis services but I thought it was something simple.  Thanks so much Fahim.