FACT Dimension

[surinder]

Hi All,

I am working as a Cognos Developer ,as i am new to this ..i am working hard.Could u pls help me out.for creating cubes and understanding...
1.What is fact
2.Dimensions (I know but not practically)
3.Hirercy
4.Business role
5 level.
6Complete formation of cubes.
7. Relationshhip between fact and dimension.

As this all definition i am having..Could someone really help me out in this .As all the help files are with ,me.but i want real time knowledge ..Pls help me my friends..Thanks to all ...happy new year....

[blom0344]

You would be well served with a general book on OLAP modelling. These will take you through the basics , though they will not be Cognos specific.

Example:

OLAP Solutions: Building Multidimensional Information Systems
By Erik Thomsen
Edition: 2, illustrated, revised
John Wiley and Sons, 2002
ISBN 0471400300, 9780471400301

link:

http://www.amazon.com/OLAP-Solutions-Building-Multidimensional-Information/dp/0471149314

Money well spend!!