Group your measure into a Dynamic Range - OBIEE

This was one of the interview questions, asked to me.

Requirement was for a report, where user can see a measure and range in which that attribute is falling. Range had to be dynamic.



The suggestion was to store a range in a separate dimension and then populate related foreign key in fact table. And dynamism would be achieved by changing range at the DB.

Here is another solution which gives user flexibility of choosing range gap and changing the range dynamically from Dashboard.