Description
Decision Factors to Consider for Installing Oracle Business Intelligence During an E-Business Suite Implementation.
Decision Factors to Consider for Installing Oracle Business
Intelligence During an E-Business Suite Implementation.
Core Services Corporation, an Oracle Platinum Partner, delivers Oracle-based business operations
solutions, information systems and support to clients worldwide by providing superior Oracle Hosting
and Consulting services. Additionally, Core Services is authorized to sell and service Oracle E-Business
Suite, leveraging the Oracle Business Accelerators. Founded in 1990, Core Services offers full-service
Managed, Remote DBA, and Disaster Recovery solutions.
Recognizing that today’s fast-paced business environment demands frequent critical decision-making at
all levels of an organization, Oracle Business Intelligence (“BI”) provides decision-makers real-time
access to enterprise information residing in different data silos. The Oracle BI Analytics tool provides
business leaders with the competitive edge needed to make rapid, well-informed decisions.
With the evolution of Oracle E-Business Suite, R12 drives superior value in all product areas and
provides new business advantages over the competition. Core Services is committed to provide best-
in-class Oracle consulting and hosting services to leverage Oracle’s E-Business Suite’s advances, which
include expanded functionality, scalability, usability, and lower cost of ownership.
Introduction:
Oracle Business Intelligence drives the decision in many organizations to upgrade. When implementing
or upgrading to EBS R12, the number one challenge most companies face is how to generate reports
needed to get the job done effectively and ef?ciently. The following provides the management confer-
ence room questions and discussions Core Services recently completed with a client-- and the strategy
ultimately implemented.
Key Questions to Consider Prior to an ERP upgrade/implementation:
1) Migrating legacy data to a new E-Business Suite (“EBS”) implementation is hard, time consuming,
and expensive. In some cases, data is needed but can be relevant for a short time period only and then
never looked at again. Should one spend the next couple of months cleansing and migrating short lived
data over to EBS or is there an alternative more effective strategy?
2) In this case, when reviewing the list of potential EBS users Core Services discovered that 30% of them
were infrequent users who required ERP “read only access”. Can BI help to mitigate licensing costs in
the event a user simply needs to retrieve data for a report?
3) The company needed a reporting environment to be extremely agile and ?exible. New reporting
hierarchies and customized calculations were required for management KPI and Dashboard based
reporting. The issue became whether additional customizations should be made in the ERP or in the
Data Warehouse?
4) The company was on an aggressive growth plan and Management wanted to know how quickly could
the Data Warehouse scale to meet the company’s thirst for additional data?
5) Some reports generated out of EBS were unformatted (Notepad) or required extensive massaging to
make them ready for management. How will BI eliminate time wasted generating these reports?
CORE SERVICES CORPORATION CASE STUDY:
Factors that in?uenced Management Decision:
1. Costs- Driving the decision was Management’s desire to minimize costs while maximizing return on
investment. Management and Core Services determined that the cost of cleansing/scrubbing all the
legacy historical data could not be justi?ed. The Data Warehouse seemed the more appropriate
location to “house” historical legacy data and merge it with the new data extracted out of EBS.
2. Manual vs. Strategic- Management knew that manually-created reports consumed far too much
company time and resources. The Data Warehouse solution empowered employees to quickly and
easily generate the reports thus freeing up time for data analysis.
3. Not Too Many Changes at Once- Keeping in mind that employees were being completely retrained
as they migrated from an old Legacy ERP to EBS, Management wanted to minimize the amount of
change. The question posed to Core Services was, can the reports/calculations operate in the same
way as before? Can there be consistency in utilizing the same acronyms and company de?nitions/
terminology to minimize the learning curve?
4. Scalability- Because Management saw acquisitions as an integral as part of the growth strategy, the
Data Warehouse solution had to enable a rapid deployment and minimize the transfer of large excel
?les via email.
Results:
• Core Services created 3 reporting schemas (legacy, EBS, and a merged schema of legacy and EBS
data) concurrently as the EBS modules were being developed, tested, and implemented.
• Project was completed in 6 months with canned reports built for Finance, Marketing, Customer
Service, and Operations. Advanced users utilized Data Cubes for ad-hoc reporting.
• The company saved money by eliminating unnecessary user licenses. For the occasional “read only
access” user a number of canned and cube based reports were developed.
• After vetting and validation, the Data Warehouse was such a success, providing a high comfort level
among the users, that Core Services extended the Data Warehouse by developing customized applica-
tions. For example, Core Services built an advanced forecasting modeling application-utilizing data
from within the Data Warehouse.
• With the expectation of acquisitions, Master Data Management became a key component of the
Data Warehouse. Changing the data in a centralized system was easier and more cost effective than
managing change at multiple locations all over the world.
Today, the Data Warehouse is integrated into the very ?ber of the company’s operations and has proven
to save a tremendous amount of time and money and provide the optimal “tool” to help users get their
jobs done effectively. As the project neared completion, the Core Services team felt a real sense of
accomplishment when they walked the hallways and saw so many computer screens smoothly running
BI generated reports.
How Can Core Services Improve Your Business Effectiveness?
Core Services is dedicated to its clients’ success. Oracle BI Analytics provides companies with the
right information at the right time, allowing strategic business decisions to help you stay ahead of the
competition. Gain access to solutions that deliver intuitive, role-based intelligence for everyone in your
organization with Core Services’ Oracle BI Analytics Proof of Concept (POC) program, hosted at Core
Services’ secure, SAS 70 Type II certi?ed data centers.
CONTACT US AT:
www.CoreServices.com
+1 877-267-3797
[email protected]
doc_866282505.pdf
Decision Factors to Consider for Installing Oracle Business Intelligence During an E-Business Suite Implementation.
Decision Factors to Consider for Installing Oracle Business
Intelligence During an E-Business Suite Implementation.
Core Services Corporation, an Oracle Platinum Partner, delivers Oracle-based business operations
solutions, information systems and support to clients worldwide by providing superior Oracle Hosting
and Consulting services. Additionally, Core Services is authorized to sell and service Oracle E-Business
Suite, leveraging the Oracle Business Accelerators. Founded in 1990, Core Services offers full-service
Managed, Remote DBA, and Disaster Recovery solutions.
Recognizing that today’s fast-paced business environment demands frequent critical decision-making at
all levels of an organization, Oracle Business Intelligence (“BI”) provides decision-makers real-time
access to enterprise information residing in different data silos. The Oracle BI Analytics tool provides
business leaders with the competitive edge needed to make rapid, well-informed decisions.
With the evolution of Oracle E-Business Suite, R12 drives superior value in all product areas and
provides new business advantages over the competition. Core Services is committed to provide best-
in-class Oracle consulting and hosting services to leverage Oracle’s E-Business Suite’s advances, which
include expanded functionality, scalability, usability, and lower cost of ownership.
Introduction:
Oracle Business Intelligence drives the decision in many organizations to upgrade. When implementing
or upgrading to EBS R12, the number one challenge most companies face is how to generate reports
needed to get the job done effectively and ef?ciently. The following provides the management confer-
ence room questions and discussions Core Services recently completed with a client-- and the strategy
ultimately implemented.
Key Questions to Consider Prior to an ERP upgrade/implementation:
1) Migrating legacy data to a new E-Business Suite (“EBS”) implementation is hard, time consuming,
and expensive. In some cases, data is needed but can be relevant for a short time period only and then
never looked at again. Should one spend the next couple of months cleansing and migrating short lived
data over to EBS or is there an alternative more effective strategy?
2) In this case, when reviewing the list of potential EBS users Core Services discovered that 30% of them
were infrequent users who required ERP “read only access”. Can BI help to mitigate licensing costs in
the event a user simply needs to retrieve data for a report?
3) The company needed a reporting environment to be extremely agile and ?exible. New reporting
hierarchies and customized calculations were required for management KPI and Dashboard based
reporting. The issue became whether additional customizations should be made in the ERP or in the
Data Warehouse?
4) The company was on an aggressive growth plan and Management wanted to know how quickly could
the Data Warehouse scale to meet the company’s thirst for additional data?
5) Some reports generated out of EBS were unformatted (Notepad) or required extensive massaging to
make them ready for management. How will BI eliminate time wasted generating these reports?
CORE SERVICES CORPORATION CASE STUDY:
Factors that in?uenced Management Decision:
1. Costs- Driving the decision was Management’s desire to minimize costs while maximizing return on
investment. Management and Core Services determined that the cost of cleansing/scrubbing all the
legacy historical data could not be justi?ed. The Data Warehouse seemed the more appropriate
location to “house” historical legacy data and merge it with the new data extracted out of EBS.
2. Manual vs. Strategic- Management knew that manually-created reports consumed far too much
company time and resources. The Data Warehouse solution empowered employees to quickly and
easily generate the reports thus freeing up time for data analysis.
3. Not Too Many Changes at Once- Keeping in mind that employees were being completely retrained
as they migrated from an old Legacy ERP to EBS, Management wanted to minimize the amount of
change. The question posed to Core Services was, can the reports/calculations operate in the same
way as before? Can there be consistency in utilizing the same acronyms and company de?nitions/
terminology to minimize the learning curve?
4. Scalability- Because Management saw acquisitions as an integral as part of the growth strategy, the
Data Warehouse solution had to enable a rapid deployment and minimize the transfer of large excel
?les via email.
Results:
• Core Services created 3 reporting schemas (legacy, EBS, and a merged schema of legacy and EBS
data) concurrently as the EBS modules were being developed, tested, and implemented.
• Project was completed in 6 months with canned reports built for Finance, Marketing, Customer
Service, and Operations. Advanced users utilized Data Cubes for ad-hoc reporting.
• The company saved money by eliminating unnecessary user licenses. For the occasional “read only
access” user a number of canned and cube based reports were developed.
• After vetting and validation, the Data Warehouse was such a success, providing a high comfort level
among the users, that Core Services extended the Data Warehouse by developing customized applica-
tions. For example, Core Services built an advanced forecasting modeling application-utilizing data
from within the Data Warehouse.
• With the expectation of acquisitions, Master Data Management became a key component of the
Data Warehouse. Changing the data in a centralized system was easier and more cost effective than
managing change at multiple locations all over the world.
Today, the Data Warehouse is integrated into the very ?ber of the company’s operations and has proven
to save a tremendous amount of time and money and provide the optimal “tool” to help users get their
jobs done effectively. As the project neared completion, the Core Services team felt a real sense of
accomplishment when they walked the hallways and saw so many computer screens smoothly running
BI generated reports.
How Can Core Services Improve Your Business Effectiveness?
Core Services is dedicated to its clients’ success. Oracle BI Analytics provides companies with the
right information at the right time, allowing strategic business decisions to help you stay ahead of the
competition. Gain access to solutions that deliver intuitive, role-based intelligence for everyone in your
organization with Core Services’ Oracle BI Analytics Proof of Concept (POC) program, hosted at Core
Services’ secure, SAS 70 Type II certi?ed data centers.
CONTACT US AT:
www.CoreServices.com
+1 877-267-3797
[email protected]
doc_866282505.pdf