Both One-Many and Many-One relations in fact table
Both One-Many and Many-One relations in fact table
(OP)
Hi,
i have a "minor" problem with my olap cube. As you can see in the attachment, i have one fact table, four "one-many" relation and one "many-one".
I can successfully process and deploy it, and when i connect the cube to my PIVOT grid, the fields are already displaying.
When i filtering to something from the B or C tables, its nicely working --> which means that, it filter from the Direction of A.
BUT!
When i filtering something from the F table, it gives me the all result of the table, and doesn't filter to anything. I have a foreign key in F table,
which is pointing to A, and it should uniquely identify a record. But it doesn't.
Why is it happening?
i have a "minor" problem with my olap cube. As you can see in the attachment, i have one fact table, four "one-many" relation and one "many-one".
I can successfully process and deploy it, and when i connect the cube to my PIVOT grid, the fields are already displaying.
When i filtering to something from the B or C tables, its nicely working --> which means that, it filter from the Direction of A.
BUT!
When i filtering something from the F table, it gives me the all result of the table, and doesn't filter to anything. I have a foreign key in F table,
which is pointing to A, and it should uniquely identify a record. But it doesn't.
Why is it happening?
Talk To Other Members