Blog

Art of BI: OBIEE Logging Security Restrictions and Levels

OBIEE has a smart query logging system and it happens to be mainly based on security logging levels.

Art of BI: Hyperion OpenLDAP and Shared Services Won’t Start – Error 1068

The Oracle/Hyperion EPM System 9x or 11x is crazy robust due to its suite offerings.

Art of BI: OBIEE and Google Maps Integration Browser Warning

After the first post on Google Maps integration with OBIEE we found that things worked swimmingly with Firefox but a very annoying looking error message was being produced with Internet Explorer(IE).

Art of BI: OBIEE RPD Demo – Sample Sales Analysis – Part 1

This OBIEE RPD example should be a great additional demo for any OBIEE professional to demo to clients and learn some techniques.

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.