Your quarterly dose of business intelligence tips & tricks - Issue 1 - Q2, 2005
   

Siebel Analytics tips & tricks:

Produce reports with style using Cascading Style Sheets

Custom drill-downs simplified

More tips & tricks:

BusinessObjects

Oracle

SQL Server

 


Contact ClearPeaks:

ClearPeaks (headquarters)
Valencia 266 3, 1
08007 Barcelona, Spain
Tel +34 93 272 1546

 

Editor
Angela Carson

Contributors
Alex Caminals
Emma Gorgori
Gianluca Nacci
Oswaldo Salazar
Jose Antonio Hernandez
Moïse Kameni

 

Produce reports with style using Cascading Style Sheets
Author: Oswaldo Salazar

Siebel Analytics Answers gives developers additional flexibility to customize the appearance of reports by using Cascading Style Sheets (CSS). Use CSS in conjunction with Font, Cell and Border formatting options to achieve personalized reports.

How it works

Follow these steps to apply CSS styles:

  1. Create a report in Siebel Analytics Answers.
  2. Click on the “Format Column” icon    on the column you wish to format.
  3. Expand the “Advanced Style Options (CSS)” menu and check the “Use Custom CSS Style“ option.
  4. Enter CSS property settings.
  5. Save your changes.

Go to top


Custom drill-downs simplified
Author: Oswaldo Salazar

Navigation—or drill-down—in Siebel Analytics is usually determined by the configuration of the business model in the Analytics Server. However, Siebel Analytics Answers provides developers with a handy feature that allows for the creation of custom navigation.

How it works

Let’s assume that you have created a report, let’s call it Report 1, in Siebel Answers and you would like to drill-down to a second report, let’s call it Report 2, by clicking on a specific column. Follow these steps to achieve the desired results:

  • Create a source report (Report 1) in Siebel Answers. This is the report from which you will drill down.
  • Create a target report (Report 2) in Siebel Answers. This report will be the destination report used when drilling down from the source (Report 1). In addition, the target report (Report 2) will be filtered by the value passed when clicking on Report 1. Make sure that both reports use common column names or variables.
  • In Report 1, click on the “Format Column” button for the column from which you would like to drill down. Next select the “Navigate to another request or Dashboard” option, browse to locate the target report (Report 2) and save your changes
  • In Report 2, click on the “Add Filter” button for the column you would like the filter to be applied. In the “Operator” list choose “Is Prompted” and save your changes.

Go to top