Skip to Content
Author's profile photo Jean Cristian Ferreira Machado

Advanced formatting using HTML – Objects Vertically

This document will be shown how to place objects (dimensions, measures and variables) vertically.

This feature does not have the formatting options Web Intelligence therefore will be exemplified how to:

First, open the SAP BI Launch Pad, this feature only works using the report development version via Web browser, http://NameServer/BOE/BI

Do not use the Rich Client and Applet. Create a new document, choose your data source.

This example will use an Excel spreadsheet.

/wp-content/uploads/2015/10/1_804180.jpg

Create a vertical table, select the desired object. Click the right button, choose the format option cell – Display – Red the content, select the HTML option and apply.

/wp-content/uploads/2015/10/2_804181.jpg

The value of the cell include the following HTML:

= “<html> <div STYLE = layout-flow: vertical-ideographic>” + [Store] + “</ div> </ html>”

So if you have the column label vertically, follows the code to be used:

= “<html> <div STYLE = layout-flow: vertical-ideographic>” + NameOf ([Store]) + “</ div> </ html>”

/wp-content/uploads/2015/10/3_804188.jpg

[Store] should be replaced with the name of the desired object. Save the document and open through the Central Manager console: http://NameServer/BOE/CMC

/wp-content/uploads/2015/10/4_804189.jpg

This feature enables the inclusion of add other HTML commands and can be very useful for advanced formatting of accomplishment.

Hugs

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hey Jean , good webi trick!!!

      I didn't understand why you need to open it through the CMC, should't be through BI Launch PAD?

      Congrats,

      Rogerio

      Author's profile photo Jean Cristian Ferreira Machado
      Jean Cristian Ferreira Machado
      Blog Post Author

      Hi Rogerio, It is not a restriction , only a recommendation. If you want to open via Launch Pad just make sure that it will be opening the HTML version . You can verify the CMC in preferences - Web Intelligence And Set View and Modify for HTML. Hugs

      Author's profile photo Former Member
      Former Member

      very good

      Author's profile photo Neil Mitchell-Goodson
      Neil Mitchell-Goodson

      Does HTML formatting remain when you export / print now? I'm sure it doesn't in 3.1, wondering if this has changed?

      Author's profile photo Leonel Dinamik
      Leonel Dinamik

      BI 4.1 SP5.. no. all HTML content is not printed when export

      Author's profile photo Former Member
      Former Member

      Unfortunately it´s not possible, up to now, print HTML tags.

      Regards,

      Rogerio

      Author's profile photo Didier MAZOUE
      Didier MAZOUE

      Please have a look on the document I published, it may help: Display vertical labels in tables

      Didier

      Author's profile photo Former Member
      Former Member

      Good document.

      Author's profile photo Former Member
      Former Member

      Hi,

      Good to hear from brazilian people in this space... I confess I was feeling quite alone...

      Regards,

      Rogerio