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.
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.
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>”
[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
This feature enables the inclusion of add other HTML commands and can be very useful for advanced formatting of accomplishment.
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?
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
Does HTML formatting remain when you export / print now? I'm sure it doesn't in 3.1, wondering if this has changed?
BI 4.1 SP5.. no. all HTML content is not printed when export
Unfortunately it´s not possible, up to now, print HTML tags.
Please have a look on the document I published, it may help: Display vertical labels in tables
Good to hear from brazilian people in this space... I confess I was feeling quite alone...