OLAP Cube Database - need a to find a consultant / alternative to cognos express

Question

I have a client that has about 10 staff. They want to add business intelligence services to an existing mysql relational database.

It is a database containing purchasing and readership data for publications over the past 30+ years. They are an Audit Bureau and thus on a yearly basis audit the numbers that publishers report so that these numbers are they sent to advertisers and can be used to justify the cost of Ads in their publications.

I need a small to mid sized OLAP cube option. Cognos Express is the first one i'm trialling. It feels more like a mid sized one than a smaller end one so i'm wondering if anyone knows of any alternatives.

I am in sydney australia, but happy to have suggestions from anywhere in the world as long as we can communicate.

thanks

Answer 1

I have deployed Logi Reports at a client and the free version is just fine for the users where I am. You can pay for the upgraded version which offers OLAP-like abilities.

This product was mentioned in another post iccube as a free OLAP but I have not used it. It looks to me like it tries to emulate the built in features that Oracle has on a Java platform.

You don't mention the infrastructure or technical skills of the client. These are important considerations. A tool that is "too complicated" will only results in calls to you to dumb it down.

The features I recommend considering are: how many brands of database can it connect to? Does it work with the versions you have? How easy is to configure access and permissions with the clients infrastructure? Active Directory is a standard for many places and should be an option. How fast is the rendering engine or how much patience does your client have to wait for results? (Of course database structure has a much bigger effect on performance than the reporting engine) Do you want a product with wizards that make it easy to deploy reports? Can you craft a query in SQL and then drop it into the report? This is incredibly handy for testing and development.