Re: looking for reading recommendations

EdStevens says...

> > > New project, and I need to come up to speed on 'dimensional modeling'
> > > and COGNOS. I know these aren't Oracle specific issues, but I figure
> > > several people here have enough experience in these areas to recommend
> > > some books.

> > he Data Warehouse Toolkit, 2nd Edition
> > Ralph Kimball, Margy Rosshttp://www.bookpool.com/sm/0471200247
> >
> > What part of Cognos do you need to know; How to build cubes,
> > dashboards?
> > I'd start by reading the Cognos manuals.
> >
> > Here's one of the best books I've seen on modeling... Old but good.http://portal.acm.org/citation.cfm?id=SERIES9818.176921&coll=GUIDE&dl...
>
> Thanks for the leads. At this point, I don't even know what it is
> that I need to know, so am looking for some foundational understanding
> of warehouses, cubes, ..... how all this differs from my 'normalized
> relational table' view of the world.

Be aware that Cognos (from v.8 ->, maybe some earlier) also has the capacity to use its internal modelling tool to transpose standard RDBMS E/R databases to a dimensionally modelled framework.

This is a significantly different approach to the creation of a true starschema  data warehouse to use for reporting through Cognos or any other OLAP-style toolkit.

Another good read is "OLAP Solutions - Building Multidemensional Information Systems" by Erik Thomsen.

GM Received on Tue Jul 24 2007 - 18:18:33 CDT