Posts Tagged ‘BI’


Our Focus on Data Management and Data Integration

November 18th, 2010 by Robert McMillen • No Comments »

Many of you know that SSG is an Oracle partner and that we support many clients who rely on Oracle’s Billing and Revenue Management (BRM) product.  We have worked with BRM for over 13 years and have some of the most knowledgeable BRM experts in the industry.

What you may not know is that we are also an Informatica partner and that we have a growing Data Integration and Data Management practice based on years of experience with Enterprise data.  Our focus is a different from the typical Business Intelligence (BI) services that are common in the marketplace.  Even at SSG we’ve struggled to define what our overall focus is, in this area, since BI is only a portion of what we do.

The term “BI” focuses on building and managing Data Warehouses or Data Marts.  We can do BI, of course, but there are many other data management needs that we focus on, and which are just as strategic.  All of them have been driven by challenges that our clients have  faced.

Some of those challenges have been driven by these questions.  How well are we:

  • Sharing data between our systems in a timely manner? (Data Integration)
  • Ensuring we have all the information about Customer/Vendors/Products/Accounts in one place? (Master Data Management)
  • Monitoring the quality of our business data so it can be trusted? (Data Quality)
  • Sharing the right data with the right permissions with partners, vendors and customers? (Data Federation)
  • Having an Enterprise Strategy for managing our data more cost effectively? (Data Governance)
  • Managing the growing volume of historical data? (Information Life Cycle Management)

For almost 20 years, our staff has worked with client data in all of these situations.  Even before the acronyms and buzzwords, we were providing organizations with solutions to help them better manage their critical data to grow their businesses and reduce costs.

With that in mind we have now strategically partnered with Informatica to extend our capabilities.  (Ironically, we have leverage Informatica in the past to implement solutions but never taken the next step to partner with them…)

We are excited about this because Informatica helps us better serve our clients who want to get the most from their data and control costs.  Companies spend more than they realize managing their data (or suffering from the lack of data management) and their are great solutions to remedy that.

Informatica is laser-focused on Data Management and all of its complexities.  Regardless of where your data resides, they help streamline the discovery, assessment, cleanup, organization and distribution of your information using the KISS principle.

In my next few posts I’ll review the data management challenges, listed above, along with how SSG can address them more effectively with Informatica solutions.

No Comments »

 

Oracle APEX and BI Publisher

August 9th, 2010 by Robert McMillen • 2 Comments »

I recently worked on a project that involved an Oracle APEX application.  If you aren’t familiar with APEX, it’s  a database-centric rapid application development product that is included with the Oracle 10g and 11g databases.   Using APEX you can generate web-based applications, interact with database tables/views, leverage PL/SQL stored procedures and even integrate it with Oracle BI Publisher.  BI Publisher is an easy-to-use report generation product.

One of our requirements was to generate reports from the application in a PDF format.  I looked at several options and decided for the moment that Oracle BI Publisher was the fastest and simplest solution.  Fortunately the client was happy with that as well.

What I found out was that generating a report from APEX and having it printed as a PDF via BI Publisher is a very elegant solution.  Beyond installing BI Publisher on a server, the following steps were what I need to do.  BTW, we installed BI Publisher in both the windows and Linux environments with no issues.

We had an existing application screen and wanted to generate the PDF using the same underlying SQL queries.  First I logged into the APEX application, went to SHARED COMPONENTS and defined multiple SQL select statements using the REPORT QUERIES option.  I was able to reference some existing session variables to customize the SELECT statements.  In APEX I was able to define a REPORT LAYOUT template under the SHARED COMPONENTS.  Then I downloaded the BI Publisher plug-in for Microsoft Word 2007 and created a report template.  There’s more detail in that process than I can cover here, but it didn’t take long for me to learn how to create more and more complex templates.

I was then able to upload the template to APEX (and download it later for editing).  Since the templates are MS Word documents, it’s pretty straight-forward.

Back in APEX I modified the logic on one of the application web pages to add a button.  This button was linked to a BRANCH statement which called BI Publisher and generated the PDF Report.  Within a few seconds my browser had a download of the PDF file which I could open and browse!

Within several weeks we had created about a dozen reports, each with 5 or 6 SQL queries.  Some executed directly out APEX and others were scheduled to run directly from BI Publisher on an automated schedule.  If you want to learn more about the link between APEX and BI Publisher, here are some examples.  Happy Report Writing!

Defining a PDF Report in APEX

2 Comments »

 

OBIEE Hands On Workshop

April 19th, 2010 by Steve Steinheimer • No Comments »

I am learning how to create many of the visualizations available with the Oracle Answers product – a component of OBIEE.  During the workshop I created several charts, reports, pivot tables and even a ticker.   For my first time playing with the OBIEE front end tools I found them very intuitive and fun to use.

No Comments »

 

Oracle Golden Gate and BI

November 10th, 2009 by Paul Scott • 1 Comment »

With Oracle’s acquisition of Golden Gate Software in July, yet another integration offering is available. Golden Gate’s strength (and why it garnered Oracle’s attention) lies in its ability to move transactional data between heterogeneous databases with sub-second latency, transaction integrity, and minimal overhead.  Although Oracle says Streams will continue to be supported, Golden Gate is the strategic direction for real-time integration.

So for Business Intelligence systems, what does this mean?  Historically, data warehouse applications have attempted to answer the question “what happened?”, “why did it happen?” or “what will happen?”.  These are reporting, analytical and predictive type applications.  However, companies want their data warehouse systems to become part of their operational decision making.  They need to answer “what is happening?” — reacting immediately to a change in business.  This is where Golden Gate shines.  Whereas, Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI) are better suited for batch-oriented ETL, Golden Gate offers real-time (or near real-time) integration of data and can perform basic transformations.  For more advanced transformation needs, Golden Gate can augment ODI allowing Golden Gate to perform the real-time extraction and ODI performing the transformations and loading.

More info on Golden Gate may be found at http://www.oracle.com/goldengate.

1 Comment »

 

Fusion Applications Version 1 Discussed by Larry Ellison

October 14th, 2009 by Robert McMillen • No Comments »

This afternoon, Larry Ellison lifted the curtain providing more information about the Fusion Applications.

For several years Oracle has mentioned its plans to introduce this completely new applications suite.  Today, Ellison said that Version 1 of Fusion Application will include the following functionality:

  • Financial Management
  • Human Capital Mgmt
  • Sales and Marketing
  • Supply Chain Management
  • Project Portfolio Management
  • Procurement Management
  • Governance, Risk and Compliance

Version 1 of Fusion is now in the test phase with Oracle customers.  It is described as being SAAS ready, based on Service Oriented Architecture, using embedded Business Intelligence and based on industry-standard Java and Middleware.  One slide he showed indicated that the first version has over 6000 tables, 6500 objects, 18,000 views, 1215 services, and 2500 application modules.

Fusion is designed to support management by exception by providing:

  • What do you need to know using Business Status
  • What do you need to do with Action and Task Lists
  • How to do it with Task Flows
  • Who do you need to Contact will Collaboration

Final comments by Ellison indicated that Version 1 of Fusion Applications will be released in 2010.

No Comments »

 

BRM and True Business Intelligence

October 12th, 2009 by Robert McMillen • No Comments »

Last night I got a preview of a new BI product that Oracle is delivering early next year.

For those customers using Oracle’s Communication Billing and Revenue Management software this is definitely one product to consider.

The demonstration showed how one can build a robust data warehouse with BRM data (including CDR information) and then use over 120 sample reports to analyze the information.

The example we saw analyzed subscriber account churn.  At each level of analysis the software provided a suggested next step.  This “guided” analysis was very good.  Within several minutes we were able to drill down using raw data and chart graphics to the primary reason for the highest level of churn.  The root cause was a high level of dropped calls from several cell towers.

I came away very impressed with this soon-to-be announced product which uses Oracle Business Intelligence Enterprise Edition (OBIEE).

SSG will stay in the loop on this and provide an update again in several months as more information is provided.

No Comments »

 

Oracle OpenWorld Updates Start Sunday

October 7th, 2009 by Robert McMillen • No Comments »

This Sunday, Oracle OpenWorld will be kicking off in San Francisco.  Five of us will be attending from SSG and several of us will be providing udpates via our blog.  The event will continue through Thursday afternoon at the Moscone Center.

The five of us will be focusing on the general sessions and attending dozens of presentations on Service Oriented Architecture, Business Intelligence, Communications Billing and Revenue Management, and Business Process Management.

This year I’m hoping to include more pictures in the blog, so I encourage you to subscribe and get our updates from each day of the conference.

As a preview, Sunday we will be attending several Special Interest Groups (SIG’s) and the Oracle Partners Network meeting.

No Comments »

 

Business Intelligence

January 23rd, 2009 by Jennifer Vilches • No Comments »

It’s practically impossible to make sound business decisions without access to quality, up-to-date data. In the past decade, Business Intelligence (BI) has become more and more important for companies of all sizes as they search for ways to increase their competitiveness.

Access to your data and the Oracle BI suite are all you need to set up one-stop report shopping.
  • Executive-level dashboards? Check.
  • Detailed template-driven reports? Check.
  • Ad-hoc report analysis? Check.

So how does Oracle manage these feats of reporting? The BI server manages three layers of metadata. The first is the physical location of your data. The second is a simplified logical model built on top of the physical layer. The third is the presentation to the end user. Building a sound logical model allows all users to play by the same business rules – no more wondering if marketing is looking at the same calculations as accounting.

The Oracle BI Suite (Standard Edition One) includes three major elements:
The Oracle BI Server manages a consistent view of all your data, whether it resides in an Oracle database or not. This is a powerful tool to use to model your data into easy-to-use groupings.
Answers is the place to go for ad-hoc reporting and analysis. Drag and drop to create reports or graphs that you can then add to a Dashboard. Answers does not require technical skills to use; it’s a great way for business users to access their data. Access to Answers and the Dashboards is all web-based, so there’s no special client tool to install.
If you’re looking for highly formatted reports or documents, BI Publisher will meet those needs. Even the most complex files can be created starting with templates built in Microsoft Office tools.
The Oracle BI Suite is an easy-to-use, scalable way to get reliable answers about your data.

No Comments »