Skip to Content

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

child count of a dimension member

How to find the child count of a dimension member and put the results in an excell column?

I have entities in one column and in the second column i need to have the children of respective member.

Former Member
Former Member replied

Hi Kiran Kumar,

I guess if i understand correctly. You want to find Average based on number of children instead of SUM.

In BPC always into hierachy you will have the parenth like sum of children.

In your case you can use dimension formula wher you don't need to addup all children numbers into parent but into property formula from your dimension you will specify that this member will be calculate average.

You have also MDX formula where you can specify that it is Average of all children.

Anothher solution will be to add a custom measure

(You have an HTG published into BPX/SDN regarding custom measure) to be calculate always like average of children.

I hope this will help you.

Rajesh Muppala.

0 View this answer in context

Helpful Answer

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