Blog

Art of BI: OBIEE and Google Maps Integration

Integrate Google Maps with OBIEE is really not that difficult when you know how. I recommend having some comfort level with general web development skills such as JavaScript and OOP but even that is not important when you’ve got a nice step-by-step guide like what I am showing here. There are many more caveats to this integration that I may not have had time to write, so comment to the post, and I’ll try to get back to your questions.

Art of BI: C# Convert Decimal to String

Microsoft usually has good documentation but on this particular topic, I always felt that it was lacking.

Art of BI: SQL Exception: The TCP/IP Connection to the host has failed.

It turns out this error is caused when TCP/IP to the SQL Server server instance has been disabled. Below are the steps to resolve the issue.

Art of BI: Simple SubSonic Project Collection Retrieve

Using the subsonic project ORM for .NET clearly has tons of benefits for DAL and BLL purposes.

Art of BI: SQL Server CASE IN() Statement Revealed- Who Knew?

I am about to show you a great sql trick that only a few SQL Server T-SQL masters actually know.

Art of BI: An error occurred while processing the EXECUTE PHYSICAL statement

Typically I haven’t bumped into this error in the past with OBIEE but the other day it smacked me in the face.

Art of BI: Integrate Essbase into OBIEE – Best Practices from Oracle

We’ve been doing quite a bit of Hyperion Essbase integration into Oracle BIEE lately. Most Oracle BI consulting groups will admit that this is all the rave right now.