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.
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.
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.