• All
  • Advanced Analytics
  • Amazon
  • Big Data
  • ClearPeaks
  • Cloud
  • Cloudera
  • Enterprise BI
  • ETL
  • Executive Analytics
  • Informatica
  • Microsoft
  • Oracle
  • Qlik
  • 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

OverviewAs I mentioned in the part one of this article Configuring OC4J Applications (i.e. BI Publisher) to work in Single Sign-On (SSO) Environment on IIS,  we may need to use applications like BI Publisher on web application servers other than OC4J.In this scenario we will see how to set up BI Publisher with Windows Native Authentication for Internet Information Services (IIS).The way to make BI Publisher work in the SSO environment shown in this document is only one of the multiple possible solutions. Other deployment options (including for example SSO cookie or Oracle Application Server integration) can be implemented but considering your client infrustructure (i.e. IIS used all over) the Oracle Proxy integration may be the only choice.
Last week, ClearPeaks held their Academy training session on Oracle BI EE 10g in Mauritius. The attendees, which included XXXX,  were trained by, Lluis Ruiz, a Senior Consultant at ClearPeaks bringing with him years of hands-on knowledge and experience.
The attendees not only learned about the theory of the Oracle technology, XXXX. Overall the feedback was XXX.
This month our upcoming training sessions will be held in Moscow, Russia on advanced OBI EE 11g technology. Have a look at our course calendar including our seminars on OBI EE 11g & our special promotion offering and book your training today.
Last week, ClearPeaks held their Academy training session on Oracle BIEE 10g in Nigeria. The attendees, which included database developers, project managers and some EBS implementors,  were trained by, Lluis Ruiz, a Senior Consultant at ClearPeaks bringing with him years of hands-on knowledge and experience.
Take a look into the ClearPeaks first Newsletters about industry news, events, video tutorials and other information regarding the Business Intelligence world.Our Newsletters are segmented to your specific industry, giving you insight and knowledge to your daily business functions. Find specific articles regarding Oracle BI EE, tips & tricks on 11g, upcoming UKOUG, Oracle and Academy events.If you haven't received a Newsletter, or you wish to read about other industry verticals, you can find the links to each below.Please feel free to send us comments, thoughts, questions etc. You can submit your thoughts here.We look forward to hearing from you!