Skip to Content
0
Former Member
Sep 10, 2014 at 02:14 AM

Design Studio Crosstab - Limitation?

158 Views

Hello All,

Below is a summary of issue I'm facing at a customer location.

Design Studio CrossTab :

Q1 Q2 Q3 Q4 north 100 120 130 142 south 123 176 132 123 east 130 187 154 134 west 132 133 189 134

I'm currently working at a customer place on a dashboard requirement and found this gap in requirement for crosstab.

Would really appreciate if anyone can point me towards a workaround to achieve this.

  1. Consider the above sample cross tab which shows regional sales by quarter.
  2. It is required to be able to click on any of the numbers and go to a detailed report for those two dimensions : EG : click on 100 and open detailed report for NORTH/Q1.
  3. We plan to achieve this by using design studio for first page and on click open a webi document thru OPENDOCU and passing respective parameters.
  4. The problem is , in design studio – it is not possible to click on a measure to capture both the dimensions.
  5. In the CROSS-TAB component of Design studio,We can either capture region or Quarter but not both at the same time.
  6. Is there any way I can click on the numbers and capture the associated two dimensions for the key-figure.?