The WHERE clause filter is used to constrain the physical tables referenced in the logical table source. If there are no constraints on the aggregate source, leave the WHERE clause filter blank.
Each logical table source should contain data at a single intersection of aggregation levels. You would not want to create a source, for example, that had sales data at both the Brand and Manufacturer levels. If the physical tables include data at more than one level, add an appropriate WHERE clause constraint to filter values to a single level.
Is there a way to reference different physical table in the WHERE clause. Currently OBIEE seems to be restricting reference to just that one particular table. The table I want to reference is not related to the one the logical table is referencing.
ReplyDelete