Blank Rows in drillthrough Action report


I have a summary and detail table in my tabular cube joined on a key. The detailed table has a subset of the keys available in the summary table. I have created a drillthrough action which shows data from the detailed table.
On clicking the drillthrough action, I see blank rows in the report (for keys which are in summary but not in the detailed table). Is there a way to avoid getting blank rows in the drill through report?

See attachment for model, sample data and output.


file attachments

Closed Jul 19, 2014 at 3:56 AM by furmangg


furmangg wrote Jul 11, 2014 at 12:54 PM

wrote Jul 19, 2014 at 3:56 AM