If I have a fact table ex:
TBAnswer, have fields "Question", "Answer", "UserID"
Dimension table is
TBUser, have fields "UserID", "Name", "Address", "Job"(==>>varchar(40)).
If I want to count How many user whose answer "ABC" in question "AAAAAA". whose have a job as a "Programmer".
How do i must to design the cube?
I dont know if u know what i mean. But i've do my best to explain. Please help me. Thx.
TBAnswer, have fields "Question", "Answer", "UserID"
Dimension table is
TBUser, have fields "UserID", "Name", "Address", "Job"(==>>varchar(40)).
If I want to count How many user whose answer "ABC" in question "AAAAAA". whose have a job as a "Programmer".
How do i must to design the cube?
I dont know if u know what i mean. But i've do my best to explain. Please help me. Thx.