Count number of answers

21 Views

Hello Bex experts !

I create a query containing a Hierarchy M (at the bottom there are "action" nodes)

I can have several answers for 1 action.

I can have several activities for 1 answer.

My query is based on a cube of Activities (from an ods Activities with key the activity id)

Examples of records :

Activity Action Answer KFc

A1 Ao1 Aw1 1

A2 Ao1 Aw2 1

A3 Ao1 Aw1 1

A4 Ao1 Aw3 1

I have a key figure KF which counts number of activities.

I want to count in BEx number of answers / action.

(In this example : Ao1 contains 3 answers).

But in Bex i have result = 4 (logical behaviour).

I don't want to display Answers and Activities in the query...

I juste want to put Actions and number of answers/actions.

I hope you could help me.

Points will be assigned.

Best cheers,

Vince.