June 30, 2009

Avoid Non-numeric facts!

Yes, I’ve done this mistake more than once, usually unwilfully. Using varchar columns in fact table. Everyone knows that using anything but numeric facts is a […]
June 30, 2009

Date dimension in BI Apps 7.9.5 is not checked to be Time dimension. Do you know if there is any particular reason why it is so?

I found an answer to something that bothered me for a while. In setting up a Time dimension, there are requirement of the physical Tables that […]
June 23, 2009

Nominate your Organization for Oracle BI & EPM Excellence

It’s Tuesday, and there was a big tragedy in DC that everyone knows about. I ride on Red Line every day  – and now I’m starting […]
June 18, 2009

Direct Database Request in OBIEE using Essbase causes [nQSError: 46008] Internal error

Direct Database Request in OBIEE using Essbase causes [nQSError: 46008] Internal error: File .\Src\SQXDGEssbaseCAPI.cpp, line 1003. (HY000) Applies to: Business Intelligence Answers Option – Version: 10.1.3.2.1 […]