Scheduling Automatic Database Generation

  To schedule automatic generation:

1. Navigate to install\Middleware\user_projects\
   epmsystem1\HPS\hps1\hpsfiles\bin\generate_cube and open GenerateCube.bat.

2. Open the file in a text editor.

3. Modify set <entry> = value For example, set HPS_Server=mainserver

   This table identifies the entries you can change. Even if you do not generate an Essbase database, leave a value for the Integration Services and Essbase related entries. To generate the Star Schema, you must specify values listed in the Required column of the following table. Other entries are used to generate the multidimensional database only.

   Table 11. GenerateCube Entries 

   Required	Entry	Required	Type	Description
   x	JAVA_HOME	Yes	Directory	JRE installation directory
   x	HPS_SERVER	Yes	String	Name of the computer running Performance Scorecard
   x	HPS_PORT	Yes	Integer > 0	Port that Scorecard is listening to. By default, this port is 18080.
   x	HPS_APPLICATION	Yes	String	Name of the Performance Scorecard web application specified during deployment.
   x	XML_FILE	Yes	Directory + Filename	Directory containing the XML files required by Oracle Essbase Integration Services to create the Essbase database
   	ESSBASE_SERVER	No	String	Name of the computer running the Essbase server
   	ESSBASE_ APPLICATION	No	String	Name of the Essbase application under which the generated database will be placed. The name must not exceed 8 characters and must conform to the Essbase Naming Conventions.
   	ESSBASE_CUBE	No	String	Name for the Essbase database to be generated. The name must not exceed 8 characters and must conform to the Essbase Naming Conventions.
   	SOURCE_DSN	No	String	Name of the ODBC connection to the Performance Scorecard database
   	CATALOG_DSN	No	String	Name of ODBC connection to the AIS Catalog database
   x	GENERATE_CUBE	Yes	Boolean	True to generate the Essbase database False to only generate the Star Schema tables.
   	cubeMeasure	No	String	Generate the Essbase database using the hierarchical structure.
   	cubeWeights	No	String	Generate the Essbase database with Weights included.
   x	FROM_DATE	Yes	Date	Enter the start date for which database rows are generated in yyyy/MM/dd format.
   x	TO_DATE	Yes	Date	Enter the last date for which the database rows are generated, in yyyy/MM/dd format
   	CONFORM_TO_ ESSBASE_NAMING	No	Boolean	TRUE to modify measure and scorecard names to conform to Essbase naming rules.
   x	ROW_FREQUENCY	Yes	Integer	0 - Generate Star Schema rows only when result, targets or scores change 1 - Generate rows based on a frequency. You must complete these fields: FREQUENCY_CODE SUB_FREQUENCY_CODE INTERVAL DAY_OF_PERIOD 2 - Generate a row for every day
   x	FREQUENCY_ CODE	Yes	Integer	Required if ROW_FREQUENCY = 1. Enter the value for the frequency type: 0 - None 1 - Daily 2 - Daily MF (Monday to Friday, excluding weekends) 3 - Weekly 4 - Semi-Monthly 5 - Monthly 6 - Quarterly 7 - Semi-Annually 8 - Annually 9 - Monthly, Week Based
   x	SUB_FREQUENCY_ CODE	Yes	Integer	Required if ROW_FREQUENCY = 1. Enter the value for the sub-frequency type: 0 - First 1 - Last 2 - Sunday 3 - Monday 4 - Tuesday 5 - Wednesday 6 - Thursday 7 - Friday 8 - Saturday 9 - First Sunday 10 - First Monday 11 - First Tuesday 12 - First Wednesday 13 - First Thursday 14 - First Friday 15 - First Saturday 16 - Last Sunday 17 -Last Monday 18 - Last Tuesday 19 - Last Wednesday 20 - Last Thursday 21 - Last Friday 22 - Last Saturday 23 - User Defined 24 - No Weekend
   x	INTERVAL	Yes	Integer	Required if ROW_FREQUENCY = 1. Enter the value for the interval. The value must be greater than 0.
   x	DAY_OF_PERIOD	Yes	Integer	Required if ROW_FREQUENCY = 1. Enter the value for the sub-frequency type in the format “x day of period.” The value must be greater than 0.
   x	LOG_LEVEL	Yes	String	Level of information provided about the generation process: ERROR WARN INFO DEBUG

4. Save the file.

5. Schedule the database generation. Select Start, then Programs, then Accessories, then System Tools, then Scheduled Tasks, and then Add Scheduled Task. The Scheduled Task Wizard is displayed.

6. Follow the prompts to create a schedule. This includes navigating to the GenerateCube file, selecting a frequency, and specify a start date and time.