its a normal behavior, if you tell AS to use 2 times the same client, AS
will use 2 times the same client data in the cube!

sperate your dimension into 2 dimensions
the first is the statistics the second is the client dimension

another option is to create a composite key like StatisticID + '-' +
ClientID and use this key at the lowest level of the dimension.
in this case the combination stat / client will be unique
you have to create the same formula in your fact table to be able to link
the fact to the dimension.


"Olaia Vázquez" <olaia (AT) discussions (DOT) microsoft.com> wrote

oohhh ok.

create 2 hierarchies in the "Client dimension"
the first one will be "Clients by country" the second "Clients by Sector"
to do this, create a view on the client table and create the second
hierarchy using this table (a simple select * from ... is enough)

or you can create 1 dimension based on the most requested hierarchy "Client
by country", add a property at the client level "Sector" and create a
virtual dimension based on this property "Sectors" (final: 2 dimensions, 1
for the clients/country the second is the sectors)


"Olaia Vázquez" <olaia (AT) discussions (DOT) microsoft.com> wrote