Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Writing Back to a RD from OLAP

Author  Topic 

TexDec
Starting Member

22 Posts

Posted - 2002-04-05 : 18:02:21
Does anyone know if this functionality is available, and if it works, in SQL Server2000? I've been told I'd need to use Express to get this type of functionality, but would rather stick with SQL Server.
What I'm trying to do is develop a forecasting system, using OLAP that would allow users to generate, store and manipulate a sales forecast?
Any thoughts would be appreciated.


sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-04-06 : 00:07:18
Yes,
You can use the Analysis services (OLAP For SQL Server 7).
Using this you can analyse you data....
And using Data Mining Model you can have your sales forecast.

---------------------------
Sandesh - The Messanger
Go to Top of Page

TexDec
Starting Member

22 Posts

Posted - 2002-04-26 : 13:19:59
Thanks Sandesh
I'm pretty comfortable with using Analysis Services for the reporting, querying & analysis of the data.
Really worried about the write-back piece. Can I do that directly from some type of 'Input Cube' or would I need to write some specific XML/VB to capture the data from web forms?

Go to Top of Page
   

- Advertisement -