Using Bins in OBIEE

If anyone want to group Markets in a region and their sales. We can achieve this by using bin with out writing long CASE Statements. Here is the work around by using Paint rpd

Step1: Pull two columns region and sales which will give you the sales in each and everyregion.

Step2: Click on Fx section on the column Markets

Step3: Go to Bin Tab, click on Add Bin button next add values what ever the values you want to be a group

 

 

Step4:You will get the report Region wise and also it will automatically sum up of all the Market values under a Region

Step5: If you click on Markets in Region 'A' then you will get all the Regions in that market with their values(years Ago Dollars)

 









2 .Case Statement (Bins) filter.

If we have a requirement to have case statement on column and it has some filtering condition on it. Filtering cannot be achievable by make use of presentation case statements or Bins, but using repository it’s possible.

Create a new logical column with required case statement in repository pull it on to Presentation, this will works fine with all filters.

Just to demonstrate I have made a dash board page with page prompt and report. Page prompt consist rpd case statement column and also presentation case column. Report consists of same above columns and one measure in a table.

 

Now if you try selecting any value in presentation case prompt, report will not effected with selection where as rpd -coulmn will be works fine.

Under line concept is using rpd column formula will be placed in physical SQL’s Where clause as well as Select, contrast Bins(presentation case) – column will put case statement in only SQL’s Selection clause.

Hope helpful to you