Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a client that has about 10 staff. They want to add business intelligence services to an existing MySql 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, they 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 trialing. It feels more like a mid-sized one than a smaller end one so I'm wondering if anyone knows of any alternatives.

share|improve this question

closed as off-topic by Paul White Apr 21 at 10:13

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White
If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 3 down vote accepted

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. 2016 Update Logi no longer issues a free version. The paid version now has dashboard and analytic tools.

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 client's 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.
share|improve this answer

If you cannot use Microsoft SSAS I would recommend looking at Pentaho:

http://mondrian.pentaho.com/

share|improve this answer
2  
You should add some detail about what makes Pentaho a compelling system. Just in case, if you have any affiliation with Pentaho, you should not that too. – Max Vernon Nov 9 '13 at 15:37

Not the answer you're looking for? Browse other questions tagged or ask your own question.