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.
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.
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 sta