I need to display very long text on Webi reports. However, the technical limitation of a BW infoobject is 60 characters. So Bex query from which the OLAP universe is created can only display partial text. A possible workaround is to write the long text to a transparent table during ETL and build a relational universe on the long text table.
(1) Is it possible to join an OLAP universe and a relational universe?
(2) Is it possible to write a WEBI report on relational universe?
Thank you for your input.