Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
The Oracle/Hyperion EPM System 9x or 11x is crazy robust due to its suite offerings. However, as any administratoro will tell you it is highly dependent on the correct start and stop order of its windows services. The database has to be up before shared services and OpenLDap then workspace can be started, blah, blah, […]
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). [simage=16,200,y,center]
Oracle has just published a new Sample Sales Analysis RPD with supporting data files for OBIEE. This OBIEE RPD example should be a great additional demo for any OBIEE professional to demo to clients and learn some techniques. http://download.oracle.com/technology/products/bi/files/oracle_bi_sample_analysis_setup_files.zip This is from Oracle and link comes thanks to John Minkjan our Netherlands native OBIEE guru. I […]
Microsoft usually has good documentation but on this particular topic I always felt that it was lacking. Here is the MS core documentation for converting a decimal to a string, http://msdn.microsoft.com/en-us/library/59095yyw.aspx. I recently needed to ensure that I was only getting only two decimal places on a dollar amount as I converted it into a […]
It turns out this error is caused when TCP/IP to the SQL Server server instance has been disabled. It is actually disabled by default. Below are the steps to resolve the issue.
We steadily brand our client’s OBIEE portals with their logos, color schemes, etc. Usually this takes a tool like Photoshop to handle the graphics. However, I just came across a very sweet, free, photoshop-like web tool that anyone can use to edit photos and even create graphics and color schemes with. The group is called […]
Using the subsonic project ORM for .NET clearly has tons of benefits for DAL and BLL purposes. A great way to get a list of records from the db is to use the collection object which is created for tables and view objects from the db. Here are two examples of how to use the […]
I am about to show you a great sql trick that only a few SQL Server T-SQL masters actually know. It will save you a decent amount of coding and make you the envy of your Sql Server colleagues. Even in the Microsoft documentation on the CASE statement does not list that the CASE … WHEN…THEN…END statement […]
Typically I haven’t bumped into this error in the past with OBIEE but the other day it smacked me in the face. Problem I was adding a SQL Server 2005 datamart to my Physical layer and didn’t run the initial check to see that OBIEE could read the data in my view/table objects. Clearly it […]
This is just another post that I’ve been meaning to put up for a while but it just became relevant again on an OBIEE project I am working on. In Essbase I am generally a fan of loading data in using Parent/Child builds rules but as we know with OBIEE when looking at the relational […]