Skip to Content
0
Former Member
Apr 15, 2013 at 03:53 PM

Creating a report by dimension property

69 Views

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