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

Main

August 13, 2016

Designing Next Generation Supply Chain and Logistics

In today's world, global economy can be erratic and businesses around the world need to adapt to ever changing scenarios. Moreover, growing competition and tectonic shifts in technology have forced businesses to re-think their supply chain and logistics strategies. Supply chain professionals around the globe are exploring possibilities and leveraging cutting-edge technology to gain competitive advantage. We discuss here top-two disruptive technological breakthroughs, which are crafting the next generation of supply chain and logistics. 

Device mesh: Hyper-integrated, Automated and Responsive supply chain

Let's face it!  In the last couple of years, an explosion of technologies is transforming the way supply chains will function in the coming years. Trending technologies include automatic identification and data capture (AIDC), Internet of Things (IoT), Bluetooth connectivity, electronic sensors, radio-frequency identification (RFID), cloud computing, mobility and many more! Together, these technologies create a digital mesh of devices, which transform the supply chain and logistics processes. This enhances the information flow and communication between various supply chain units and stakeholders.

Device mesh is gaining popularity because they are able to address the gaps between ground realities and planning estimation in a volatile business scenario. In addition, they enable decision makers to respond to situations in a fast and efficient manner and avoid delayed communication. Also, we can't discount the valuable feedback we get from customers via various means such as customer service contact, social media platform, online interaction etc. -  Just imagine the possibilities if we can have all of it almost real time!! Device Mesh unlocks such possibilities.

Especially logistics providers around the world are early adopters of cutting-edge technologies and have been able to improve logistics visibility, ensure on-time delivery, and enhance customer service through device meshes.

a.png

Three pronged benefits of Device Mesh in Logistics space

Other areas such as enterprise wide visibility, warehouse and yard management, and fleet management have immediate benefits of adapting to such technologies. Businesses can have better control over their assets across inventory and transportation, reduce operational costs, or improve data accuracy.

Advanced Machine Learning and Analytics: Smart supply chain solutions

We live in an era of data explosion such that by the time you complete reading this line over 2.5 million pieces of content are shared on Facebook. With every second more data get created, but there are limitations to amount of data a human alone can analyze. Machine learning algorithms viz. supervised and unsupervised help us analyze such big data explosions and spot trends, behaviors, and possible bottlenecks in supply chain and logistics.

Machine learning remains a consistent technology trend, which is bound to stay valuable in the coming years. Though a recent entrant in the trend hype, it has quickly evolved to capture attention across businesses. In fact, machine learning replaced big data last year in Gartner Hype Cycle.

b.png
Gartner Hype Cycle 2015

For comparison here is Gartner Hype Cycle for 2014

Whether we talk about IoT, digital mesh, automation agents, user experience or smart machines; machine learning has an important role to play. Organizations around the world are waking up to the possibilities and insights that machine learning has to offer and are using it to gain competitive advantage. Logistics providers are saving millions of dollars each year by learning from data they generate.

Machine learning goes hand-in-hand with analytics. Data science as depicted on Gartner Hype Cycle is classified under innovation triggers -- businesses now have tools at their disposal to generate intelligence from historical data and to take it to next level. The advent of predictive analytics and advanced business forecasting techniques are helping businesses to mitigate risks, trigger early warning systems in supply chain, manage manufacturing better and anticipate demand beforehand.

Speed, agility, responsiveness, smart, and efficient are adjectives which define next generation supply chains. Evidently over time it will change the way business is done but there are extra costs which are involved in incorporating these technologies to your existing supply chain. Before embracing such disruptive changes, it's recommended that pros and cons are weighed rationally to have more benefit out of such enterprise.

Written by: Deepshikhar Tyagi

 


January 1, 2016

What to Choose? OBIEE or BIP

 

What to Choose? OBIEE or BIP

When in Confusion use Comparison

While making an investment into Business Intelligence (BI), organization wants to make best use of the technology available in the interest of organization. A lack of technical capability / understanding of functionality provided by BI tools, it is most likely to use the wrong tool and meet the needs partially /inefficiently. In this blog, I would like to talk about the key functionalities that OBIEE or BIP can provide and pointers that will help to decide whether one should use OBIEE (Oracle Business Intelligence Enterprise Edition)  or BIP (Oracle Business Intelligence Publisher).

 

Using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g one can deliver the most vigorous set of reporting, dashboard and scorecard functionality. It provides rich end-user experience and is easier for adhoc query and analysis. There are many key features of OBIEE 11g e.g. Map visualization, integrated search, actionable data that can be used by organizations effectively. OBIEE 11g supports the highest workloads and complex deployments as is built on a modern technological foundation. The total cost of ownership for an enterprise is overall low.

 

If you are looking for a single, Web-based platform for authoring, managing, delivering interactive reports and dashboards

Oracle Business Intelligence Publisher (BI Publisher) is the right pick. It allows formatted documents completely of all types. Using Oracle's Business Intelligence Publisher report layouts can be designed by end users in a Web browser. This reduces the time and cost needed to develop and maintain reports.BI Publisher is highly scalable and extremely efficient and can generate tens of thousands of documents per hour having minimum impact on transactional systems.

 

High level classification criteria's that should be used for decision making whether a report should be built using OBIEE or BIP for effective use of tools available are listed below :

 

Matrix for categorizing in OBIEE/ BI Publisher Report:

Criteria

BI Publisher

OBIEE

If the Report needs Analysis / Historical Analysis, is Analytical in nature

 

ü

If the Report is Static in nature and is needed in Real time

ü

 

If the Report is needed for Operational Reporting with some lag

 

ü

If the Report is Operational in nature and expected with no lag

ü

 

If the Report needs to show some trends

 

ü

If the Report is Static in natures 

ü

 

If the Report needs graphs

 

ü

If the Report is having fixed formats

ü

 

If the Report needs drill down

 

ü

If the Report needs Pixel Perfect Formats and complex layouts

ü

 

If the Report is expected to show aggregated data

 

ü

If the  Report is Transactional in nature and needs to be prepared Real time

ü

 

If the Report is dynamic in nature

 

ü

Ad-hoc Reporting is needed

 

ü

 

 While there are no set rules for selecting the tool for Business Intelligence Reporting above criteria's to decide the tool will help using the best available functionality from OBIEE / BIP.

September 28, 2015

Data Lineage and Impact Analysis

As both a BI Consumer and Author, I have always felt the need to know the origin of the data getting displayed on the reports. Having worked on quite a few BI Apps implementations in the last few years, the joy I felt on hearing about the new Data Lineage and Impact Analysis functionality provided by Oracle as part of OBIA 11.1.1.8.1 knew no bounds!

Continue reading " Data Lineage and Impact Analysis " »

July 8, 2015

Data flows between Hyperion applications using FDMEE 11.1.2.3

 

Continue reading " Data flows between Hyperion applications using FDMEE 11.1.2.3 " »

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 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 " »

February 20, 2015

Latest & Greatest FDMEE 11.1.2.4

Continue reading " Latest & Greatest FDMEE 11.1.2.4 " »

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 " »

January 13, 2015

The new improved Multi-Load functionality in FDMEE

Continue reading " The new improved Multi-Load functionality in FDMEE " »

December 3, 2014

FDMEE - The future of Hyperion Integrations

Part 2

Mappings Redefined

Co Author : Payal Kapoor(payal_kapoor@infosys.com)

In previous part we discussed the recently launched tool FDMEE (Financial Data Quality Management, Enterprise Edition) that was introduced in the EPM release, 11.1.2.3.

In this part we are going to cover some great mapping features introduced in FDMEE that were not available in its predecessor FDM. 

 

 

Continue reading " FDMEE - The future of Hyperion Integrations " »

June 26, 2014

A Vendors Guide for Understanding BI Deployments - Business v/s IT

Coming back from a recent onsite assignment, I realized how difficult it was being a BI implementation vendor. More so in a world where the Business and IT teams of the same organization view and evaluate the same BI application/platform using different yardsticks.

So what is it that makes these two different views so important to understand in order to develop a solid, easy to use and balanced BI platform which enables an organization to move forward intelligently and without hiccups?

Continue reading " A Vendors Guide for Understanding BI Deployments - Business v/s IT " »

April 29, 2014

What to Choose? OBIEE or BIP- When in Confusion use Comparison

Guest blog by
Neeraj Jha, Principal Consultant, Infosys Limited

While making an investment into Business Intelligence (BI), an organization wants to make best use of the technology available. Lack of technical capability / understanding of functionality provided by BI tools, would most likely lead to use of wrong tool and meet the needs only partially or inefficiently. In this blog, I would like to talk about the key functionalities that OBIEE or BIP can provide and pointers that will help to decide whether one should use OBIEE (Oracle Business Intelligence Enterprise Edition)  or BIP (Oracle Business Intelligence Publisher). 

Continue reading " What to Choose? OBIEE or BIP- When in Confusion use Comparison " »

January 29, 2014

FDMEE - The future of Hyperion Integrations

Guest Post by 
Manav Anand, EPM Consultant

FDMEE stands for Financial Data Quality Management, Enterprise Edition, introduced in the latest EPM release, 11.1.2.3. It is the latest version of Oracle's Financial Data Quality Management.  It is a data integration tool majorly used for integrating financial data. 

It is one of the favorite tools for business users and administrators because of its user friendly web interface and audit capabilities. A major advantage of using this tool is the drill through capability to Oracle GL and various other source systems which includes Oracle Fusion Financials, PeopleSoft, SAP ERP Financial to name few.  This tool is a seamless integration of ERPi and FDM. It is based on the ODI engine with the FDM workflow. The tool was released in a phased approach and targets to cover all the FDM functionalities by the end of last patch.

I would like to introduce the functionalities of this application based on our implementation experience in this blog.

Continue reading " FDMEE - The future of Hyperion Integrations " »

December 27, 2012

Relevance of Data Governance in Big Data

Enterprises always had more data than their infrastructure and processes could handle, even in past let aside the thought of deriving actionable intelligence for effective decisioning from them. The same problem has now intensified several folds with larger volumes, variety of data from social media, online channels & most critical is the "Urgency" to handle such data.

Continue reading " Relevance of Data Governance in Big Data " »

November 26, 2012

A Maverick Approach to DWH Performance

Guest post by
Kaushal Kumar, Technology Lead, Infosys

 

Performance of any application is the most ignored ingredient of any application implementations be it ERP, Reporting, Transaction systems. However reports being the highest visibility item owing to fact that audiences are the top brasses in organization chart, is quickly diagnosed and subsequently punished. Hence a correctly built report is half built report until it runs fast.

We recently came across a such implementation where a revenue report (name suggests the criticality) was running in hours, though perfectly designed, still miles to go before the result appears. Evidently it was a big pain point from report authors to report consumers and we got to put thinking caps on!

Continue reading " A Maverick Approach to DWH Performance " »

October 3, 2012

Radical Progress : Infosys Keynote at Oracle OpenWorld 2012

Guest post by
Abhishek Sabharwal, Principal Consultant, Infosys

 

They say the time stops at Oracle OpenWorld (OOW) when a keynote is on! Thousands of folks from our industry (clients, partners, media, analysts, academia) get charged up to know more about what's coming in the ever dynamic IT world, waiting patiently much before the keynote actually starts. While yesterday's keynotes were focused around innovations in hardware, social, cloud that Oracle continues to drive, the focus of Infosys keynote was about Radical Progress. I quickly reconfirmed the meaning of the world radical on my iphone and it said, something that changes the fundamentals. The first thing that I could think of was the world moving from flat to being round by Galileo which was then challenged by the church as well.

Continue reading " Radical Progress : Infosys Keynote at Oracle OpenWorld 2012 " »

August 28, 2012

Oracle Big Data Series - Part 1

Relational databases have been the backbone for decades, on which Enterprises have been taking business decisions and basing their strategies. For some that data set's been growing leaps and bounds with their business, and global footprint.Careful examination reveals that we are still talking about strucutred data thus far, while there's been a revolutionary change in the unstructured, semi-structured world of Information management.

Continue reading " Oracle Big Data Series - Part 1 " »

April 13, 2012

Oracle Hyperion Upgrade- Opportunities and Possibilities

Guest post by
Hari Ram, Technology Analyst, Infosys

 

The rapid progress in technology makes today's-latest seem like tomorrow's-outdated. The change may not always mean 'mere increase in the version number' or 'change in look and feel'. The newer version of a platform or product more often than not brings a bag of advanced features that will simplify the process, increase usability, fix earlier defects and most importantly provide more value for the buck spent.

Continue reading " Oracle Hyperion Upgrade- Opportunities and Possibilities " »

February 19, 2012

OBIEE 11g Upgrade - Some Key Considerations

Guest post by
Karan Chadha, Associate Consultant, Infosys

 

OBIEE 11g was launched amidst much fanfare in mid 2010 and the feedback since then has been fairly positive. Owing to this success, the market is seeing a lot of traction towards OBIEE 11g upgrade. I was a part of one such upgrade project and based on my understanding I am sharing a few key considerations:

  • Why should an organization upgrade to OBIEE 11g?
  • How automated is the upgrade and how much of manual effort is involved?
  • What would be the tentative timelines to complete the upgrade?

Continue reading " OBIEE 11g Upgrade - Some Key Considerations " »

Thinking beyond Hyperion Essbase for planning (Part 2)

Guest post by
Hari Ram, Senior Systems Engineer, Infosys

 

In the previous part of the blog, I discussed about the basic differentiators between Essbase & Hyperion Planning based Financial Planning systems. In this I am sharing thought on Data and Process management aspects of both the approaches.

Continue reading " Thinking beyond Hyperion Essbase for planning (Part 2) " »

January 24, 2012

Thinking beyond Hyperion Essbase for planning (Part 1)

Guest post by
Hari Ram, Senior Systems Engineer, Infosys

 

Oracle Hyperion Essbase provides the best of multidimensional database capabilities in terms of performance and features. The Essbase lovers and existing users may believe that Essbase is sufficient enough for their planning, budgeting and forecasting requirements. Hence most planning applications still exist on Hyperion Essbase instead of Hyperion Planning - the centralized MS Excel and Web-based planning, budgeting, and forecasting solution from Oracle's Hyperion Suite of Products.

Continue reading " Thinking beyond Hyperion Essbase for planning (Part 1) " »

November 28, 2011

Exalytics - BI and Big Data Tuned to Perfection

Analytics as we know is all about gaining insights from data to aid effective decision making. However, the vision of delivering fast, interactive, insightful analytics has eluded most of large Enterprises.

Continue reading " Exalytics - BI and Big Data Tuned to Perfection " »

November 18, 2011

Bridging Two Islands: A curious case of Oracle AIA

Guest post by
Vinod Kumar, Consultant, Infosys

 

Telecom sector has been chronically plagued by revenue leakage problems and often seen to be spending the maximum energy and budget on areas around how to not let it happen or in other words having in place an effective Revenue Assurance mechanism. Making it one of the most published area in the industry are the solutions around it yet the clients, be it the newcomers or the old-timers, are often marred by this problem. Not that there are no solution around it but it's the understanding of the solution/product offering and the judicious implementation which makes a solution stand out.

Continue reading " Bridging Two Islands: A curious case of Oracle AIA " »

October 4, 2011

Leveraging Fusion Business Process Model Methodology in Project Portfolio Management (PPM)

Guest post by
Sandeep Suresh Deshpande, Principal Consultant, Infosys

 

In today's world, business is exposed to a constantly changing environment where organizations face the most challenging situations -

  • Information silos across the value chain
  • Parallel processing amongst distributed systems
  • Mismatched products to support complex end-to-end business processes
  • Complex and long-running projects
  • Real-time project consolidation and budgeting

Oracle has done an extensive internal and external research, took the best practices from Oracle E-Business Suite, Oracle PeopleSoft, Oracle JD Edwards, Oracle Siebel and all other acquisitions to come up with a number of industry business process areas with multiple levels of decomposition. These world class business processes can be leveraged to deliver in the complex and challenging environment.

Continue reading " Leveraging Fusion Business Process Model Methodology in Project Portfolio Management (PPM) " »

August 24, 2011

Can Social Media be the next big lever for Business Intelligence? - Part 3

Guest post by
Karan Chadha, Associate Consultant, Infosys

 

In Part 1 of this blog, I had talked about the immense potential that Social Media data holds for getting transformed into business insights. In Part 2 I moved on to discuss Social Media Intelligence (SMI) tools and the key value adds that they provide to Organizations. I will now move on to the piece that is the most relevant for us; the piece about integrating SMI tools with conventional reporting tools like OBIEE and establishing an integrated reporting environment; an environment which leverages insights from structured enterprise data as well as fluid social data.

Let me touch upon two facets of what is now broadly known as Social BI:

  • Transforming generic insights offered by SMI tools into actionable customer specific insights
  • Richer customer insights by leveraging social data in conjunction with traditional data

Continue reading " Can Social Media be the next big lever for Business Intelligence? - Part 3 " »

October 11, 2010

OBIEE 11g - Ensemble of Innovation and Integration

- Gaurav Gupta and Indivar Nayyar

OBIEE 11g was launched in July and the software became GA a couple of months back (in August 2010). This release marks one more step in Oracle EPM consolidated product roadmap. For this release, Oracle has focused on 2 basic tenets: Innovation and Integration.

New innovative features have been incorporated and are backed by strong integration with disparate applications, source systems and Fusion middleware architecture resulting in integrated user interface offering streamlined experience to end users. At Infosys, we have explored 11g's new features and installation and upgrade process and would be detailing them out in a series of blogs on OBIEE 11g. This entry will focus on providing a high level overview of the new functionalities incorporated in OBIEE 11g.

Continue reading " OBIEE 11g - Ensemble of Innovation and Integration " »

September 16, 2010

Oracle's promising BI Roadmap - Taking the joy ride together (Part 1) !!

The relevance of information is defined by the accuracy, timeliness and efficiency with which it can be leveraged. 'Change' is a constantly happening process that reflects the present and defines the future, overcoming the flaws of the past. A company's legacy applications and technology might be outdated and needs to be modernized to perform and deal with competition.

Continue reading " Oracle's promising BI Roadmap - Taking the joy ride together (Part 1) !! " »

September 14, 2010

How can you manage user expectations while transitioning from existing BI platforms and applications to Oracle BI Fusion Edition?

Managing user expectations is increasingly becoming the key concern of organizations while implementing or upgrading BI software applications and platforms. Goading as well as guiding the users to embrace the change is extremely important for successful implementation of Oracle's BI Fusion platform and its pervasive use within the company. So how can a company manage user expectations and upgrade to Fusion keeping both users and management in sync. Is this really possible?

Continue reading " How can you manage user expectations while transitioning from existing BI platforms and applications to Oracle BI Fusion Edition? " »

January 14, 2010

Data Federation – A potent substitute of Data Warehouse?

From my past experiences, I have observed that we often build a data warehouse as a way of integrating multiple sources of data to gain effective business intelligence. This is both time and resource consuming and also can potentially disrupt the IT roadmap of an organization if not handled with utmost maturity.

In this rapidly changing world of technology, new paradigms have evolved which have the possibility of simplifying the process of aggregation of multiple sources. One such technology which I found very exciting is Data Federation technology which is also known as Information-as-a-service, Data Virtualization or EII(Enterprise Information Integration).

Heart of this technology is a “virtual database” or a Federated Database as was defined by McLeod and Heimbigner long back in 1985. Simply speaking, a virtual database is storage of data definitions and not the data itself. The virtual database will have information about the location of the data.When a single call is made to a virtual database, the technology ensures multiple calls to underlying databases and is also responsible for meaningfully aggregating the returned result sets.

Primary benefit of the above approach is that data need not be moved from the source systems for analysis.It also saves the cost of building and maintaining a permanent warehouse.  Since data is not being moved, this enables quick and real time data delivery. 

The biggest challenge that needs to be handled for such a system to deliver what it promises is the heterogeneity of the DBMS giving rise to naming, schema, domain, model conflicts. These can be  typically handled by designing multiple stacked-up schemas which accurately translates
the data model,as visible to the user, to actual data models of the component DBMS.  

Areas where this technology will have ready acceptance are the organization’s divisions (like fraud detection units) which heavily rely on real time intelligence from disparate systems to drive business. Data Architects may also find this approach very efficient for maintaining master dimensions which are typically time consuming at an enterprise level.

Vendors like Oracle, SAS, Informatica etc have already lined up extremely comprehensive solutions in the market. Now it’s on the Consultant and Architect community to go out there and propose solutions which are truly ‘out of the box’!  

Last but not the least, what is the experts’ take on this?
Talking to some of the data warehousing connoisseurs, I felt people are divided on the appropriateness of this approach of replacing a data warehouse with federated architecture. Weighing in the pros and cons, I can safely conclude that at this point of industry maturity, this approach definitely merits an augmentation to a traditional data warehouse but we need to wait and watch how best it evolves to become the mainstream.

June 15, 2009

Business Intelligence Serving Manufacturing Industry

In the current recession hit market, Manufacturing is one of the industries that is facing global competition that it has never experienced. Reductions in profit margins, Increase in raw material cost along with government regulations demand more innovative ways to look on to Optimize resources, gain productivity, minimize investment.

Continue reading " Business Intelligence Serving Manufacturing Industry " »

May 11, 2009

Real Time Business Intelligence

Traditional BI deployments result in a time lag between the time data is entered in a transactional system and the time at which this data is available to the analytical systems for reporting & analysis. This time lag is dependent on the data extraction process (ETL) to extract, transform & load the data warehouse, aggregate and present the data in the form of reports, dashboards and alerts to the end user. The architecture of the BI platform deployed and the business requirements of an organization mandate the schedule of data extraction processes. For a typical manufacturing organization having an ERP system, to capture transactional data the ETL processes are generally scheduled to run on a fortnightly, weekly or daily basis. The complexity of the KPI’s measured through the reports governs the time spent on data aggregation and presentation.

Continue reading " Real Time Business Intelligence " »

March 27, 2009

To ETL or to EL-T: that is the question

Between ETL and EL-T apart from the superficial difference in the positions of the letters L and T there lies a deeper difference in the very philosophy of how data integration is performed in each of these patterns. Before we get into the technical differences and relative benefits let me first lay down the two philosophies of data integration

Continue reading " To ETL or to EL-T: that is the question " »

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter