topic Re: Drill down interactions for hierarchy in SAS Visual Analytics

Drill down interactions for hierarchy

JimLittle — Thu, 02 Oct 2014 20:48:53 GMT

I have a report with several charts that use the same hierarchy for the category role. When users drill down on the category I need to have all charts updated to the same level.

While this works reasonably well in Explorer, I need to use Report Builder which doesn't have this function.

Any thoughts?

Re: Drill down interactions for hierarchy

Adelaida — Mon, 11 Apr 2016 10:16:17 GMT

Hi Jim,
I need to do a similar interaction for my cross tab/charts that use the same time hierarchy. How did you do it in Exploration? I have made an exploration with a cross tab and a bar chart. Both has the Time hierarchy as column/category, but drilling down from year to quarter in one visualisation doesn't change anything in the other. Can you explain please? I really need to implement a similar interaction to make the exploration user-friendly.
Best regards,

Adelaida

Re: Drill down interactions for hierarchy

Renato_sas — Fri, 27 May 2016 04:13:41 GMT

Hi @JimLittle,

If you don't have to drill into crosstabs, this article may be helpful: Keep your SAS Visual Analytics charts in sync through shared roles

Otherwise I'd suggest you to take a look here, where I've used a technique to simulate navigation through a hierarchy via multiple dropdown controls to solve a different problem. All you would need to do is define interactions between the dropdown list and the other objects in your report.

Best,

Renato

Re: Drill down interactions for hierarchy

cc7 — Tue, 15 Oct 2019 13:51:29 GMT

Hi @Renato_sas I'm facing the same issue with Visual Analytics 8.3. Any suggestions on how to apply the same hierarchy drill down automatically across all the objets with the same catergory hierarchy?

Thanks!

Carolina

Re: Drill down interactions for hierarchy

Renato_sas — Tue, 15 Oct 2019 15:42:44 GMT

Hi @cc7 ,

The techniques explained previously should still work for the latest releases. Have you tried them?

Best,

Renato