Hello,
I have a dimension named "ID_CLARITY", that, among others, has a property called "TECH_AREA". I would like to create a report with the dimension "TIME" in column, and in row the dimension "ID_CLARITY", but ordered by its property "TECH_AREA", so that I first see the TECH_AREA and then the ID.
The data in ID_CLARITY dimension are as follows:
ID TECH_AREA Property2 Property3
A0102 A0001 xxxyyyy yyyyxxxx
B0201 B0002 ......... .............
A010201 A0001 .......... ............
C030301 C0003 .......... ..............
I would like to get the following report:
2008.Q1 2008.Q2 2008.Q3 2008.Q4
TECH_AREA ID_CLARITY
A0001 A0102
A0001 A010201
B0002 B0201
C0003 C030301
Is it possible to get it manipulating the Control Panel in the BPC Excel ?
Thanks a lot in advance for your help!
Francesca