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.