|
Home > Archive > MS SQL Server OLAP > November 2005 > Suggestion for SQL 2000 \ 2005 AS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Suggestion for SQL 2000 \ 2005 AS
|
|
|
| Hi All:
I am very new to SQL OLAP so I need some suggestion from gurus. I want to
set up a reporting system which involves lot of aggregation on OLTP data.
Currently we are doing these aggregations in DTS packagaes and nightly dumps
which takes forever to run (Avg 24-30 hours) so our reporting system is
always behind 30 hours. I was thinking of setting up this design using
Analysis services and move data into cubes rather than traditional SQL
tables. I was wondering should I start with SQL 2000 or 2005 Analysis
Services. Also, we need web interface for displaying these reports to the end
user. Can I integrate SQL AS with Reporting Services or do I need to buy
third party tools? Is there some whitepaper or some samples that can walk me
through this process of setting up a cube and display it on the web using
reporting services or some other technology.
Thanks in advance.
Nitin
| |
|
| Reporting Services is 1 of the tools which can be used to display AS2005
cubes other the web.
I don't recommand to push your data directly in AS, but ontinue to use an
RDBMS database. Why ? to simplify the management and the backup of your
data.
AS is not a database, you can't play with its schema like an RDBMS.
If you start your project today, use AS2005. The number of new features is
really impressive, the only bad point is the end user access. today Excel
2003 and the pivottable doesn't support the new functionalities to provide a
good rendering, Excel 12 (next version) will change this.
So you have to pay for an end user tool, and if your want a web based tool,
you have to looking for 3rd party tools like Proclarity, Novaview etc...
(http://www.mosha.com/msolap/util.htm)
"Nitin" <Nitin@discussions.microsoft.com> wrote in message
news:41D3316D-A806-47AF-B073- 42941093419A@microso
ft.com...
> Hi All:
>
> I am very new to SQL OLAP so I need some suggestion from gurus. I want to
> set up a reporting system which involves lot of aggregation on OLTP data.
> Currently we are doing these aggregations in DTS packagaes and nightly
> dumps
> which takes forever to run (Avg 24-30 hours) so our reporting system is
> always behind 30 hours. I was thinking of setting up this design using
> Analysis services and move data into cubes rather than traditional SQL
> tables. I was wondering should I start with SQL 2000 or 2005 Analysis
> Services. Also, we need web interface for displaying these reports to the
> end
> user. Can I integrate SQL AS with Reporting Services or do I need to buy
> third party tools? Is there some whitepaper or some samples that can walk
> me
> through this process of setting up a cube and display it on the web using
> reporting services or some other technology.
>
> Thanks in advance.
>
> Nitin
| |
| Nitin 2005-11-27, 11:23 am |
| Hi Jeje:
I am little confused with your response.
1st - I don't recommand to push your data directly in AS.
What did you mean by this? If I dont push data to AS, how am I going to use
AS ?
2nd - you have to pay for an end user tool
I thought you said I could use Reportig Services for that. Isnt Reporting
Services free? If so, why I need to pay. Can reporting services access Cubes
created in AS or do I need a special interface for it?
Thanks for your response
Nitin
"Jéjé" wrote:
> Reporting Services is 1 of the tools which can be used to display AS2005
> cubes other the web.
>
> I don't recommand to push your data directly in AS, but ontinue to use an
> RDBMS database. Why ? to simplify the management and the backup of your
> data.
> AS is not a database, you can't play with its schema like an RDBMS.
>
> If you start your project today, use AS2005. The number of new features is
> really impressive, the only bad point is the end user access. today Excel
> 2003 and the pivottable doesn't support the new functionalities to provide a
> good rendering, Excel 12 (next version) will change this.
> So you have to pay for an end user tool, and if your want a web based tool,
> you have to looking for 3rd party tools like Proclarity, Novaview etc...
> (http://www.mosha.com/msolap/util.htm)
>
>
> "Nitin" <Nitin@discussions.microsoft.com> wrote in message
> news:41D3316D-A806-47AF-B073- 42941093419A@microso
ft.com...
>
>
>
| |
|
| RS is "free" when installed on the same server as AS or SQL Server.
but RS doesn't provide ad-hoc analysis capabilities, only "static" reports
(I mean predefined reports, the user can't change these reports , except if
you develop your own front end tool in front of RS)
how to fill AS? by reading from a database. So fill your data warehouse
first, then process your cubes, or use real-time cubes.
with AS2005 its possible to fill directly a cube without using a database (I
have not verified how to do this, but I have read an article about this), I
don't recommand this approach.
"Nitin" <Nitin@discussions.microsoft.com> wrote in message
news:9EC69C2D-7C09-4EAF-BCAE- 5CB802A738ED@microso
ft.com...[color=darkred]
> Hi Jeje:
> I am little confused with your response.
> 1st - I don't recommand to push your data directly in AS.
> What did you mean by this? If I dont push data to AS, how am I going to
> use
> AS ?
>
> 2nd - you have to pay for an end user tool
> I thought you said I could use Reportig Services for that. Isnt Reporting
> Services free? If so, why I need to pay. Can reporting services access
> Cubes
> created in AS or do I need a special interface for it?
>
> Thanks for your response
>
> Nitin
>
>
> "Jéjé" wrote:
>
|
|
|
|
|