Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have this model and I need to compare the amounts of object 1 vs Rubro2 when they are equal.
This is a small example of my model, I could establish a link between Vend and heading, but in my original model more complex and need to do it this way.
Regards.
Ecco il miol esempio, guarda "MY TABLE"
Is there any problem if you take this table in single table like with join of left join for comparing the fields.
Hi
When I need to do this type of comparison, I concatenate the sets into a single fact table with a source field to indicate the original data source. It is then very easy to compare. So the load would be like:
Data:
LOAD *,
'Tbl1' As Source
FROM Tbl1;
Concatenate
LOAD *,
'Tbl2' As Source
FROM Tbl2;
Then to compare, create a straight or pivot table with Vend as the dimension and for the expressions (to compare field Rubro):
Tbl1 =Sum({<Source = {'Tbl1'}>} Rubro)
Tbl2 =Sum({<Source = {'Tbl2'}>} Rubro)
Diff =Column(1) - Column(2)
HTH
Jonathan
Thanks for responding, but would not it be done with Set Analysis directly?
Regards.