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?
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
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
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
Hi @cc7 ,
The techniques explained previously should still work for the latest releases. Have you tried them?
Best,
Renato
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.