I am having trouble creating a many to many relationship for my cube, I just dont quite get how to set this up.
Here is the scenerio:
---> = ManytoOne
Table_E ---> Table_M ---> Table_JL ---> Table_TreeCode <--- Table_Tree
Table_E *-----* Table_Tree
TableJL has a treecodeId field that points to Table_TreeCode, but I would like to see Table_Tree as a dimension
Say for example I need a count of Table_E by dimension Table_Tree.
I just dont understand how to achieve that.
View Complete Post