Basic Questions(Part 3)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hassan - 27 Mar 2005 04:36 GMT

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

Reply to this Message

Dave Wickert [MSFT] - 28 Mar 2005 18:52 GMT

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.

Signature

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.

> Was looking at the FoodMart 2000 Database in AS and the HR cube as an
> example and had these quesions
[quoted text clipped - 21 lines]
>
> Can you help me ? Thanks

Reply to this Message