We have a requirement where, user wants to get the KPI's stored in BPC for future use.
We implemented BADI for the same, but when at a group entity level, the values of KPIs gets added up as per standard BPC role up functionality.
To avoid this, we have planned to use a local member which will give KPI's values for consolidated report using excel formula.
the query is how do we override this KPI based on the entity selection.
So whenever the entity is a base member, the report should get us the KPI which is member of one dimension and when entity is a group level, report should use the local member.