Tuesday, May 25, 2010

The Great Shift-Space bug in OBIEE (Oracle Business Intelligence Enterprise Edition)

Very interesting OBIEE (Oracle Business Intelligence Enterprise Edition) Bug. This might happen to you may be one out of 1,000,000.

I have the following report (Picture A)


(Picture A)


This is bringing the following result (Picture B)


(Picture B)


This is the right result I am looking for. Now I decided to remove the hyphen after the shift title (Picture C)


(Picture C)


I have done the following changes (Replaced hyphen with space) in the Edit Column Formula (Picture D)


(Picture D)


What result I get is after this changes is as follows (Picture E)


(Picture E)

Look at the changes in the values!

These changes happen when I replace a “-“ with “Space”

I have done another analysis of this value in the excel (Picture F)



(Picture F)

The space means 58-60% deduction of the original value.

I called this “The Great Shift-Space bug in OBIEE”

Could anyone help me to know why this is happening?