Are there any experts who have any ideas on this problem? Actually, I have similar situation. My boss requires such flexibility in our reports in SAS Web Report Studio. Here is my situation.
I created a cube in SAS OLAP studio first. It contains one dimension. And within the dimension, there is a three level hierarchy. Let's say the dimension named "DDD", the hierarchy is A->B->C. Then I defined a measure called "Total". Then I created an Info Map file and use Web Report Studio to make the table and chart based on the Info Map file. The table now looks like below:
"-+" means "Expand", "↓" means "Drilling down".
Now, my boss wants to change the order of A->B->C to C->B->A directly in the page so that he can see the data from different point of view. But it seems the order of the hierarchy cannot be changed directly in the web report studio. If I want to realize this flexibility for my boss, is there any way that I can take? I tried to define A, B and C as deminsions in the cube. Then their order can be changed in the table, but there will be no "drilling down" function for them. I really appreciate it if any one can provide good ideas on it.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.