• 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
Sometimes because of the nature of the data in our system we need to have different types of aggregations (sum, max, last…) for one single measure. Therefore the aggregation type needs to be different depending on the dimensions (Date, Product…). One clear example of this is in dealing with stocks. Stocks have different kinds of aggregations depending on how you look at it. The aim of this article is to know how to deal with these different aggregation level measures and implementing a solution in the OBI repository to solve the issues that those measures bring.

18 July, 2011
Dynamically changing the information displayed in a dashboard should be one major objective for the developers. This flexibility reduces the number of requests to be developed and increases the user experience. A common way of achieving this flexibility is by using the Column Selector view. This view allows the user to select a subject area column dynamically and to get results based on that selection (e.g. Revenue by Year/Region/Product). The Challenge Unfortunately, using the Column Selector view has some limitation. An important one is that every time a new subject column is selected, a new query is executed to refresh the data. So in the case that we need to change multiple columns, we will be executing multiple intermediate useless queries. In this blog article we will show a way of simulating the Column Selector view when we need to change multiple columns in a report. The Scenario The requirement is to be able to switch between two reports that differ only in some columns (in this case, a set of measures). The user does not want to have them in separate Dashboard Pages but in one single dashboard page, displaying one report or the other based on a “Measure Selector”.
31 May, 2011
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
It is not unusual to find that default ports in software applications are already used or blocked in the firewall. OBIEE 11g ports are not an exception. Knowing this, WebLogic (the application server used in OBIEE 11g) allows the administrator to change the port of the WebLogic servers. This white paper is going to guide you step by step in order to achieve this objective. We are going to change the default port for the WebLogic Managed Server bi_server1 from the original 9704 to 8765 (any other port could be used).
13 April, 2011
Starting & stopping the OBIEE 11g Domain on a Windows platform is very simple thanks to the shortcuts created during the installation. However, on a Linux platform this becomes a bit more tedious as there are no scripts for that.

In this article you will find the scripts needed to start & stop the OBIEE 11g Domain.

Note 1: In the scripts listed below, make sure you replace “$OBIEE11g_MW_HOME” with the Middleware Home folder specified during installation (e.g. “/OBIEE11g”).

Note 2: Also replace “<OBIEE_11g_server>” with the IP of the server where OBIEE 11g has been installed.
08 April, 2011
This week we held webinar sessions about OBIEE 11g New Features in User Interface. Overall the attendees feedback was very positive, attendees were thrilled to learn more insight into the new features of OBIEE 11g and will attend the upcoming webinar series to learn more, others requested to learn more about specific topics in line with the new 11g technology. If you were unable to attend our webinar on OBIEE 11g New Features in User Interface, have a look at the presentation or if you prefer to see the webinar online no problem, we have recorded our session for you to watch at your convenience. See the Video Post

Webinar | OBIEE 11g New Features in User Interface

08 April, 2011
Show more
Loading new posts...
No more posts