cancel
Showing results for 
Search instead for 
Did you mean: 

Count number of answers

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Create the char Answer with aggregare reference charecteristics as Action and chose specific aggregation in creation of infoobject char BEx explorer tab.

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks for help

It works.

Ciao,

Vince.