We are trying to set up the product for evaluation and have some problems with part of the logic. We can't get a good treestructure to work for easy filtering. In short we have the following data :

AFFILIATE
| aid | owner | flag | name |
|-----+-------+------+--------|
| 1 | pa | t | john |
| 2 | pb | f | smith |
| 3 | pa | t | donald |

DATA
| did | pid | aid | year | month | day | amount |
|-----+-----+-----+------+-------+-----+--------|
| 1 | 1 | 1 | 2009 | 10 | 10 | 100 |
| 2 | 2 | 1 | 2009 | 10 | 11 | 50 |
| 3 | 3 | 2 | 2009 | 10 | 12 | 50 |

And we are trying to set up one Analyzer Report based on this. When setting up the filters for Affiliates we have a part of the xml looking like this :

<Dimension type="StandardDimension" foreignKey="aid" name="Affiliate">
<Hierarchy hasAll="true" primaryKey="aid">
<Table name="affiliates" schema="olap">
</Table>
<Level name="Affiliate Owner" column="owner" type="String" uniqueMembers="false" levelType="Regular" hideMemberI
f="Never">
</Level>
<Level name="Affiliate Name" column="name" type="String" uniqueMembers="true" levelType="Regular" hideMe
mberIf="Never">
</Level>
<Level name="Affiliate Flag" column="flag" type="Boolean" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>

The problem is that when selecting Affiliate Owner it looks good and we get a list consiting of pa, pb as we should. But selecting flags we get a list of t,f,t (one per affiliate). How do we set this up to only show the unique values instead of one per entry?

What we want is to be able to pick from owner or flag before choosing the name, and we want the list of names filtered by the selected values...

Regards,

Fredrik