Generating user and group list from Analytics Repository using VB Script
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.
Overcome Error while Checkout
Object Locking using Developer logins
Enabling Users to change Password for Siebel Application
To Enable the Users to change Password for Siebel Application follow below instructions. By Using this particular feature, user can change their password for Siebel Application which will be propagated to the Database as well.
To get the Change password fields enabled for the Web Client:
Handling Invalid/Unusable Siebel Index
Indexes are available on the Siebel base tables to improve performance and also to maintain the data integrity. The purpose of adding index is to help the database to search records quickly and efficiently. It’s very essential to make sure that Siebel Indexes are in active and valid state.
Scenario :
Apply and Activate on Local Database causes Tools Application to Hang
Connected to the local database with the user id and password for the local user; while applying with the correct ODBC connection and the process initiates for a minute, and then Siebel tools automatically closes; In another machine, the process initiates and the application hangs forever, tried giving many other options w.r.t different user id's and passwords but did not work. Also tried out with SIEBEL/Local user Password, DBA/Enterprise Server Name and all in vain.
Monitoring the status of Siebel Server components
Monitor the status of Siebel Server components that are essential to keep the application up and running has to be performed manually which will be person dependent task
Solution :
An automated batch job (VBS/Shell/BAT) that monitors the Siebel components that can be scheduled to run as per need.
Email notifications will be sent to the respective team alerting on the component state
Benefits :
Scheduled to run on demand