This content has been marked as final. Show 4 replies
I would do like this:
In BMM; Fact logical sources->properties (ie Fact) General tab
Add Dim1 and then Dim2
Content tab->Where clause
add condition on Dim2.
That would consider based on Fact, since your Fact is the subject and you are not reporting based any on dim tables.
Try it out.
On the logical sources - would that be dragging the additional tables onto the existing table (so the LTS appears as one - though in the properties you can see the join) or adding it below, so you see 3 LTS when that node is expanded?
thanks for your input,
LTS appears as one - though in the properties you can see the joinI would call this as Add or map --> physically mapping
Edited by: Srini VEERAVALLI on Mar 22, 2013 6:11 AM
Many thanks - works perfectly.