Hi OLAP Gurus,

I am about to develope my first OLAP implementation with MsSQL2000
Analysis Services with Crystal Analysis as Client software.

Previously I only create a simple cube for demo, since Now I should
develope real project, I need knowledge about, such as :
- A way to transfer data from OLTP to OLAP database
(on scheduled basis)
- How to design OLAP DB
- If user want to analyze : Profit Margin, Sales & Sales
Return, how should I design the OLAP DB ?

Is there any good Book or Guide/Docs somewhere about developing OLAP
with MsSQL2000 Analysis Services ?

Many thanks in advance,
Krist





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You have one by edited by Worx

"Krist Lioe" <xtanto (AT) hotmail (DOT) com> a écrit dans le message de
news:%238mT8CjaDHA.880 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

"Krist Lioe" <xtanto (AT) hotmail (DOT) com> wrote

Just curious -- what are you using Crystal Analysis as the client? Was this
the result of an evaluation against other products?

Hi Sylvain,

Is that a Book ? what is the title ?

Thanks,
Krist



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Nigel,
Actually I only compared between MS Data Analyzer , Crystal Analysis &
EXCEL.
My consideration upon choosing Crystal Analysis is :
- enough functionality
- cheap

Do you have any other recommendation ?

Thanks,
Krist




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Here are some good titles:
Microsoft(r) SQL Server(tm) 2000 Analysis Services Step by Step
by Olap Train
MDX Solutions: With Microsoft SQL Server Analysis Services
by George Spofford
SQL Server Developer's Guide to OLAP with Analysis Services
by Mike Gunderloy, Tim Sneath
Microsoft OLAP Unleashed
by Timothy Peterson, et al

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Krist Lioe" <xtanto (AT) hotmail (DOT) com> wrote

The title of the book is "Professional SQL Server 2000 Data Warehousing with
Analysis Services".
For me is the more complete.

Sylvain


"Krist Lioe" <xtanto (AT) hotmail (DOT) com> a écrit dans le message de
news:ueMx6VraDHA.4020 (AT) tk2msftngp13 (DOT) phx.gbl...