in System Administration, Web Intelligence

Modifying Web Intelligence Document Templates with CSS

One of the great new features in Web Intelligence 4.0 is the ability to create and apply document templates. These templates use standard CSS (Cascading Style Sheets) which should be familiar to any web developer. But you don’t have to be a developer to make some simple changes — let’s take a look at some of the things we can do.

To start, we need to get a copy of the CSS file for us to modify. This is easily done through Web Intelligence Rich Client or the Webi applet in BI Launchpad. In this case we’ll use Rich Client. Open up any existing report, then click the Properties tab in the top-left, then Document. On the Document Properties screen, click the Change Default Style button. Now, click Export Style to save a copy of the existing CSS template.

Open the saved CSS file in your text editor of choice. Notepad works, but I prefer the free Notepad++ which gives you some convenient highlighting and makes the stylesheet much easier to read. Thankfully though, this stylesheet is well organized and easy to understand. The various options are broken into 6 sections:

  1. General settings
  2. Report and Areas
  3. Tables and Forms
  4. Charts
  5. Columns and Rows
  6. Cells

Adding a Logo

Let’s look at a typical scenario, adding a logo to our report’s header. Thanks to the stylesheet, this is easily done. The catch, before we start, is that this logo has to exist in a certain location on your BusinessObjects server, specifically <BOE Install Path>\SAP BusinessObjects Enterprise XI 4.0\images, and must be either a JPG or GIF. Talk to your system administrator to get your logo image saved out there.

Let’s add the Altek Solutions logo to our report header. Assume I have saved the file out to my server as logo.jpg. We want to add this to the report header, so we need to find the related section in the stylesheet, which is REPORT > PAGE_HEADER. By default, this section looks like this:

REPORT > PAGE_HEADER {
min-height:1.40cm;
background-fill:color;
background-color:#ffffff;
background-type: htile;
background-v-align: top;
background-h-align: left;
}

We will need to change a couple values and add a line to provide the file name of our logo.  This is what it should look like after the changes (in bold):

REPORT > PAGE_HEADER {
min-height:1.40cm;
background-fill: bitmapAndColor;
background-color:#ffffff;
background-type: box;
background-image: boimg://logo.jpg;
background-v-align: top;
background-h-align: left;
}

We change the background-fill property to bitmapAndColor so that our logo (the “bitmap”) will be displayed. We also change the background-type to box so that our logo will be displayed only once, instead of being tiled or stretched. Finally, we add the background-image property to point to our image file.

Now we just need to import this stylesheet into our Webi document by clicking the Import Style button. Choose the stylesheet, then click OK and go back to your report. The logo should appear in the header automatically.

Other Options

Using this stylesheet template, you can make many adjustments to your report’s style. However, there are some limitations.

You can:

  • Create a stylesheet in order to define standard company-wide settings (such as company colors, or a logo as we demonstrated)
  • Change default colors, fonts, and font sizes for report tables
  • Set default page size, margins, and spacing
You can’t:
  • Define the default structure of a document (i.e. which report elements are already on the report when it is created)
  • Set colors or style on visualizations such as charts (This is called “creating a corporate palette” and is done via the VisualizationConfig.xml file)
  • Customize the style of the WebIntelligence application itself, such as the color or layout of the toolbars

Learn More

For more information, including a table of all available formatting options, please refer to Chapter 30 of the Web Intelligence Users Guide.

Free Web Intelligence Best Practices Guide

We put together a Best Practices Guide for Web Intelligence Development that includes over 20 pages of tips and techniques for developing business-ready reports. Plus we'll show you the common functions that have a negative impact on performance, how to create interactive reports, the best ways to standardize look-and-feel, and much more!

GET YOUR FREE COPY OF THE GUIDE TODAY!

Powered by ConvertKit

Write a Comment

Comment

  1. Hi

    Style sheets for Web Intelligence has been something long sought after and it is good to see this has finally arrived!

    This must have been introduced recently in FP3 or SP4 as I am not seeing this feature in 4.0 SP2

    AL

  2. Hi

    I have been looking at modifying section sizing for webi document. However I have looked at the style sheet but cannot clearly identify the section settings. Have you any experience with changing the sizing of a section, the width and height seem to be fixed.

    Any help would be appreciated.

    Thanks
    Liza

  3. Hi is it possible to add default table with single column in the report in a specific location?
    I would like to add partial results message in a table column(single column table with no header)
    I also would like to have author name and document name and page numbers in footer by default

    Thanks in advance
    Sravan.