Showing results for 
Search instead for 
Did you mean: 

Fetch count of base elements in BPC logic script

0 Kudos


Is it possible in BPC logic scripts to fetch the count of Base members of a Parent element ?

I have a requirement where the values aggregated at parent level need to be divided by the number of its base elements. Eg. F001 has 4 base elements(SF1, SF2, SF3, SF4) then the calculation should be as

SUM(SF1+SF2+SF3+SF4)/number of base element

So is there any way I can dynamically get the count of base elements ?

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor

There is no standard way to get number of base members under some parent.

But you can use some dummy members of other dimensions to store 1 in each base member of dimension with SF1...SF4...

Then in script logic the value in the parent F001 for this dummy combination will be equal to nuber of base members.

Answers (0)