Basic Questions(Part 3) - 03-26-2005 , 09:36 PM
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
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
Can you help me ? Thanks
Re: Basic Questions(Part 3) - 03-28-2005 , 12:52 PM
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
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