BO Shortcut Join problem

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)

Vikas,

Here is a rough idea :

  • Make the shortcut A-C normal. Create 2 different contexts one with A-C, C-E and C-D and the other with A-B B-C C-D and D-E. - and to avoid the messages asking for choosing your context, use the aggregate aware functions.

I have no idea of the complexity of your universe, so I’m not totally sure that this solution si suitable or not.

Regards

Yannick


Listserv Archives (BOB member since 2002-06-25)