April 19, 2010 at 2:03 pm
Hi all
I am new to SSAS, I am having trouble setting a one-to-one relationship in SSAS
Tables: Incident, TreeIncident, Tree
TreeIncident.Incident is the FK for Incident
and
TreeIncident.NodeId is the FK for Tree
Tree.ParentId is the FK for Tree (so Tree is a child-parent)
Count of Incident is a measure.
I would like to put the Tree on the YAxis so that I am able to drilldown with it. But the problem is that in order to figure out what Tree an Incident is in, i need to go through TreeIncident.
Now how do link them together? I have tried Referenced Relationship, and that didn't work. I am suspecting that I should be able to specify a child-parent attribute inside TreeIncident and then use a regular relationship for Count of Incident and TreeIncident. But i cannot get it to work.
Can you guys help me please?
May 15, 2010 at 8:19 am
Maybe I am not fully understanding this and might need an example of what is in each table, but from the sounds of it you have two dimension tables (Tree and Incident) and then a factless fact table (TreeIncident). You would create Tree as a Parent-Child dimension and as long as you have the self-referencing relationship in the data source view the dimension designer will pick-up on this and create this for you.
The TreeIncident table would be your measure group and you would create a count measure and then simply related your two dimensions to the measure group as regular relationships.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply