Hello everybody,
at the present I'm playing with "Adventure Works DW" database. I decided to build a cube using FactFinance table. Wizard created several dimensions for me, and one of them was "Organization". I decided to add new dimension "Currency" using a referenced relation DimOrganization.CurrencyKey ->DimCurrency.CurrencyKey.
On the tab "Dimension Usage" I created quite an ordinary referenced relationship using "Organization" as an intermediate dimension. My "Currency" dimension has 3 attributes - "Currency" (with PK sign), "Currency Key" and "Currency Name". Attributes "Currency Key" and "Currency Name" are in relation to the "Currency". So, when I try to view my cube in a browser, it shows the distribution of the measure "Amount" over currencies ONLY when I put "Currency key" attribute in the rows' area. If I put "Currency" or "Currency name", the total value of the measure is shown for all currencies.
What did I do wrong with my relations Actually, I would like to hide my "Currency key" from the metadata pane, and configure everything in such a way, that placing "Currency" or "Currency name" in a browser pane would give the desired distribution. It is possible
Regards and thanks in advance,
Andrey