Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wrap Text Format problem for Concatenation of two fields

Status
Not open for further replies.

Tallaa

Technical User
Nov 28, 2006
9
0
0
US
Hi All,

In my universe one object concatenation of two fields. When i call the same object in reporter(BO6.1) I will be able to wrap text.
When i export same report into repository and open in webi i am facing the below problem.
My requirement is to place field1 in 1st line and field2 in 2nd line in one cell.
Ex: 0629635 0629635 0629635 I
E A
I appreciate any body's help.

Thanks,
Tallaa
 
The only way I can think of to do this is in the dimension definition in the universe. You'll add the carriage return and line feed characters between the two fields. In Oracle, this looks like (I think...) field1||chr(13)||chr(10)||field2.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top