OBIEE Interview Questions and Answers FAQ
1. Define repository in terms of Siebel Analytics
1. Define repository in terms of Siebel Analytics
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.
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.
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 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 |
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.