Is it possible to have 2 contexts within the same sql path? I have a fact table with 2 keys (one identifying historical and the other current) widgets. Both keys can be used along with the time key to determine either the historical widget name or the current widget name (current is duplicated across time periods).
I was hoping I could create a context to switch between the joins to the widget table depending upon whether the users want to see the historical names or the just the current names for all time periods. I haven't tried this yet, but wondering if a context can do this? Everywhere I have seen contexts they have been used to break a loop or define a different path, but not within the same path. I need to basically switch between the 2 keys depending upon what the users want to see. I don't want to have to use separate objects or universes to do this....
Any suggestions out there????
I was hoping I could create a context to switch between the joins to the widget table depending upon whether the users want to see the historical names or the just the current names for all time periods. I haven't tried this yet, but wondering if a context can do this? Everywhere I have seen contexts they have been used to break a loop or define a different path, but not within the same path. I need to basically switch between the 2 keys depending upon what the users want to see. I don't want to have to use separate objects or universes to do this....
Any suggestions out there????