Was looking at the FoodMart 2000 Database in AS and the HR cube as an
example and had these quesions

1) I was looking at MetaData on the right pane and see the following
dimensions :

Time, Store,Pay Type, Store Type, Position, Department, Employees

Also see the following source tables

salary, employee, time_by_day, store, position

Now how can I tell the relation between these dimensions and source
tables.. for eg: what is the Pay Type dimension comprising of ?

2) Also from the Meta Data I see the measures

Org Salary, Count, Number of Employees

How can I find details about how these measures are formed ?

I looked at the Cube Editor properties for this HR Cube and cannot
tell much..

Can you help me ? Thanks

In the cube editor, click on the object you are looking at (expand it to
look at each of the levels in the dimension); or the measure you want to
look at, and then go down to the "Properties" panel at the bottom left-hand
side. There are two tabs: Basic and Advanced.
All of the table and field names are Basic properties.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Hassan" <fatima_ja (AT) hotmail (DOT) com> wrote