Advantages of OLAP cubes over Data mining models

[Prasanna ()]

Hi friends

I am new to data warehouse concepts. After transforming the required data from the operational DB to data warehouse DB, can we use SQL reporting to produce the reports or do we need to create OLAP cubes/data mining models and then connect with SQL reporting to produce reports.

Please tell me which is correct and why.

Thanx in advance
Prasanna

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Abhinav Kumar]

If you want to slice and dice the data, OLAP/cubes are
the way to go. if it is just reporting both are fine.

Abhinav Kumar

-----Original Message-----
Hi friends
I am new to data warehouse concepts. After transforming

the required data from the operational DB to data
warehouse DB, can we use SQL reporting to produce the
reports or do we need to create OLAP cubes/data mining
models and then connect with SQL reporting to produce
reports.

Please tell me which is correct and why.
Thanx in advance
Prasanna
*********************************************************

*************

Comprehensive, categorised, searchable collection of

links to ASP & ASP.NET resources...

.

[rikesh]

What are the best tools for this?

Is it Analysis Services - to produce the cubes?

Post by Abhinav Kumar
If you want to slice and dice the data, OLAP/cubes are
the way to go. if it is just reporting both are fine.
Abhinav Kumar

-----Original Message-----
Hi friends
I am new to data warehouse concepts. After transforming

the required data from the operational DB to data
warehouse DB, can we use SQL reporting to produce the
reports or do we need to create OLAP cubes/data mining
models and then connect with SQL reporting to produce
reports.

Please tell me which is correct and why.
Thanx in advance
Prasanna
*********************************************************

*************

Comprehensive, categorised, searchable collection of

links to ASP & ASP.NET resources...

.

[k***@gmail.com]

Informatics Outsourcing is an Offshore Data Management service company. Data Management Service includes all types of Data Conversion, File Conversion, XML Conversion, HTML Conversion,SGML Conversion, Document Conversion,Data Entry, Data Extraction and Validation,OCR and ICR Services with affordable price. Our team to give the solution quickly and given requirements.