Hello together,
I want to use a Calculation View for a BW data modeling request:
I have two tables (A and B) with the same data structure.
Table A has to be joined with B (LEFT OUTER JOIN) and if an entry in B exist a lot of characteristics should be used from B instead of A for the projection.
With SQL I would do this with COALESCE, but I could not find this functionality in a Calculation View. Is it necessary to work here with calculated fields and if statements, or is there another solution for this?
Best Regards,
Alex