Siebel

Siebel uses Denormalized Columns to improve the performance of query operation in view where data visibility is restricted using Siebel View modes like Organization, Position etc. Denormalized columns are generally created for columns most frequen

The Print and Export options are available in Application File Menus, Applet Menus and Toolbar buttons (i.e. Quick Print Icon ). The Print option is centrally controlled in Siebel by the built-in Business Service (BS) “PrintListService”. This BS needs some code to be included to disable the print. But there is no such central place to add code to disable Export data option, this is a Siebel Product limitation.
 

There would have been umpteen number of situations where you might have felt the need for an easier way of debugging profile attributes than logging the values in a script, haven't you?.If yes, then here is a much simpler way and you can do this on the fly.
When the web client is up, replace the URL with the following script:

Scenario : Need to fill email/sms/fax template content substituted via scripting.

In Siebel Workflow, there is no function for a carriage return line feed. So, if we want to populate a text field and format the contents so that they appear on separate lines, there is no simple way to do it.

To constrain the list of values of a picklist field (Eg: ‘Status’) based on another picklist (Eg: ‘Type’) field value of business component (Eg: ‘Contact’) in multi organization environment.

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.

PDQ refers to Pre Defined Queries, as the name speaks for itself these are the saved queries in Siebel application.

In most implementations, a high number of indexes already exist on some of the tables (such as, S_OPTY) and you must be careful not to add too many indexes. A new index can fix one query but may slow down another.

When creating the database session, the Siebel database connector makes the following session level changes