Skip to Content
0
Former Member
Sep 16, 2014 at 03:22 PM

How to implement the summary report of a specific property?

28 Views

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