Hi

Are there any detailed documents on the Foodmart 2000 database schema and the Cube design

Cheers
Sanka

Generate some yourself :-)
Download the OLAP Scribe utility and point it to Food Mart.
http://www.microsoft.com/downloads/d...DisplayLang=en
You'll get 30-50 pages of documentation :-)
OLAP Scribe is a *way* cool tool -- anyone who works with Analysis Services
should get to know it. You'll love it.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Sanka" <Sanka (AT) mailcity (DOT) com> wrote

We use the OLAP Scribe tool - its very handy and useful
But I was looking at some docs which would describe the FoodMart database for a newbie to Analysis Services...The various functions / features used in those cubes etc..


----- Dave Wickert [MSFT] wrote: ----

Generate some yourself :-
Download the OLAP Scribe utility and point it to Food Mart
http://www.microsoft.com/downloads/d...&DisplayLang=e
You'll get 30-50 pages of documentation :-
OLAP Scribe is a *way* cool tool -- anyone who works with Analysis Service
should get to know it. You'll love it
--
Dave Wickert [MS
dwickert (AT) online (DOT) microsoft.co
Program Manage
BI Practices Tea
SQL BI Product Unit (Analysis Services
-
This posting is provided "AS IS" with no warranties, and confers no rights


"Sanka" <Sanka (AT) mailcity (DOT) com> wrote in messag
news:6E7EE59B-B6F8-42EF-B194-5326DB6D634F (AT) microsoft (DOT) com..

Hmmm.. the best I can think of is to run the Analysis Manager tutorial.
Bring up AM and on the main page is a link to "Analysis Manager Concepts &
Tutorial". The features in Food Mart were designed to highlight particular
Analysis Services features. It is not a real life application (although some
it might seem so :-). It's real purpose, like "pubs" with SQL Server RDBMS,
is to act as a platform for working with AS functionality. Since the
Tutorial walks you through AS concepts and features -- it then shows those
in the context of Food Mart. That's the closest that I can think of to
satisfy your request.
Hope that helps.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Sanka" <loonysan (AT) mailcity (DOT) com> wrote

those cubes etc...