Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
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 […]
Searching through my favorites today I found my all time favorite BI demo video. This is the best video I have come across on the web that explains in lay how BI, Distributed Reporting, and Data Warehousing assist an organization. http://smartbi.hyperion.com/ It’s really brilliant how they put together this page to be insightful and interactive. […]
In continuation with VM Image installation of Hyperion 11x I decided to stand-up a Windows Server 2008 Hyperion 11x image with just the basic Foundation Services and Essbase as outlined in AppliedOLAP’s Hyperion 11x Installation guide. I bumped into a problem in the way that the Hyperion install, specifically foundation services references the network. In […]