• All
  • Advanced Analytics
  • AI & LLM
  • Amazon
  • Big Data & Cloud
  • ClearPeaks
  • Cloudera
  • CoolThoughts
  • Data Governance
  • Enterprise BI
  • ETL
  • Executive Analytics
  • Google
  • Informatica
  • KNIME
  • Microsoft
  • Observation Deck
  • Oracle
  • Qlik
  • Snowflake
  • Tableau
  • Visualizations
  • Web & Mobile BI Development
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

09 May, 2011
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.
08 November, 2010
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).
04 June, 2010
Loading new posts...
No more posts