I'm not very familiar with the world of OLAP. Nevertheless, I suspect
that some of my current projects might benefit from the right OLAP
product. I'd like to describe my needs and see if anyone can suggest a
product for me.
First of all, I need a simple OLAP re****ting tool -- something which
links to a data source, offers an easy user interface for defining
re****ts, and generates tables that can be copied or saved. Something
like Excel's pivot table feature, only better.
Note that I am not looking for a "Business Intelligence" Suite. From
what I've seen, most OLAP products are all about dashboards charts and
metrics and fancy stuff like that. Hyperion and Cognos and Analysis
Services may have basic re****ting tools, but if they do, they are
buried deep within enterprise software which I can't afford and don't
want. I just want an app that focuses on slicing and dicing a cube,
and that's all.
Second, I need an Excel add-in that lets me pull aggregate data out of
my cube and put it into a spreadsheet. Specifically, I need to sum,
count, and average over any subset of the cube. I also need to find
values corresponding to given percentiles (e.g. find a median). Again,
I don't want some huge software package. I just need a simple, thin,
add-in that I can train someone to use.
Any suggestions?
-TC
|
