Blog

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.

Art of BI: Installing Hyperion System 11 – Part 2

We are using this exercise to compare two documents that bubbled up last year by Oracle and Applied Olap to see which one was worthy of your time.

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.

Art of BI: Installing Hyperion System 11 – Part 1

The idea here is to get a nice single server instance of the EPM suite up with the core Shared Services, EPM, Essbase, and Planning.

What should I check after bouncing E-Business Suite?

As an Oracle Apps administrator, it’s a good idea to have a punch list of things to check after your applications have been started, to ensure all services are working correctly.

Art of BI: Transferring SQL Server Logins Across Server Instances

A while back I was working with a client on a web application project that had a basic SQL Server database as the relational data storage system.

FNDCPASS doesn’t always use the SYSTEM password

FNDCPASS does not check the system password when used to change an application’s user account. We can check this with a simple test.

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.

Why should I properly close my Oracle E-Business Suite session?

Your E-Business Suite session is idle, and in your haste you simply click the ‘X’ at the top of your browser. You know it’s not the proper thing to do, but you’re not sure of the implications.

When is remote DBA the right solution?

A remote DBA service can provide access to experts in performance tuning, backup and recovery, replication, or a host of other database focus areas for a fraction of the cost.

ORA-04031 and ASMM

Oracle E-Business Suite customer was reporting ORA-04031 errors being returned by the database.

Using Checksums to Ensure Table Consistency in MySQL

If you’re using MySQL replication, chances are your master and slave databases aren’t entirely consistent. There are a number of reasons for this. Some MySQL functions like UUID() don’t replicate properly with statement-based replication.