This content has been marked as final. Show 2 replies
In the properties of your presentation subject area, you could specify an implicit fact column:
For each subject area in the Presentation layer, you can set an implicit fact column. The implicit fact column is added to a query when it contains columns from two or more dimension tables and no measures. The column is not visible in the results. It is used to specify a default join path between dimension tables when there are several possible alternatives or contexts.
Hope it helps,
Perfect.! Thanks Benoît I can now tell BI Server to which fact to pick from.
Appreciate your help greatly.