|Oracle® Business Intelligence Applications Installation and Configuration Guide
It contains the following topics:
Oracle Sales Analytics is a comprehensive analytical solution that provides timely, fact-based insight into the entire sales process. It provides new levels of information richness, usability, and reach to sales professionals throughout the enterprise and in the field. All users, from sales executives to front-line sales representatives, get up-to-the-moment, complete, and in-context sales insight; insight that is personalized, relevant, and actionable. The benefits are faster and more informed decisions that help the sales organization compete more effectively, lower sales costs, and achieve better results.
This section contains configuration steps that you need to perform on Oracle Sales Analytics before you do a full data load, and contains the following topics:
Stored procedures are a group of SQL statements that perform particular tasks on the database. For example, stored procedures can help to improve the performance of the database. You deploy stored procedures by copying the stored procedure files from your Oracle BI Analytics installation and deploying them to the target data warehouse.
Note: Some sessions may fail if these procedures are not compiled in the database before running the workflows.
To deploy stored procedures:
Navigate to the OracleBI\dwrep\Informatica\Stored_Procedure_Scripts folder.
Open one of the folders based your database platform, and copy the source code from the file FIND_AUDIT_VALUES.sql into the target data warehouse schema.
Compile the stored procedures in the target data warehouse database.
Note: If you have problems deploying the stored procedures, see your database reference guide, or contact your database administrator.
This sections contains additional configuration steps for Oracle Sales Analytics, and contains the following topics:
Even though the snapshot of Pipeline is captured every time ETL is run, you can choose to persist daily snapshots, or weekly snapshots or monthly snapshots or even yearly snapshots. There is one parameter you need to modify to configure for this. This parameter is called "GRAIN".
The GRAIN parameter has a preconfigured value of 'DAY'. The possible values for the GRAIN parameter are:
To configure the snapshot frequency in Pipeline fact:
Open the parameterfileDW.txt file using a text editor in the OracleBI\DAC\Informatica\parameters\input folder.
Locate [SIL_PipelineFact] and $$GRAIN
Replace the default parameter value with your new value.
Note: You need to use single quotes for the value.
Save and close the file.