Oracle Advanced Analytics

March 29th, 2012. Isabel

In February of this year Oracle launched Oracle Advanced Analytics, a new option for Oracle Database 11g that extends the database into a platform for big data business analytics. Oracle Advanced Analytics packages Oracle R Enterprise (ORE) with Oracle Data Mining (ODM), providing the capability to sort predictive analysis, statistical computing and interactive graphics inside the database.

With Oracle Advanced Analytics option, analytical capabilities are accessible through SQL and R programming languages. ODM provides predictive algorithms that run as SQL functions. ORE extends the database´s analytical capabilities using R’s statistical functionality library.

ODM is an existing option of Oracle Database that allows using predictive data models in the database; but how Oracle R Enterprise contributes to Oracle exactly? How is it integrated in Analytics? Which are the benefits of this integration? 

  Continue reading this post >

Posted under Data Warehousing, Oracle BI EE 11g
3 Comments
  • Share with others:
  •  
  • Digg
  • Delicious
  • Facebook
  • Mixx
  • Google Bookmarks

MS Excel spreadsheets as a data source in Informatica PowerCenter

January 18th, 2012. Isabel

Informatica Power Center can use different sources of data. The most common sources are tables, views or synonyms, but for storing small sets of data, companies usually use flat files, MS Excel files or MS Access. Informatica treat Excel and Access file sources as a relational database, not as a flat file.

 Which steps do we have to follow to load this data from these files to our Data Warehouse? How are the connections created? Where do these files have to be located? How should we configure Informatica?

 In this article I will explain the way to load data from Excel files using Informatica Power Center running on Windows.

  Continue reading this post >

Posted under ETL
7 Comments
  • Share with others:
  •  
  • Digg
  • Delicious
  • Facebook
  • Mixx
  • Google Bookmarks

OBI Tables tips & tricks: Hard Coding Zero Values and Combined Request Reports

May 9th, 2011. Isabel
One of the most frequent requirements from reports in tabular form (Pivot Tables or normal Tables) is to show all possible values of a specific dimension and its related metrics.
But how to show all values if for some of them there are no data?
Being based on a SQL query, it is obvious that an OBI report shows dimension values that have information in fact tables, skipping values without any data.
For example, a Marketing report showing the number of Campaigns launched per Quarter will only display quarters having at least one campaign executed. If a quarter doesn’t have information about the report metric, the quarter will be skipped and will not appear in the end report. In this example (Figure 1), there are no campaigns launched in quarter 2 and 4.

One of the most frequent requirements from reports in tabular form (Pivot Tables or normal Tables) is to show all possible values of a specific dimension and its related metrics.

But how can you show all values if for some of them there is no data?

Based on a SQL query, it is obvious that an OBI report shows dimension values that have information in fact tables, skipping values without any data.

For example, a Marketing report showing the number of Campaigns launched per Quarter will only display quarters having at least one campaign executed. If a quarter doesn’t have information about the report metric, the quarter will be skipped and will not appear in the end report. In this example (Figure 1), there are no campaigns launched in quarter 2 and 4.

1

Figure 1 – Normal Report

Continue reading this post >

Posted under Oracle BI EE
4 Comments
  • Share with others:
  •  
  • Digg
  • Delicious
  • Facebook
  • Mixx
  • Google Bookmarks

LINKAGE SIEBEL WITH ANALYTICS: Action Links

November 8th, 2010. Isabel

The purpose of this article is to indicate a way to provide a link for end users to navigate from their analytic dashboards to a record in the Siebel operational application.

As an operational example, consider the Opportunities report in Fig.1. The requirement is to navigate from this report to a specific Siebel Opportunities view. We want to include a new column in the report (see the red rectangle in Figure 1) with a button allowing to navigate directly to the specific Opportunity view in Siebel (Figure 2). The tool that enables the navigation is called Action Links.

Continue reading this post >

Posted under Oracle BI EE
5 Comments
  • Share with others:
  •  
  • Digg
  • Delicious
  • Facebook
  • Mixx
  • Google Bookmarks

“Maximum total number of cells in Pivot Table exceeded” error

June 4th, 2010. Isabel

Pivot Tables are a great feature of Oracle BI. It is arguably one of the most used views when designing reports, and offers immediate hindsight on data with drilldown capabilities on both rows and columns.
Such intelligence power comes with a few limitations though.
Pivot Tables aren’t made to visualise large amounts of data (data dumps are best managed through normal tables or even better, direct download to Excel/flat files).

Continue reading this post >

Posted under Oracle BI EE
No Comments
  • Share with others:
  •  
  • Digg
  • Delicious
  • Facebook
  • Mixx
  • Google Bookmarks

privacy policy - Copyright © 2000-2010 ClearPeaks

topnav