Creating a report by dimension property

[Former Member]

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

[kirill_gromyko]

Hello Francesca,

Yes, this is possible.

When creating the report, go to member selector of ID_CLARITY dimension, click on Member Sorting and Grouping, and enable Member Sorting by the property TECH_AREA .

In the report itself insert new column and use EPMDimensionProperty function to display the property.

Please see attached 2 screenshots.

Kind Regards,

Kirill

EPM Support Team

[Former Member]

Thank you so much for your help so far. I am sorry, I did not specify that I am currently using BPC 7.5. Can I still apply the solutions that you all have provided above?

Thanks again

Francesca

[Former Member]

Hi Francesca,

My above solution is for BPC 7.5 only. Try to apply that and let me know if you get any problem.

Thanks,

Suresh

[Former Member]

Thank you Suresh, and thankk you all, I managed to solve the issue!

Regards,

Francesca

[former_member190501]

Hi,

Sort ID_CLARITY  using Member sorting & Grouping (group by property TECH_AREA). Create 2 local members to display properties TECH_AREA, ID  and hide the first column(excel-ID_CLARITY ) to show as per your requirement.

Hope it helps...

regards,

Rajiu

[Former Member]

Hi Francesca,

First create a normal report with Time in Column and ID_CLARINTY in Row. And then use EVPRO function to call TECH_AREA before th ID_CLARITY column and drag it upto used Row range and then exapand the sheet.

So you can get that structure which you mentioned.

In Option range parameter there is a Option called SortCol, there you just define the Column name where you defined the TECH_AREA property. So it sorted by using tha column whenever you refresh the report.

Syntax :

EVPRO('<APPLICATION_NAME>','<PROPERTY_NAME>','<EXCEL_CELL_RANGE>')

Hope it helps you.

Thanks,

Suresh

[Former Member]

Hello Francesca,

I assume you are working with BPC 10 for NW.

I think this could help you:

1. Select the ID_CLARITY dimension under report editor-->Dimension Members
2. Then"member Sorting & Grouping" you must enable "Member Sorting"
3. Then you should group by property TECH_AREA (ascending)
4. Finally you must add the member selection you whant to show

Tell me if it help you!

Regards,

Lucas.