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.


Overcome Error while Checkout

A common error encountered while doing an object Checkout/Get is –
Siebel-ERR-1109: Unable to read value from export file (Data length (4) > Column definition (1));
 
Solution :
 
Siebel Tools error during checkout / get are almost associated with the local repository having a different schema. In general,  to resolve this issue, we generate a new database template and do a database extract.

Object Locking using Developer logins

Unable to enable object lock with other configured administrator user than SADMIN. For each project you can specify whether or not developers are allowed to check out and check in individual objects within the project. To allow developers to check out and check in objects, you set the project's Allow Object Locking property to TRUE. To modify the Allow Object Locking property, you must use the SADMIN user ID to log in and you must be logged into a server data source.

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


Pages

Subscribe to Universal Remote Codes TV RSS