Can't Import all the objects from Table

[Former Member]

Hello Experts,

I have created Universe on Oracle tables, when I try to import the whole table to classes and objects, some objects are not getting imported, I used the same table in crystal report, I could see all of them, What I noticed is these objects are 65 charatcters long, Is there any work around?

Thanks,

Ravi

[Former Member · Accepted solution]

Try to set the datatype other then the character for the universe object.

Create objects first set the data type wither T for long text or L for blob (binary large object). Now point your object to the table column.

Hope this will work out for you.

[Former Member · Accepted solution]

Thanks for your reply, When I try to create new object I can see only these options Character,Number, Long Text,Date, I don't see anything BLOB, However, I created Long Text Object and poited to the table column, when I try to display data, I get this "This is BLOB"

I checked the data type for this column in Oracle, data type is RAW, Is there any work around?

Thanks,

Ravi

[Former Member · Accepted solution]

BLOB aren't supported within BusinessObjects.

One option may be to create a view that converts the BLOB into a big varchar.

[Former Member · Accepted solution]

Currently Raw data type is not supported in Universe. It is supported only if you are creating universe based on Metadata Source like OLAP, Orale BW etc.

As I know

"RAW is a variable-length datatype like the VARCHAR2 character datatype, except Oracle Net Services (which connects user sessions to the instance) and the Import and Export utilities do not perform character conversion when transmitting RAW or LONG RAW data. In contrast, Oracle Net Services and Import/Export automatically convert CHAR, VARCHAR2, and LONG data between the database character set and the user session character set, if the two character sets are different."

Can't you convert the column data type into database as Varchar2. if it is not possible then you can create a View which can convert your raw data type to Char and you can use that in universe.

You can talk to your DBA and find it our best possible solution for you.