I am creating a report with two data providers in WebI. The common dimension from the left query is pulled into the report structure(making it a left join).
I have pulled several measures from the left query and a single measure from the right query(detail query).
When I am applying filter on an object from the left query, the values of the measure from the right query are all turning into NULL.
Please let me know how this may be fixed..Will appreciate a quick help:)