OBIEE 11g: Grouping Balances by Customer Balance Segmentation

Noha Shaaban

Hi,

I've been working on a request to sum the loan amounts for each customer segment. The report should aggregate the total loan balance for each customer and classify it as

Up to 10K

Over 10K up to 50K

Over 50K up to 100K

Over 100K up to 500K .. etc

then sum the total loan balances of customers in each category.

If anyone has a way to implement this id be grateful. I've managed to categorize customer balances, however, I can get the report to aggregate the balances by the categories.

Thanks,

Noha

cesar.advincula.o

you could use Bins, check this link

OBIEE in IL: OBIEE - Grouping measures and counting group members

Ankita Pangul - BI Developer

Hi,

I think you have to write the case statement for this. Like

Case when "loan.amount"<= 1 and "loan.amount">=10k then ' Up to 10k'

when  "loan.amount"<= 10k and "loan.amount">=50k then '10k to 50k'

and so on... end.

In column and then just take another column sum(customer).

Thank you.

Noha Shaaban

thank you so much for replying. Actually this has caused the amount to be aggregated incorrectly. The link provided above soted it out