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 ? ThanksIn 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.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u73tw4nMFHA.3788@.tk2msftngp13.phx.gbl...
> 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
>
>
没有评论:
发表评论