sql server data warehouse: Basic Questions(Part 3) -- sql server data warehouse

Basic Questions(Part 3)

Hassan
3/26/2005 7:36:39 PM

sql server data warehouse:

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

Re: Basic Questions(Part 3)

Dave Wickert [MSFT]
3/28/2005 9:52:07 AM

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@online.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.

[quoted text, click to view]