VLDB was set at report level to use look up table as the where clause driving tables. However, my relationship filters ignore this setting. For example: Report filters on Location and Time. All passes without relationship filter has where clause such as "WHERE LU.Location = 5 and LU.PeriodID = '2004-02-25'
The pass with relationship filter has "WHERE FACT.Location = 5 and FACT.PeriodID = '2004-02-25'.
Is this a defect or am I missing a setting somewhere?
The pass with relationship filter has "WHERE FACT.Location = 5 and FACT.PeriodID = '2004-02-25'.
Is this a defect or am I missing a setting somewhere?