How to implement the summary report of a specific property?
We want to realize the summary report of specific property on following situation, but we can't find the good solution.
("REGION" is one of the properties of ENTITY dimension)
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.
Vadim Kalinin replied
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.