Misleading Statistics in Internal Developer OBIEE

Brian BurdiTechnical TipsLeave a Comment

Misleading Statistics in Internal Developer OBIEE

Today, we are going to look at the demo standard deviation charts that come with the internal developer VM OBIEE 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 to Excel 2007+

Brian BurdiTechnical Tips2 Comments

Exporting Negative Numbers from OBIEE to Excel 2007+

If you’re trying to export numeric values in OBIEE 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

john.kingTechnical Tips8 Comments

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

AshokIndustry Trends, Technical Tips1 Comment

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.