In my universe I have a 1:n-relationship: SALES 1-n SALES_ITEMS I created a measures SALES_AMOUNT from table SALES and a measure SALES_ITEM_VALUE from SALES_ITEMS. Of course I get wrong results for SALES_AMOUNT, because it get multiplied by the number of rows in SALES_ITEMS. I thought I can solve…

1:n relationship and Multiple sql statements for each measur

system March 13, 2013, 1:59pm 2

Hi,

What you have is called a fan trap. It needs to be solved accordingly. Here is how:

Marek Chladny (BOB member since 2003-11-27)