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.
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.