Dynamic Where Clause

Can a where clause in one dimension be dependant on the value of an object in another dimension only if that object is referenced in the report. If the object is not in the report there there would be no need for the restriction on the first object. We are trying to speed up queries by reducing the need for full table scans.


Allegra (BOB member since 2003-11-24)

Can you give us an example?
I don’t understand the question.


Steve Krandel :us: (BOB member since 2002-06-25)

We have business unit in two different dimensions, the OBS and the Account Dimension. If the OBS business unit is set to a certain value we want to automatically force the Account Dimension Business Unit to have the same value. If no OBS business unit is selected then the Account Dimension does not need to equal the OBS business unit.


Allegra (BOB member since 2003-11-24)

Try:

Apply the following Where clause to dimension object "OBS business unit ":

OBS business unit  =  Account Dimension business unit 

Then apply a table hint to dimension object "OBS business unit " for the two tables on which “OBS business unit”, “Account Dimension business” unit are based.


Andreas :de: (BOB member since 2002-06-20)

Have you got this to work? If yes, how did you do it?

Thanks,
JBF


jbf_bouser (BOB member since 2005-06-20)