inna

Hello All,

I have parent-child Destination dimension which is based on Area_Codes
table.
Area_Codes table includes 4 fields being used for this project:

Area_Code_Id - int - child and key attribute
Area_Code_Parent_Id - int - parent of Area_Code_Id - Something similar to
employee dimension in Adventure Works
Area_Code - varchar - real area codes exist for destination
Description - varchar - Name of the area code- could be city name, country
name, Special Services, Mobile etc...

Dimension built as parent_Child on Area_Code_Id and Area_Code_Parent_Id
having Description field as NameColumn
Dimension displayed exactly as I would like to see it.

The problem: in our CDR (we are telephony company) we use real area code
values which is represented in Area_Code field.
I have added Area_Code field as attribute to dimension, added rigid
attribute relationship between this attribute and key - Area_Code_Id.
Then I defined granularity between Area_Code field from measure group and
Area_Code attribute from Destination dimension.

It doesn't work - I only see the same data of all level for every area code.
This principle works for AS 2000. What should I do to make it right?

Please, advise
Thanks
Inna

inna

Hello All,

I have parent-child Destination dimension which is based on Area_Codes
table.
Area_Codes table includes 4 fields being used for this project:

Area_Code_Id - int - child and key attribute
Area_Code_Parent_Id - int - parent of Area_Code_Id - Something similar to
employee dimension in Adventure Works
Area_Code - varchar - real area codes exist for destination
Description - varchar - Name of the area code- could be city name, country
name, Special Services, Mobile etc...

Dimension built as parent_Child on Area_Code_Id and Area_Code_Parent_Id
having Description field as NameColumn
Dimension displayed exactly as I would like to see it.

The problem: in our CDR (we are telephony company) we use real area code
values which is represented in Area_Code field.
I have added Area_Code field as attribute to dimension, added rigid
attribute relationship between this attribute and key - Area_Code_Id.
Then I defined granularity between Area_Code field from measure group and
Area_Code attribute from Destination dimension.

It doesn't work - I only see the same data of all level for every area code.
This principle works for AS 2000. What should I do to make it right?

Please, advise
Thanks
Inna