Hello all,
When I try Pivoting the result of one of my queries, OBIEE gives me an error saying there are too many variables. Is there a way to pivot the data i'm querying so it looks something like the Table#2.
The result of this query brings more than 30,000 rows as a result of more than 500 sales resources / 30 different products / 3 MDC... the revenue results are by week.
I tried using SQL but I couldn't make it work.
Table#1
| Sales Resource | Product
| MDC | Revenue |
|---|
| SR 1 | Product 1 | LY | 120 |
| SR 1 | Product 1 | TY | 122 |
| SR 1 | Product 1 | PLAN | 130 |
| SR 1 | Product 2 | LY | 150 |
| SR 1 | Product 2 | TY | 145 |
| SR 1 | Product 2 | PLAN | 200 |
| SR 2 | Product 1 | LY | 300 |
| SR 2 | Product 1 | TY | 400 |
| SR 2 | Product 1 | PLAN | 500 |
Table#2
| Sales Resource | Product | LY
| TY
| PLAN
|
|---|
| SR 1 | Product 1 | 120 | 122 | 130 |
| SR 1 | Product 2 | 150 | 145 | 200 |
| SR 2 | Product 1 | 300 | 400 | 500 |
