BI Publisher data model issue with links and distinct clause
I have a report with a single data source and 3 data sets joined. issue is with the distinct clause in the 3rd set. when i look at the code generated, its treating the distinct as "child column" and column name as "alias column name".
report errors out with java.sql.SQLSyntaxErrorException: ORA-00936: missing expression.
when distinct is removed it picks up the last column as the join.[even though the link shows the correct column].
As a work around "distinct" is removed and used a forced alias for the "joined" column as t.a as "a" forcing the data set to treat "t.a" as column name and "a" as alias name.