The combination of all business data with location-related data offers a new view on expectations and opportunities for organisations. The continuous growth and sophistication of geographical services allow users to incorporate spatial information into a Business Intelligence solution and use it as a basis for better decision making and providing higher value services. Location intelligence offers organisations opportunities to streamline their business processes and customer relationships to improve performance and results.
Oracle BI Mobile App Release & Demo Showcase
July 4th, 2011.Check out the new demos based on the recently released mobile capabilities in Oracle Business Intelligence 11g (11.1.1.5.0). This mobile app gives you the full range of BI functionality on the go!
These videos feature an overview of the capabilities in the Oracle mobile app.
· Oracle Financial Analytics Mobile Application Demo
· Oracle Business Intelligence Mobile Demo
You can get the software from Oracle Business Intelligence 11g Downloads
The Oracle BI Mobile app itself is available as a free download from Oracle Business Intelligence Mobile for iPhone, iPod touch, and iPad on the iTunes App Store
- Share with others:
-
-
-
-
-
Switching Between Two Reports within an Oracle BI Dashboard
May 31st, 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”.
- Share with others:
-
-
-
-
-
Webinar Video | Master Detail Linkage & Data Selection
May 31st, 2011.This past week we held webinar sessions about Master Detail Linkage & Data Selection in OBIEE 11g. Overall the attendees feedback was very positive as they were highly interested in learning about the new features of OBIEE 11g. Many had shared their interest in receiving more insight about specific topics in line with the new 11g technology and have already registered for our upcoming webinar session on Taking the action with OBIEE 11g: Navigating & Starting Business Processes.
If you were unable to attend our webinar on Master Detail Linkage & Data Selection in OBIEE 11g, we have recorded our session for you to watch at your convenience. See the Webinar Video Post
- Share with others:
-
-
-
-
-
OBI Tables tips & tricks: Hard Coding Zero Values and Combined Request Reports
May 9th, 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.
Figure 1 – Normal Report
- Share with others:
-
-
-
-
-
