Using Bins in OBIEE

If any one 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 every region.






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)

Oracle BI EE 10.1.3.3/2 – Bins and Groups

One of the features that end users generally want is the ability to group multiple dimension attribute values into their own understandable groupings. For example, if we have a Product Name column, then end users would like to group different products under different categories like say Computer Products, Household Products etc. Also, they would like to have the capability to drill down from these groupings into their corresponding individual products. In order to achieve this we can use a feature in Answers called as Bins. Bins can group multiple values into smaller simpler groups thereby helping end users to analyze their data better. Lets see how this Bins work. We shall start with a simple report containing the Product Names and their corresponding sales.

      

Now if you go the formula section of the PRODUCT_NAME column, you would find a tab called as bins.

      

Now lets try to add a simple Bin. As you would see this would pop up a filter window wherein we can choose how we want to group the values into. In our case lets choose a set of products into a simple group called as “Important Computer Goods”. And for the remaining products lets group them as “Remaining Goods”.

      

      

Now if you go back to the formula console, you would see that the corresponding CASE statements would have been generated automatically. Now lets view the results. As you would see you only have 2 groupings now and you can drill down within each of these groups. Also, aggregation for these groups would happen automatically.

      

A very simple feature but can reduce a lot of effort while writing case statements.

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