BI Publisher (MOSC)

MOSC Banner

Link different datatypes in query builder

edited Dec 11, 2013 3:38AM in BI Publisher (MOSC) 6 commentsAnswered
Hi,

I am trying to link two tables where one of the links is between two fields with different datatypes, one being a string and the other a numeric. I know how to convert, but I cannot link on converted values. I also tried linking at dataset level and it let me define the link, but no XML result was returned. And when I re opened the data model it removed the link ("DOCO = number (PO)", where DOCO is numeric and PO is a string) saying invalid link removed to null.null. Looks like function lements are not available at the

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