BI Publisher (MOSC)

MOSC Banner

BI Publisher data model issue with links and distinct clause

edited Jan 30, 2015 10:02AM in BI Publisher (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center