cancel
Showing results for 
Search instead for 
Did you mean: 

BEx query needs to count unique characteristic values

Former Member
0 Kudos

Is there any way to build a query using BEx query designer to count the number of unique values of a characteristic. For instance, my cube has detailed transactions for claim information. Each claim number can have multiple products. My query need to show the number of claims that exist for each product. I don't want the detail of the claim number, just how many claims exist.

Product Gross Paid Loss Claim Count

Total Auto $ 43,865.01 ?

Total Property $ 4,068,321.57 ?

Not assigned 19,426

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member209606
Participant
0 Kudos

Hi

Create one calculated keyfigure and give the value as 1 and change the Aggregation Tab exception Aggregation as Summation and choose ref Characteristic as product.

Regards

Sureshkumar C

bmalyadri
Explorer
0 Kudos

Hi,

Creat calculated  keyfigure with data functions Count value and save with technical name.

Right click on that go to propertes, select count with exception aggregation - Claim Number,

also use after aggregation and decimal places '0'.

Regards

Malyadri

chelomunoz7
Explorer
0 Kudos

It worked perfectly for me, thanks!