We are moving away from Hyperion Brio to TDP for some reports. The way that Brio worked was that, when putting a limit/filter in a field from a table that had an outer connection to the rest of the statement, the outer join would be taken into account (only apply filter if there is a field to be selected). In the diagram window of the query builder a filet/where clause entered in the column/field bar acts as a filter on the entire results.
I know how to fix this in the SQL statement (adding (+) after the fieldname, of defining a “custom” where clause formula). However,before teaching users that have less knowledge of SQL statements and are used to Brio, I wanted to know whether there is a “visual” non SQl statement writing way to apply “where clauses” only to the returned data in an outer join and not to an entire result-set.
Second question is about the Visualize Query option. This option seems to add a lot of “(” and “)” symbols in the statement, even to such account that the statement does not execute any more. I found this when an “IN (X,Y)”-clause in a Where clause got turned into “IN ((X,Y))” which blocked the execution of the SQL:
WHERE (CASE WHEN table.field IN (X,Y) THEN table.field2 = ‘A’ ELSE table.field2 = ‘B’)
WHERE (CASE WHEN table.field IN ((X,Y)) THEN table.field2 = ‘A’ ELSE table.field2 = ‘B’)
Any way this can be turned off or edited/curbed?