I was wondering if there's a way to use Drill Anywhere on a report who's using subqueries? Is this possible?
Thanks in advance
Thanks for reaching out. This functionality should be possible. What build of 7.3 are you currently on?
As of 7.3 20180208 an enhancement was developed and published where "there's been an option in Report Format -> Data
This will only show if there are A) Basic Sub-queries and B) Drill anywhere is turned on
Turning this on will mean that when you drill anywhere with a basic sub-query it will add that drill filter to the parent sub-query and the child sub-queries."
This functionality does not apply to advanced sub-queries, however.
Thanks for your help on this case.
I'm currently using 7.35.16 version (build: 20190306), but strangely, it's not working for me. My report has all the pre-requisites you've told. The report has 3 basic subqueries, but i've tried with only one to test. The fields I've used has drill marked on, and the functionality it's turned on as well.
There are any configuration needed to use this feature?
PS: The image you've attached is not appearing for me for some reason.
There is indeed a configuration that needs to be toggled in Report Format > Data. It's called "Link Drill Anywhere to Basic Sub Queries" and is only available when there's basic sub-queries and Drill Anywhere selected under Analysis Style.
I've attached the screenshot as an image attachment instead so you can see what the configuration looks like.
I've taken some prints to show you my example. There are 2 prints below where you can see the same options you've marked on your example. They're marked on the configuration spots because it's on another language and so you can understand better. Is there anything wrong?
The setup here appears to be correct. I can see the fields aren't hyperlinked here though, so I guess the next question is: have the corresponding fields been configured for Drill Anywhere functionality in the reports' View?
Sorry Mike, I forgot to attach this another print on my previous reply. Here it is.
It appears that you currently can't use Drill Anywhere on fields that have Join's applied to them. It seems this setting just applies to being able to use Drill Anywhere on the remaining fields in the report. Although, I suspect this is a bug.
As you can see below, if I change the Master Query field, I lose the Drill Anywhere option:
Also as you can see, the field that's not selected as Master Query does have the Drill Anywhere option.
I can't say with 100% certainty this is unexpected behavior, but I've gone ahead and raised this as a Defect so I can see what the dev team comes back with. Any potential updates regarding this matter will be posted here.
Comments have been locked on this page!