Hi All,
We have some shortcut joins in our universe.
The scenario is:
A is a fact table. B, C, D, E are Dimension tables. The following are the normal joins:
A -> B
B -> C
C -> D
C -> E
The following are the shortcut joins:
A -> C
A -> D
When I select a dimension field from D, a dimension field from E and a measure field from A, the query is selecting the following joins: A -> B, B -> C, C -> D, C -> E
Is there a way to make it select a more efficient path like: A -> C, C -> D, C -> E ?
I tried this path and it takes less time than the earlier one. Is there some way to make the query choose this efficient path? Any help will be highly appreciated …
Thanks,
Vikas
Listserv Archives (BOB member since 2002-06-25)