This content has been marked as final. Show 2 replies
If you don't want Fact 1 in query then don't make D1 and D2 constrained in Prompt. Since D1 and D2 are joined via Fact 1, if you make it constrained the query will hit the Fact 1 even if you set implicit fact column as 1.
If you have to constrain D1 and D2 then, to get a better performance you can set implicit fact column as some dummy logical column with no aggregation as Paul has suggested.
Hope this helps