Andrey Grigorev


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




Re: Question/remark about "Referenced relation"

Deepak Puri


Hi Andrey,

The issue may be that "Currency", rather than "CurrencyKey", is configured as the key attribute; but the "Currency" dimension relates to "Organization" at the "CurrencyKey" attribute. If your Currency dimension table is DimCurrency in Adventure Works DW, take a look at the "Source Currency" dimension - CurrencyKey is dsignated as PK, and is the source key column for the key attribute: "Source Currency Code".







Re: Question/remark about "Referenced relation"

Andrey Grigorev

Hello, Deepak.

Thanks for the response. Actually, that was my idea too, but I was not really sure. But then another question arises: is it possible to build a relation, that will show desired distribution of the mesure over currencies with "Currency" hierachy Could I use m:n-relation

And I didn't find any DimSourceCurrency table. :-( Should I build this dimension by myself

Regards,

Andrey.