Agregation of measure dependent of dimension

I have a measure in my universe which holds revenue. Revenue however is expressed in the database in different exchange rate’s per customer (don’t ask my why I didn’t model the database). So I set the default aggregation method to none. It is, however possible to aggregate per customer. Is there a way of specifying this in the universe?

hans


Listserv Archives (BOB member since 2002-06-25)

Hans, you wrote:

I have a measure in my universe which holds revenue. Revenue
however is
expressed in the database in different exchange rate’s per
customer …
It is, however possible to aggregate per customer. Is there a way of specifying this in the universe?

May be I’m missing something, but it seems straightforward: Create the object revenue as:
sum(fact-table.number of sales*customer dependend.exchange rate)

The joins between the tables (structure) should assure that a) the customer to whom the sales was made is found b) the exchange rate for the currency that applies is taken.

Because of the nature of SQL the multiplication will take place at the lowest level (identical to aggregation none). The sum will then take care of aggregating it up to the dimensions you want it by. The result is a normal measure object revenue that you aggregate using sum.

Hope this helps,
Marianne Wagt-van Loenen
IDETA
The Netherlands


Listserv Archives (BOB member since 2002-06-25)