Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to implement the summary report of a specific property?

Hi Experts.

We want to realize the summary report of specific property on following situation, but we can't find the good solution.

for instance:

(1)ENTITY Dimension

ID Region

------------------

DE EUROPE

FR EUROPE

MY ASIA

ID ASIA

TH ASIA

("REGION" is one of the properties of ENTITY dimension)

(2)Example Data

ID JAN FEB

DE 10 5

FR 5 5

MY 10 10

ID 2 3

TH 23 24

(3)Report that we wanna realize

ID JAN FEB

EUROPE 15 10

ASIA 35 37

In addition, we wanna make this report as following situations:

-Without assigning "Region" as hierarchy

-Without displaying each member level (DE, FR, ...). only display their property such as EUROPE and ASIA.

-BPC version is 10.1(NW).

By the way, we make out to subtotal each property to use "Member Sorting & Grouping" in menber selector, but we want to implement without displaying each member.

Is it possible to implement? Please advise us the good solution.

Best Regards,

Masa

Tags:
Former Member
replied

Hi Masa,

BW and BPC do not aggregate by property, only by hierarchy. You can always create additional hierarchy to aggregate figures in different ways. This is the correct approach.

"but we want to implement without displaying each member" - not possible, aggregation is done on Excel level.

Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question