2

Closed

Blank Rows in drillthrough Action report

description

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.

Regards,
Gayatri

file attachments

Closed Jul 19 at 4:56 AM by furmangg

comments

furmangg wrote Jul 11 at 1:54 PM