This content has been marked as final. Show 2 replies
Create a new logical column, not based on any physical table. Set the formula for the column to be 1 (I.e. the number one).
Then in the presentation layer right click the subject area in question and use the set implicit fact feature to point to the column above.
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