How To Create Separate Named Datasource For Siebel BI Publisher Reports With Large Data Volume

Please follow the step-by-step instructions given below:

1. Create a New Profile (Named Subsystem) by cloning the existing Server Datasource Profile. (You can  use the Siebel Copy Record feature to do that)

Refer: Siebel Bookshelf: Siebel System Administration Guide > Configuring Siebel Servers > Configuring the Siebel Enterprise Server >Creating Siebel Enterprise Server Named Subsystems

2. Enter the following values for the new profile:

Name	Value
Profile	Report Datasource
Alias	RptDataSrc
Subsystem Type	InfraDatasources
Description	Reports Datasource used for BIP Reporting

3. In the Profile Parameters specify all the parameters same as the Server Datasource profile. 

Name	Alias	Value
Chart Image Format	DSChartImageFormat	$(ChartImageFormat)
Chart Server	DSChartServer	$(ChartServer)
Database current SQLID	DSCurrentSQLID	$(CurrentSQLID)
Data source Connect String	DSConnectString	<ODBC Connect String>
DB Connector DLL	DSDLLName	<DB Connector DLL Name> e.g. sscdms80 for MS SQL Server
Datasource Docked Flag	DSDockedFlg	True
Datasource Table Owner	DSTableOwner	<Table Owner Name>

Click on the Advanced button and set the following parameters:

Name	Alias	Value
SQL Style	DSSQLStyle	<Sql Style> e.g. MSSqlServer for Windows SQL Server
Datasource Enterprise Server	DSEnterpriseServer	<Enterprise Server Name>
Datasource maximum fetch array size	DSMaxFetchArraySize	-1

Click on the Hidden button and set the following parameters:

Name	Alias	Value
Datasource Gateway Server	DSGatewayAddress	<siebelgatewayhostname>:2320

4. Navigate to the Administration - Server Configuration > Enterprises > Component Definitions view. Query for XMLP Report Server component.

5. Click on the pull down menu and select Start Reconfiguration.

6. In the Component Parameters list applet set following parameters:

Parameter	Value
OM - Data Source	RptDataSrc
OM - Named Data Source name	RptDataSrc,GatewayDataSrc

7. Click on the pull down menu in the Component Definitions applet and select Commit Configuration.

8. Hit the Synchronize button under the Component Definitions.

9. Restart Siebel Server and Gateway Services.

10. Log into the Siebel CRM Application as Siebel Administrator and ensure that the XMLP Report Server component is 'Online'.

11. Verify that the new parameters are in effect:    

• Navigate to Site Map > Administration - Server Configuration > Servers > Components
• In the Component Parameters list applet verify the following parameter values:
• OM - Data Source : RptDataSrc
• OM - Named Data Source name : RptDataSrc,GatewayDataSrc

   
Report Scheduling and Large Data Volume

Siebel BI Publisher Reports Scheduling feature makes use of the EAI Object Manager to fetch the report data from Siebel by invoking the inbound web service named BIPDataService. For scheduled reports to run on large data sets, the EAI Object Manager component should also be configured to use the Reports Data Source (as mentioned above).

Follow the steps given below in case you are using the Siebel BI Publisher Reports Scheduling feature:

1. Log into Siebel CRM Application as Siebel Administrator.

2. Navigate to the Administration - Server Configuration > Enterprises > Component Definitions view.

3. Query for EAI Object Manager component.

4. Click on the pull down menu and select Start Reconfiguration.

5. In the Component Parameters list applet set following parameters:

Parameter	Value
OM - Data Source	RptDataSrc
OM - Named Data Source name	RptDataSrc,GatewayDataSrc

6. Click on the pull down menu in the Component Definitions applet and select Commit Configuration.

7. Hit the Synchronize button under the Component Definitions.

8. Restart Siebel Server and Gateway Services.

Improving the performance of Siebel BI Publisher Report generation

Improving the performance of Siebel BI Publisher Report generation

1) Increasing the amount of heap memory available to the Java Virtual Machine (JVM)

Increasing the memory available to the JVM can improve the performance of the report generation and ensure that this error is not encountered.

 "C:\OraHome_1\jdk\bin\java" -XX:MaxPermSize=128m -Xms512m -Xmx512m -Duser.language=en -Duser.dir=C:\OraHome_1\oc4j_bi\bin -Duser.country=US -jar "%OC4J_JAR%" %CMDARGS%

OS	Memory Value
Windows (32-Bit)	Any value of up to 1.4GB (based on available RAM)
Windows (64-Bit)	1.4 GB or higher (based on available RAM

2) Changing the Server Request Processor DB Polling Interval

By decreasing the polling interval the Server Request Processor can check the S_SRM_REQUEST table more regularly thereby reducing the period before the request processing is started. Once the change has been made it is necessary to shutdown and restart the affected Siebel Server before the change will take effect.It is recommended that this change be made only on the Siebel Servers hosting the XMLPReportServer component as this change will result in an increased number of queries being issued against the S_SRM_REQUEST table in the database.

change param PollIntvl=1 for comp SRProc

3) Minimize the size of Integration Objects/Components 

An excessive number of unrequired fields in the report will lead to increased data generation times from the XMLPReportServer component and will result in an increased data file size for BI Publisher to process.

4) Minimal Force Active fields on  BC- 

Ensuring that a minimal number of fields are flagged as Force Active will help to ensure that the number of fields being returned when querying against the Integration Component for report generation is further reduced.

5) XMLPReportServer PreloadSRF parameter to TRUE 

Prelolading the SRF into the process ensures that any performance overhead during the SRF load is encountered during component startup and not during report processing. This parameter is listed under Advanced tab.

6) Inactive Web Services not used in Enterprise 

Due to Bug 10587893 at present the component will load all of the active webservices configured in the enterprise rather than just those which it may access, such as PublicReportService or PublicReportService_v11. This leads to a performance overhead during the first report request for any process as these can take a significant period of time to load. In order to reduce the impact of this loading process review the webservices configured as 'Active' in the Siebel Enterprise through the Administration - WebServices > Outbound Webservices and Inbound Webservices views.  Set any webservices which are not used in the enterprise to 'Inactive'..

7) Minimize logging levels on all report generation components

This will include the requesting Object Manager, the XMLPReportServer component, the EAI Object Manager, the File System Manager component, and the BI Publisher Server itself.

8) Eliminate any un-necessary scripting during report generation

9) Create Separate Named Datasource For Siebel BI Publisher Reports With Large Data Volume

Generating Large Reports (over 10,000 records) - When running report generation there may be scenarios in which more than 10,000 records need to be retrieved. The standard ServerDataSrc within the Siebel Enterprise has a row limit of 10,000 for any single query and therefore in order to support large report generation a custom data source is required without this restriction. The following post covers this requirement in detail :

How To Create Separate Named Datasource For Siebel BI Publisher Reports With Large Data Volume