• All
  • Advanced Analytics
  • Amazon
  • Big Data
  • ClearPeaks
  • Cloud
  • Cloudera
  • Enterprise BI
  • ETL
  • Executive Analytics
  • Informatica
  • Microsoft
  • Oracle
  • Qlik
  • Tableau
  • Visualizations
  • Web & Mobile BI Development
Save the date for the key annual Partner event here in Europe to get the latest from Oracle Strategy and industry experts to propel your business growth in Business Intelligence and Enterprise Performance Management. The event will take place on the 21st - 24th June 2011, at the Dolce Hotel & Resorts in Sitges (near Barcelona) Spain.This year ClearPeaks will have the honor to present at the Partner Community Forum about "Working with Oracle, a BI partner's perspective". This presentation will answer the following; What does a partner look for from Oracle? What is good today and where could we improve in helping both Oracle and the partner to achieve our goals.

Oracle

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