on 08-08-2008 1:11 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.