cancel
Showing results for 
Search instead for 
Did you mean: 

Fetch count of base elements in BPC logic script

former_member590808
Participant
0 Kudos

Hello

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)

former_member186338
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)