Fact.Issues is made from select I.*, M.MagazineID from fact.issues I inner join fact.main M on i.mainID = m.mainID In Dimension usage Magazine appears under fact.main and fact.issues with a regular relationship type.
If I drag the issue dimension into rows every issue for every magazine is displayed. If I drag magazine to the filter & pick one, every issue is still displayed. If I then drag in a measure from fact.issue only the data for that magazine is dispayed. If I do the same using the campaign dim instead of the issues dim, only the campaigns for the filtered magazine are shown even before the measure is dropped in.
What have I done wrong to make the issue dimension ignor the filter until measures are added (whereby the cube is set to suppress rows with no data)?
