Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

SSAS - Parent Child hierarchy - displaying other Parent attributes alongside Child Attributes

For example:

Employee Table

+-----+-------+------+---------------+
| KEY | NAME  | ROLE | MANAGERKEY    |
+-----+-------+------+---------------+
|   1 | John  | CAO  |             1 |
|   2 | Adam  | Emp  |             1 |
|   3 | Steve | CAO  |             3 |
|   4 | Colin | Con  |             3 |
|   5 | Tony  | Con  |             3 |
+-----+-------+------+---------------+

I've setup the Parent-Child relationship in the Dimension.

In Excel, when using Tabular view, I am able to see the following:

+-------------+-------+------+
| MANAGERNAME | NAME  | ROLE |
+-------------+-------+------+
| John        | John  | CAO  |
| Adam        |       | Emp  |
| Steve       | Steve | CAO  |
| Tony        |       | Con  |
| Colin       |       | Con  |
+-------------+-------+------+

I would like to see the Manager Role in the following, is this possible?

+-------------+-------+------+------------+
| MANAGERNAME | NAME  | ROLE | MANAGEROLE |
+-------------+-------+------+------------+
| John        | John  | CAO  | CAO        |
| Adam        | Emp   | CAO  |            |
| Steve       | Steve | CAO  | CAO        |
| Tony        |       | Con  | CAO        |
| Colin       |       | Con  | CAO        |
+-------------+-------+------+------------+

+-------+------+------------+
| NAME  | ROLE | MANAGEROLE |
+-------+------+------------+
| John  | CAO  | CAO        |
| Adam  | Emp  | CAO        |
| Steve | CAO  | CAO        |
| Tony  | Con  | CAO        |
| Colin | Con  | CAO        |
+-------+------+------------+
share|improve this question

migrated from serverfault.com Feb 20 '12 at 19:49

This question came from our site for professional system and network administrators.

add comment

1 Answer

No, you can't.

As you currently have your Employee table, you can't have a Manager Role attribute for an employee.

To have a Manager Role attribute, you'd have to add a ManagerRole column to your Employee table:

Key  Name   Role  ManagerKey  ManagerRole
---  -----  ----  ----------  -----------
1    John   CAO   1           CAO
2    Adam   Emp   1           CAO
3    Steve  CAO   3           CAO
4    Colin  Con   3           CAO
5    Tony   Con   3           CAO

... so that you could define a Manager Role attribute on your Employee dimension.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.