BookmarkSubscribeRSS Feed
sissi
Calcite | Level 5

Hi All,

The hierarchy was defined in a cube which has three levels. I created a crosstab on the report and assigned the hierarchy as the row. But I found out the order of the three levels can not be changed.

So I tried to defined three seperate hierarchies instead of one and assigned three of them to the crosstab's rows. Now they can change orders, but the expand and drilling down functions are lost.

Is there anyway can let me change the order without losing the expand and drlling down function?

1 REPLY 1
YLF3
Calcite | Level 5

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:

DDDTotal
ABC
-↓ aa1-↓ bb1cc18888888
cc29999999
+↓ bb2
+↓ aa2
+↓ aa3

"-+" 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.

SAS Innovate 2025: Call for Content

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!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1108 views
  • 0 likes
  • 2 in conversation