Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category: All

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.

Christian Screen | July 7, 2009

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.

Christian Screen | July 4, 2009

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.

Christian Screen | July 1, 2009

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.

Christian Screen | June 28, 2009

Art of BI: Flatten Parent Child Vertical Table to Horizontal Generations

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.

Christian Screen | June 26, 2009

Hostname resolved to an IP Address – Windows 2008 Hyperion System 11 Installation Issue

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.

Christian Screen | May 27, 2009

Art of BI: Hyperion Foundation OpenLDAP service terminated with service-specific error 19 – Win Server 2008

After attempting to install the basic foundation services and Essbase server on a Windows Server 2003 box there were several failures when registering with Shared Services.

Christian Screen | May 26, 2009

Art of BI: Remote Desktop Connect to a VM Image

After we put together our Hyperion 11x VM Image I started thinking about how I wanted to use the new server environment for testing, etc.

Christian Screen | May 24, 2009

Art of BI: SQL Server – Truncate and Shrink Log File

Often when building a database, not all properties and settings are configured properly when initially created.

Christian Screen | May 22, 2009

Art of BI: Installing Hyperion System 11 – Part 2

I am delighted today to follow up on my first article regarding on installing Hyperion System 11x on a Windows Server 2003 Virtual Image (VMWare) of Hyperion System 11x. Just to recap, the purpose of this exercise is a “let’s see what will happen” approach to setting up a handy environment to pass on to colleagues […]

Christian Screen | May 20, 2009

Art of BI: Informatica PowerCenter 8 Video Tutorial

The below video(s) are from a tutorial on Informatica PowerCenter 8 that we did a few months back. This is now in its new formatted blog page.

Christian Screen | May 19, 2009

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS