This content has been marked as final. Show 1 reply
OBI will choose the most economical path based on the number of joins between a fact and a dimension table used in the report.
In your example, since it has 2 fact tables in the LTS, BI server will dynamically choose any of the paths.
You can, however make the BI server to choose a defined path by setting an Implicit fact column. But, this has to be set on a subject area level. Thus BI server will choose this path for all the requests on this subject area.
Hope this helps !