Skip to main content

Merge cells in OBIEE.


OBJECTIVE:

In this blog, I will explain how to create merge cells in OBIEE dashboards.

The main functionality of merge cell is all of the text and numbers from the individual cells is merged and displayed in the center of the merged cell.

How can we create merge cells in OBIEE reports?
  1. Open the Oracle Business Intelligence platform.
     Enter the credentials and login to oracle business intelligence.



     2.   Create new analysis.




  3.    After selecting Analysis, select any one subject area. 

 4.   As I selected sample sales Lite as my subject area to prepare merge cells in report.

       The page will be opened like this:



5.   Select required columns from subject area in left panel to right panel as shown in the figure.




   6.  The result will display as monthly revenue in year.


   
 7.  We need to implement months as quarter. Under each quarter we had equally divided months.
         
           To get this, we need to edit the formula for particular column.


    
     8.  The formula provided in the column.
          
               Month_Of_Quarter (“Time”. “Calendar Date”).


            Then click on ok.
   
      9. The result will display as follows:
         




   10.  Next to provide average of revenue for quarter with a simple aggregate formula to calculate the aggregate per quarter.
        
               We need to edit the formula for that revenue column.
                   


   11.  In edit formula, we need to change formula to get average revenue.

12.   The result will be displayed as follows:


            Here, the revenue for three quarters is same.

13. Now the variable will be used to identify each middle record for each quarter, so I changed the formula slightly so that it will only show data i.e. the second month of the quarter.
           
         To get this we need to apply formula for that column.




14.   Then click on ok. The result will be displayed as follows:


15.    Now here comes the tricky part. We need to change the style for each cell. I’ll need to make the bottom border of one cell and the top border of the next cell disappear. I can do this by using the following conditional custom CSS style for each element.
                 
                                      Border_top:0 px;
                                      Border_bottom:0 px;






16.  We can also restrict the year to see the revenue for particular year, By applying condition to the year column.




17.   After applying filter condition, finally the result will display as follows:




            This is the process to build merge cells in OBIEE reports.


Conclusion:

The use of creating merge cell in obiee is all of the text and numbers from the individual cells is merged and displayed in report.



Comments

Popular posts from this blog

Creation of Digital Boardroom in SAC

Purpose of Digital Boardroom: SAP Analytics Cloud as a Software as a service analytics capability is the technology foundation and analytics platform for SAP Digital Boardroom. Architecture:  We have different sources in SAP cloud, from there it will connect to either Industry or Line of business solutions to design models, stories or some planning or predictive analysis. From there we create Digital Boardroom. For your Digital Boardroom project, you can leverage the following capabilities of SAP Analytics cloud:    With BI, you can discover your data and create visual content (KIP'S , Visualizations, stories).    You can add simulation,planning,predictive, collaboration aspects to your boardroom. It is critical that the Digital Boardroom design corresponds to the functional capabilities of underlying analytics solution. It prescribes specific design rules for handling charts, Like width of bars,color coding,white spaces between visual objects

Creating and using DataFlows in Power BI

Creation of Dataflows in power BI Dataflows in power bi are reusing power query logic among different pbix files. Dataflow is a collection of entities that are created and managed in power bi service. You can add and edit entities in your dataflow and manage data refresh schedules directly from workspace. Why we need in power bi:   Power bi introduces data flow to help organizations unify data from disparate sources and prepare it for modelling.   Dataflows are used to ingest, transform and integrate by defining data source connections, ETL logic and refresh schedules.   Data is stored as entities in common data model in azure data lake storage GEN2 and these were created and managed in workspaces by using power bi service. Steps to create dataflows in Power BI 1. At first we need to create one workspace for the dataflow in power bi. 2. After creation of workspace, we will create a data flow in power bi service. 3. We can s

How to show Notification Messages in PowerApps

  Introduction:   In this blog, we can see how to notify a user on the screen in PowerApps. Notify Messages in Power Apps:    In PowerApps, we create customized forms, Apps to our business need. We might have come across a situation like notify the user about various things happening through the User Interface.         To Achieve this type of situation,                             PowerApps provided a function called “Notify”                      Syntax: Notify (“Message”, [NotificationType], [Time])   There are four types in Notification:         NotificationType.Information         NotificationType.Error         NotificationType.Success         NotificationType.Warning Here time is optional to show our message in particular seconds. Steps to Create notification in PowerApps: 1.      Create a Canvas App in PowerApps.  2 .      Then create a button on the screen in PowerApps. Here, I have created a button, need to write formula on Onselect Property of a button. Below