BI Publisher (MOSC)

MOSC Banner

BI Publisher - Number in DB appearing as LONG bi publisher

edited May 8, 2015 10:00AM in BI Publisher (MOSC) 7 commentsAnswered

Folks,

When I do  :

"select client_id, client_wid, client from clients"   the column client_id and client_wid appear as LONG in the group in the data model in bi publisher. See attached screen shot.

whereas in the database table they are NUMBER(11,0).

Why is it appearing as LONG datatype and not a Double or Integer .. ?

I am using BI Publisher within OBIEE.   (as opposed to standalone ..../xmlpserver/ ....)


OBIEE version is 11.1.1.7.140527  and is installed on a Windows 2008 R2 server.

Thanks.

M. Jamal.

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