Hi everyone... wanna know if it is possible for MOLAP to have ANY
relational tables (eg dimension tables) at all?

I would really appreciate any help at all on this.... (the answer to
this qn is life & death to me...)

Thank you!!!

I don't believe so.
MOLAP engines typically satisfy OLAP queries from
an extraction of data into a non-relational repository.
That repository would most likely be a proprietory
implementation of a C-ISAM structured file.
The MOLAP repository (eg Cognos PowerCube) is
periodically refreshed from relational source data.

Refer
http://searchdatabase.techtarget.com...882493,00.html

MichaelR


On 24 Sep 2003 01:43:42 -0700, bluealert999 (AT) yahoo (DOT) com (Mike) wrote:

NO, OLAP Cubes are non-relational multidimensionally mapped data
stores. However, one can:

1. Use drill down from a cell or tuple in a Cube to relational data
store. The Cube -- Cognos or MS Analysis Services -- issues
essentially a sql query to bring up a list of data underlying a cell.

2. One can use the "ROLAP" option in MS Analysis Services to look at
data in kind of a virtual or on the fly Cube sense.

What you give up is performance. Also, using ROLAP-y style toolsy
approaches uses more resources on the relational side as more tables
must be created -- see MicrosStrategy.

True OLAP, MOLAP Cubes, is very different from relational stuff, thank
The Multidimensional Multiverse!

YouveGotToBeKidding (AT) nowhere (DOT) com wrote in message news:<3f716b24.877221 (AT) news (DOT) bigpond.com>...

If you are using Analysis Services, then there are relational tables
(star or snowflake schema) that populate the cube.
But with MOLAP the leaf level data & the pre-calculated aggregations
are in the cube.
So end-user queries never touch the relational tables (drillthrough
being the exception).

I hope this means you can carry on living!

Regards,

John

www.johnkeeley.com


bluealert999 (AT) yahoo (DOT) com (Mike) wrote in message news:<6b6b866a.0309240043.40235c95 (AT) posting (DOT) google.com>...

Thanks for all your help....


duvinrouge (AT) servihoo (DOT) com (John Keeley) wrote in message news:<542fe31c.0309240848.3de1fbe8 (AT) posting (DOT) google.com>...