Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Both One-Many and Many-One relations in fact table

Status
Not open for further replies.

Vary88

Programmer
Oct 7, 2015
1
0
0
HU
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?
 
 http://files.engineering.com/getfile.aspx?folder=fc8a4c03-d91c-47ad-acc2-27af70c421eb&file=Cube_relations.png
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top