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.

I am having a problem designing a Dim and Fact Table for the following problem.

I want to display my data in PivotGrid as below :

  1. First table shows that if i search a person, anyone related to him/her, will be shown together with its relationship.
  2. Second table shows that if i removed the 'Related_Person_ID', will only show the person's detail only (without related details).

enter image description here

I am having a problem designing this into SSAS Cube. Below are my table design :

  1. "Related_Person_Relationship" [Person_ID and Related_Person_ID] table is joined into "Person" [Person_ID] table twice.

    create table Person
    (
        [Person_ID] varchar(10),
        [Account_ID]    char(10),
        [Balance]   float,
    )
    insert into Person select 'Alex', 'ACCT_001', '500'
    insert into Person select 'Alice', 'ACCT_002', '300'
    
     create table Related_Person_Relationship
    (
        [Person_ID]         varchar(10),
        [Related_Person_ID] varchar(10),
        [Relationship]      varchar(15),
    )
    insert into Related_Person_Relationship select 'Alex', 'Alex', 'Self'
    insert into Related_Person_Relationship select 'Alex', 'Alice', 'Spouse'
    insert into Related_Person_Relationship select 'Alice', 'Alice', 'Self'
    insert into Related_Person_Relationship select 'Alice', 'Alex', 'Spouse'
    

enter image description here

After i deployed my cube, i get the following display instead :

enter image description here

How to fix this? Thanks >.<

share|improve this question
    
I can't see your links after > "After i deployed my cube, i get the following display instead :" –  Turque Aug 29 '12 at 12:35
    
@Turque I can see the image - have you tried a hard refresh in your browser? –  Jack Douglas Aug 29 '12 at 14:17
    
anyone have solution for this? –  KayDash Aug 30 '12 at 3:12
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.