Enable Drilldowns in Union Subqueries
Completed
This would be helpful, as it's unfortunate drilldowns get disabled when adding a subquery, especially when the master and subquery are drawn from the same view.
I like this idea 
Hi Simon,
Below are screenshots of what I’m working with.
Each screenshot is from a separate report. Both reports do exactly the same thing and return the same results from the same view. The only difference is the one with the UNION returns a separate user-filterable subset of data from the view for comparison.
As you can see, drilldowns don’t work on the report with the UNION subquery. In fact, in the report builder under Analysis Style, “drilldown” isn’t available as an option.
Hopefully I haven’t missed anything in the setup. If this is indeed part of that known limitation with subqueries, yes, please add me to that enhancement request if I’m not already on it.
Thanks,
Andrew
From: Yellowfin Support <support@yellowfin.bi>
Date: Monday, May 31, 2021 at 6:42 PM
To: Andrew Clauson <andrew@profinancial.bc.ca>
Subject: New Comment in "Enable Drilldowns in Union Subqueries"
Hi Simon,
Below are screenshots of what I’m working with.
Each screenshot is from a separate report. Both reports do exactly the same thing and return the same results from the same view. The only difference is the one with the UNION returns a separate user-filterable subset of data from the view for comparison.
As you can see, drilldowns don’t work on the report with the UNION subquery. In fact, in the report builder under Analysis Style, “drilldown” isn’t available as an option.
Hopefully I haven’t missed anything in the setup. If this is indeed part of that known limitation with subqueries, yes, please add me to that enhancement request if I’m not already on it.
Thanks,
Andrew
From: Yellowfin Support <support@yellowfin.bi>
Date: Monday, May 31, 2021 at 6:42 PM
To: Andrew Clauson <andrew@profinancial.bc.ca>
Subject: New Comment in "Enable Drilldowns in Union Subqueries"
Thanks, Simon.
From: Yellowfin Support <support@yellowfin.bi>
Date: Wednesday, June 2, 2021 at 7:30 PM
To: Andrew Clauson <andrew@profinancial.bc.ca>
Subject: New Comment in "Enable Drilldowns in Union Subqueries"
Thanks, Simon.
From: Yellowfin Support <support@yellowfin.bi>
Date: Wednesday, June 2, 2021 at 7:30 PM
To: Andrew Clauson <andrew@profinancial.bc.ca>
Subject: New Comment in "Enable Drilldowns in Union Subqueries"
Yes, let’s close please.
From: Yellowfin Support <support@yellowfin.bi>
Date: Wednesday, June 2, 2021 at 9:09 PM
To: Andrew Clauson <andrew@profinancial.bc.ca>
Subject: New Comment in "Enable Drilldowns in Union Subqueries"
Yes, let’s close please.
From: Yellowfin Support <support@yellowfin.bi>
Date: Wednesday, June 2, 2021 at 9:09 PM
To: Andrew Clauson <andrew@profinancial.bc.ca>
Subject: New Comment in "Enable Drilldowns in Union Subqueries"
Replies have been locked on this page!