Dimensional Model,cubes etc

[juffin]

Dimensional Model and cubes
I am confused with dimensional models,relational models,cubes..

In framework manager I developed a model which has fact and many dimensions(star schema). If I generate a list report which has many dimensions would that be a multi dimensional model ? If so what is a cube then? are they both multi dimensional ? Is it not possible to generate cubes in framework manager than cognos power play ?
Thanks in advance for any help
Jf

[MFGF]

Hi,

When we refer to dimensional models and relational models and packages in Cognos 10, we are really asking whether:

1. The data is physically stored in an OLAP cube such as a PowerCube / MSAS cube / TM1 cube / Dynamic cube etc or has been modelled in Framework Manager as Regular Dimension and Measure Dimension objects to emulate an OLAP cube. All of these would produce packages with dimensions and hierarchies and a member-based view of the data would be visible in the package tree. This is a Dimensional package.
or
2. The data is in a database/filesystem and is represented as Query Subjects and Query Items in your package. This is a Relational package. Even if the underlying tables are fact and dimension tables, if they are represented as Query Subjects and Query Items we view this as a Relational package.

The term "DMR" is used in Framework Manager when you model relational data to make it look and behave like an OLAP cube. DMR stands for Dimensionally Modeled Relational data. If you have added Regular Dimensions and Measure DImensions into your model and published them into your package, your data will behave like it is stored in an OLAP cube.

Cheers!

MF.

[juffin]

Thank you very much MFGF..that cleared my query!