I am interested to learn how to use the sql server olap technology
--can any one help?
is there a demo available...possibly a demo application as well?
or site that shows or uses OLAP technology


ak

__________________
ak

Have you installed the Analysis Servicees? It gives you a management console (Analysis Manager) - which sends you to online manuals - along with a MDX demo application. The online manuals use an Access data base (Foodmart) on which OLAP cubes are built.
In order to use properly sll these tools, after installing them, you need to upgrade SQL Server (and then the Analysis Services, just installed) with Service Pack 3a.

A problem that I am concerned with is how to use MDX from within .NET applications.

Some hints at http://www.paretoanalysts.com/DesktopDefault.aspx

Have a look also at http://www.vb2themax.com/HtmlDoc.asp...ID=5500&Page=1
also at http://www.txsqlusers.com/txLinks/de...?categoryid=46

At http://search.yahoo.com/search?fr=ieas&p=OLAP+tutorial you'll find links to some tutorials.

At http://www.sqlmag.com/Forums/message...76&STARTPAGE=1 you'll find a discussion about how to work with Analysis Services (at that time Service Pacvk 2 was needed, now you'll need Service Pack 3a) And, for SP 3a, go to
http://www.microsoft.com/downloads/d...displaylang=en

At http://www.microsoft.com/msj/0899/mdx/mdx.aspx soem considerations how to use MDX, continued at http://www.microsoft.com/msj/0999/mdx/mdx.aspx

Analysis Services Forum at
http://www.sqlservercentral.com/foru...lysis+Services

Hope all this stuff will be useful

thanks very just going through the tutroial...will come back maybe with more questions as i go through all the info you have given me...
once again thanks very much

ak