Siebel Analytics & OBIEE

Siebel Analytics Web Services

Siebel Analytics provides a Simple Object Access Protocol (SOAP) programming interface to extract and deliver data and manage the content of the Siebel Analytics Web Catalog. This document gives an overview on how to use this functionality to show a Siebel Analytics report in a HTML page.

Time zone implementation for Oracle BI reporting

To implement multiple Time zone implementations, one has to modify the instanceconfig.xml to invoke certain OOB features available with OBI implementation.

Things to consider before implementing multiple time zones:

  • Data obtained from the source systems have to be stored in GMT in the OLAP Database.

Analytics Password Automation

There have been cases in analytics repository migration where the entire repository (popularly known as rpd in the developers circle) files needs to be moved to other environments due to code merge issues or developers not adhering to coding standards or due to any unforeseen issues.

Generating user and group list from Analytics Repository using VB Script

Default analytics repository based authentication get a little tedious to generate the list of users and associated groups via the manual process. To simply this, a VB Script can be written and used to generate the list of users and associated groups. This script uses the UDML export of the repository to generate the list in text file.
 
This text file is a delimited format file, which can be imported to Microsoft Excel for further analysis.

Report Formatting by editing XML in Oracle BI

Pivot Tables in Siebel Analytics and Oracle BI does not provide option to display more than one decimal place in the report out-of-box. The business might need more for their analysis. To display more decimal places, the report XML can be edited. This can be done using advanced tab and changing the attributes minDigits and maxDigits in XML as shown below.

E.g.

ETL - Performance Improvement Tips

ETL jobs run every day to pull data from Transactional OLTP database Servers and Load Analytical OLAP warehouse data bases takes more time than its expected, Follwing are tips that will help you improve the ETL performance.
Following are the daily running ETLs along with the current (before applying Improvement Tips) timings:-

ETL Name

Report Formatting by editing XML in Oracle BI

Pivot Tables in Siebel Analytics and Oracle BI does not provide option to display more than one decimal place in the report out-of-box. The business might need more for their analysis.

To display more decimal places, the report XML can be edited. This can be done using advanced tab and changing the attributes minDigits and maxDigits in XML as shown below.