Today, we are going to look at the demo standard deviation charts that come with the internal developer VM OBIEE 11.1.1.6.2. We’ll look at several misleading statistics that are produced with this report and suggest ways to make the page more understandable for the user. Below is the page (1) that we will be investigating. (1) Standard Deviation Page Start with the upper left graph (2), it appears to be using confidence bands on the different factors. One can think of a confidence band as a continuous confidence interval for a linear model. This data is not continuous but consists … Read More
Exporting Negative Numbers from OBIEE 11.1.1.7.0 to Excel 2007+
If you’re trying to export numeric values in OBIEE 11.1.1.7.0 to Excel 2007+, you may notice there are issues when you attempt to sum a column that has negative numbers. This problem will occur if you have a negative number’s font color set to red. Excel 2007 disregards those values when directly exported whereas if you export to Excel 2003 you will not have this issue but will lose some of the formatting from OBIEE. Proposed is an easy solution to implement that will allow users to have useful data and not be limited to where they can export to. The Problem: … Read More
First and Last Day of Month – Oracle SQL Syntax Examples
First Day of Current Month 1 SELECT trunc(sysdate) – (to_number(to_char(sysdate,’DD’)) – 1) FROM dualselect trunc(sysdate) – (to_number(to_char(sysdate,’DD’)) – 1) from dual Last Day of Current Month 1 SELECT add_months(trunc(sysdate) – (to_number(to_char(sysdate,’DD’)) – 1), 1) -1 FROM dualselect add_months(trunc(sysdate) – (to_number(to_char(sysdate,’DD’)) – 1), 1) -1 from dual
OBIEE for the iPhone
We recently had a customer request help with configuring OBIEE for use on both PCs and mobile devices (specifically, the iPhone). Of course, this is possible, but Oracle does not have a clearly documented approach. You might think that a separate server is required to accomplish this. However, the fact is that you can actually use a single server to deliver OBIEE reports for both PCs and the iPhone. For those interested, following is a link to the Oracle OBIEE Indicators iPhone Demo: Please browse our OBIEE Consulting Services This article is part of the recent work short blurb series.