Hi There

Hope anyone could let me know if this is possible, and if give a hint
to how.

1. I have a fact table. In this I have f.x. ItemId, ItemGroupId and
DataAreaId.
The same ItemId could exist in different DataAreaId (that's is
different company accounts).
Item1,Group1,DataAreaWW
Item1,Group5,DataAreaWX
Item14,Group1,DataAreaWW
Item15,Group1,DataAreaWX
.....
2. I have several other dimensions fx. ItemGroupId, which also holds
the 'DataAreaId', and then I have the Dimension 'DataArea' which holds
every account in the database.
Dimension: ItemGroup
Group1,DataAreaWW
Group2,DataAreaWW
Group1,DataAreaWX
Group1,DataAreaWZ
Group12,DataAreaWW
.....

Dimension: DataArea
DataAreaYW
DataAreaWW
DataAreaWX
DataAreaZW

Know the question:
Is it possible to select from the dimension DataArea, and then use this
to filter out on every other dimension, so that only data with the
selected DataAreaId is visible?
Like, filtering 'DataAreaWW'
results in these possible values

Item1,Group1,DataAreaWW
Item14,Group1,DataAreaWW
Group1,DataAreaWW
Group2,DataAreaWW
Group12,DataAreaWW

It's in the cube not in a query.

Thanks /BR
Jan