Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

April 1, 2015

Need and Ways for Performance Optimization in OBIEE

 

In all my years of working with OBIEE, I have seen a special interest in performance testing and tuning in the recent years. I have been involved in recent past with one of the active engagements for an OBIA system for performance optimization. This lead to a lot of interesting reading and some on the job application, thought should share it with you all.

While Optimizing Performance the most challenging task is to know where to begin. Most of the time Performance issues are raised or known only when we are actually in the performance test phase of the project. Post Analysis we should take the right approach for optimizing the performance and not some shortcut ways. If the analysis suggests that the rpd metadata / dashboard design/ built is the suspect or the underlying data model is not modelled properly optimization techniques are not going to work and redevelopment should be considered as it is rightly said

If a system that has a fundamental design flaw cannot be optimized - it has to be redesigned.

By default whenever OBIEE reports take a long time to return results, end users tend to say "OBIEE does not perform well". There might be different reasons for it other than OBIEE some of them might be the underlying database, network or infrastructure. We will discuss more about what we can do within OBIEE for performance optimization considering we have all other levers correctly placed.

OBIEE Reports creates a SQL query with the help of BI server and that is purely driven by how the data modelling is done is executed directly against the underlying database. A quick look at the SQL query getting generated can give us an idea whether best practices of OBIEE design are followed or not. By following the best practices in OBIEE design the SQL query generated can be made free of unnecessary clauses and nesting statements.

OBIEE itself has many out of box functionality for performance optimization such as usage of aggregate tables, using cache, changing the log levels and so on but are not enough to handle the performance issues.

The components involved in Performance Tuning are

·         Weblogic Server

·         BI Server

·         Presentation Server

·         Data Warehouse

With the help of monitoring tools like Enterprise Manager Metric Palette, Performance monitor, Server related statistics are collected and should be acted accordingly.

Would list some of the performance optimization techniques less known yet effective

·         Try Tuning the Connection backlog buffering and Statement Cache on Oracle Weblogic server.  Try adjusting the accept backlog value which might be set too low  due to which connections are dropped or refused at the client.

·         Oracle BI Server performance can be improved by prohibiting RPD updates. By doing this Oracle BI server is not needed to handle lock control.

·         Various configuration options can be used to limit the maximum number of rows that can be downloaded, included in mail or processed.

·         Limit the maximum number of rows that can be processed to render a table. This significantly improves performance as it reduces the system resources that will be consumed by user session.

·         Providing Permission to objects by groups/roles.

·         Union requests, consumes more memory as they generate more temp file , hence should be avoided.

·         Load to BI resources can be reduced by avoiding usage of guided navigation

·         Session variables use should be minimized.

·         Dimensional Hierarchy should be modelled accurately so that Oracle BI optimizer can select the most economical source

·         Content tab of logical table sources should be used to limit the number of rows returned from the database

·         Exploiting aggregate tables, pre-calculated measures aggregated over a set of  dimensional attributes are stored in aggregated tables

·         Make NULL and NOT Null column in sync with RPD and Database to avoid full outer join with NVL

·         Bitmap Index for all Foreign Key columns (for Summary reports) and Bitmap Join Index (lowest granularity based query for detailed data)

·         Usage tracking should be switched off if not needed as it will avoid extra DB Operations that run against each query.

·         Remove Snow flaking and Create Foreign keys for each dimension into Fact

I would like to emphasize that no single solution or configuration can take care of all performance issues.  Other than listed above there are many more settings / ways that helps in performance optimization, my aim was to list some of them covering highlights. Performance optimization might target Database, Environment parameters, Data model, Repository Design or Report Design having the same objective. While performance cannot be optimized by applying certain set rules and standards, having faced different challenging environment and experience helps..

It's all about working around and coming up with the best solutions for the project understanding the project flows and business scenario's. To have an optimized performance application we need to follow the best practices and design standards.

March 31, 2015

Unlocking the Organizational Change Conundrum

Managing Change - Lessons from the Ground

Being an avid supporter of one of the biggest football club in the world, I was reading an article by a former club captain the other day. The article dealt with the trials and tribulations of the club post the retirement of the manager, someone who had become the spirit of the club in his more than two decades of service. The article went on to describe the past glories and how the leaving of key figures had led to lost ground in the battle for footballing supremacy.

Drawing parallels to the corporate world the current situation of the gives us a great opportunity to look at how change in leadership can be managed best after a prolonged period of magnanimous success. It starts with all stakeholders having to let go of the past and accept the situation and plan for the future. The basis to the philosophy being discussed were four key words Form, Storm, Norm, Perform.

Continue reading " Unlocking the Organizational Change Conundrum " »

March 24, 2015

Fusion BI Apps and Oracle Transactional Business Intelligence

Introduction to Fusion BI Apps and Fusion Reporting

Fusion Business Intelligence Applications is an Out-Of-The-Box reporting solution that comes packaged with Fusion Applications having pre-built data models, Extract-Transform-Load processes, Key Performance Indicator's, Metrics, Reports and Dashboards. They cover varied business functions viz.

  • Oracle Procurement & Spend
  • Oracle CRM
  • Oracle SCM
  • Oracle Financials
  • Oracle HCM
  • Oracle Project Portfolio Management

Closely integrating the reporting solution for Oracle Fusion with the transactional systems it provides seamless interaction of reports in Fusion transactional screens. This provides a common platform and also allows the triggering of business workflows from the reporting application.

Continue reading " Fusion BI Apps and Oracle Transactional Business Intelligence " »

March 5, 2015

Manage Projects by Exception Using Fusion Project Portfolio Management

For an organization to remain competitive it is essential that the right portfolio of projects is selected which would ensure current and future profitability. Projects are selected based on the fitment with the strategic goals of the enterprise. During the initial stages of the project, the project manager's key responsibility is to prepare and present the business case to showcase the projects fitment against the long term strategy of the organization. Only after approval from the key stakeholders the project is selected for execution in the organization.

However, during execution of the project often the project team decides to monitor progress using a new set of parameters like margin percentage, revenue, and Schedule Variance, Cost Variance and quality standards.  The link is lost with the organization strategic objectives the very reason project was selected. The best practices in project management suggest a uniform set of parameters during the entire project life cycle from Project Initiation to Project Closure.

Fusion Project Portfolio Management bridges this gap and provides the corporate, portfolio and project manager with a dashboard to monitor the portfolio progress on a real time basis based on uniform set of parameters across the organization - Key Performance Indicators (KPI's). The dashboard provides a snapshot of projects which are On Track, At Risk and Critical. The portfolio managers can immediately focus their attention on projects which are at Risk and Critical thus enabling them to manage projects by exception.

For example, a KPI can be defined that non-billable costs should be less than 10 percent of the overall project cost. The user will be able to immediately identify the projects in the dashboard which do meet the criteria and for a detailed analysis can drill down to the project transactions to analyze the reason. The applications come with embedded analytics that would help the user to identify the potential reasons. In this scenario it might be possible that the field users on the projects have not submitted the timecards for last week and once the timecards are submitted the project will be back on track. The project manager's observations can be captured as a note which can be viewed by all the stakeholders.

Projects are no longer managed and executed in silos. To ensure profitability and sustainability of organization, portfolios needs to be managed dynamically and PMO should be able to derive reports and trend indicators with a click on button in the modern application. Fusion PPM also helps the portfolio managers to suggest corrective action to bring the non-conforming projects back on track and make a rationale decision to terminate projects based on current and historical KPI's.

February 20, 2015

Latest & Greatest FDMEE 11.1.2.4

Continue reading " Latest & Greatest FDMEE 11.1.2.4 " »

February 16, 2015

Oracle CRM on Demand: Future, Roadmap and Strategy

 

Oracle CRM on Demand which was previously known as 'Siebel on Demand' has evolved long way from its acquisition by Oracle in 2006.  Oracle CRM on Demand is a hosted SaaS (software as a service) application which provides deep Sales Force Automation functionalities with strong analytics along with Customer Service, Marketing and Contact Management functionalities.  Oracle CRM on Demand is continuously evolved from Release 10 in 2006 to Release 27 in 2014. Initially after acquisition there was no major innovation pack for around 2 year however from Release 16 onwards Oracle has delivered Oracle CRM on Demand release in every 4 months [1]. Oracle CRM on Demand is now much more refined product and provides latest usability, mobility and extensibility solution.

Continue reading " Oracle CRM on Demand: Future, Roadmap and Strategy " »

February 3, 2015

Disappearing Sales Process & Emergence of Marketing Automation

According to research conducted by CEB marketing leadership council in partnership with google, around 57% of the sales process or due diligence process is over before a prospect ever talks to sales person.  The classic sales process of engaging a customer, qualifying the customer, creating opportunity, making a proposal, closing sale and following up, is fast changing. The customers are changing the ground rules. With advent of social media, smartphones, apps, mobility etc., there is a demographic of customers who are swaying away from the traditional sales process.

Continue reading " Disappearing Sales Process & Emergence of Marketing Automation " »

January 28, 2015

Oracle Customer Experience Applications- The SI dilemma - What should one recommend?

Since Oracle Open World 2014, Oracle has been focusing on its Customer experience suite of applications which span across all customer touchpoints and cover all the pillars of CRM.

Oracle is proposing an integrated Customer experience(CX) on the cloud where all these modules are loosely coupled to allow flow of important information across the various applications. So clients would have an option to deploy specific modules to tackle certain business problems or use an integrated suite.  These applications are hosted on Oracle's extensible cloud platform and are available in the Application-as-a-Service mode.

Continue reading " Oracle Customer Experience Applications- The SI dilemma - What should one recommend? " »

January 23, 2015

FDMEE : Patch 510(11.1.2.3.510)

In previous part we discussed the different integration tool and their comparison with FDMEE. In this blog we will discuss the functionalities that were added as part of PSU510 for FDMEE. Also, we will discuss the bugs that have been fixed and the functionalities that are still missing.

Continue reading " FDMEE : Patch 510(11.1.2.3.510) " »

January 14, 2015

Hyperion Data Integration Tools - A Comparison

Continue reading " Hyperion Data Integration Tools - A Comparison " »

Infosys at Oracle OpenWorld 2014. Stay updated.
Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter