Hello
I have a poorly structured, poorly featured application based on Excel .
I need a a more sophisticated database back-end that is streamlined for
my application and viable for the long term. Somebody suggested
what I need is an OLAP database with an Excel front end.

Here's an outline on what I am trying to do. Much appreciate any
suggestions what approach/platforms I might consider. Are there any
recommended books to help me architect a Cube based solution to fit my
needs.

The application involves lots of time stamped data that is statistically
driven and searched for time-series relationships via User interface
Currently the data is stored in hundreds of Excel workbooks

Each Parameter (Excel column) has five headers (Floor.Room.Shelf.Book..
hierarchical concept). These headers are meaningful to the User as she
specifies them and uses them in equations to derive more new
statistics down new columns, as well as referr to them for querying
relationships.Queries like: Sort the values of parameter X (from Start
date to Stop date) to into ten bins (e.g. histogram) and store them For
all the values of X that fall in Bin1 find the corresponding values (by
date) for parameters Y and Z. Plot time-series charts/query results

Appreciate any suggestions on where to start (resource material), what
OLAP architect/ platforms to consider, Excel add-ins to front-end OLAP

Thanks
Kurb

HI Kurb:

Let me suggest you
http://www.amazon.com/exec/obidos/tg...587323-3216163

This is a great beginning

Sincerely


--
Alejandro Leguizamo
MVP SQL Server
Colombia


"kurb" <mompara (AT) sympatico (DOT) ca> wrote