February 22nd, 2012.
Sergi
Some of us have faced several times the lack of out-of-the-box features for meeting the customer requirements or needs.
One of them I found out early this month was about creating a 100% stacked bar graph. This representation of the data displays the results of multiple queries stacked one on top of the other, either vertically or horizontally in a range of 100%. Using a 100% stacked bar graph is a way to present the absolute values of data points represented by the segments of each bar. From the Oracle’s default graph’s list in Analytics you won’t be able to find this option, but doesn’t mean that we cannot reach this requirement and we will see how, in the following text.
Find below the steps to get a 100% stack bar chart with Oracle Business Intelligence 11g using as environment the sample application provided by Oracle, SampleApp.
Continue reading this post >
November 28th, 2011.
Sergi
Some Oracle Application like BI Publisher 10g uses OC4J, which is an Oracle Application Server which enables J2EE applications to run. These set of containers, API and services have to be started manually at system start up and after system downtime.
It is annoying for system administrators to have manual task to take care of. So, if we are in a Windows environment, these tasks can be avoided if they are defined as an automatic start-up process within the MS Windows Service.
Installing OC4J as a MS Windows Services we will solve that inconvenience we will take a step further in automation wise and we will decrease the services downtimes.
Continue reading this post >
July 26th, 2011.
Sergi
The full topic of this article is a two part post, which will be divided into a theoretical post and a practical video post; today I will give you the theoretical overview on applying security in an OBIEE 11g domain. One of the main concerns partners, developers and administrators have with the new Oracle Business Intelligence (OBI) platform is how to keep confidential data safe and grant users specific permissions.
Continue reading this post >
January 21st, 2011.
Sergi
ClearPeaks Video Tutorial
In any organisation, common information can be interesting to multiple users. However, the way this information wants to be seen by different users may differ substantially. Oracle BI supports multiple visualization options by offering a wide range of views. With them, a report can be displayed as a table, chart, pivot table, etc.
In some other cases, the chosen view may be the same, but the measures precision may be different depending on the user visualization of the information. For instance, the organisation's CEO would be interested in a figure representing millions, whereas the financial department would be interested in the same figure displayed in full value, including cents.
In this article we will see how we can create an easy solution in Oracle BI, allowing the user to customize the measures precision (real value, thousands or millions) in a dashboard.
November 22nd, 2010.
Sergi
Despite globalisation, we still live in a multicultural world. It is very important to take this into account as some of the data to be analysed may be dependent on the period of the year it was generated. Not taking these outside factors into account could lead to wrong conclusions for an organisation and therefore bad decisions could be taken.
In this article we will see an example of how important it is to analyse the data based on its’ cultural environment and will present a technical solution to achieve that.
