SAS OLAP Cube Jobs

SAS OLAP Cube Jobs

When you create a cube definition in SAS OLAP Cube Studio, a cube job is automatically created for that cube. A job is a collection of SAS tasks that create output. The cube job is the metadata that links a cube to its load data table. This can be a detail table, a fact table, or a fully summarized table. The cube job also contains a classifier map in the metadata which links the columns in the load table to the levels, measures, and member properties for the cube.
Note: The cube job does not link the star schema dimension tables or the aggregation tables to the cube.
After a cube definition and the cube job is created, you can perform the following tasks:
  • deploy and redeploy a cube job for scheduling
  • export a SAS package
  • view the properties for a cube job
When you deploy a cube job, the code needed to create the cube is generated. It is then stored in a file in the specified deployment directory. In addition, a deployed job object is created. This new object is linked to the original cube job and it can be added to a SAS flow for scheduling. You can also now redeploy the job as needed.

Cube Job Deployment and Redeployment

SAS OLAP cube jobs are deployed to create cubes and are listed in the Job (cube) folder under the Inventory tab of the Tree View. To deploy a cube job, select the job in the Tree View and select Actionsthen selectDeploy. The Deploy a job for scheduling dialog box appears. From here you can enter information about the job. If the job is deployed successfully, you receive a confirmation message.
The deployed job is then listed in the Deployed job folder in the Tree View. Each time you deploy a job, a separate deployed job object is created and listed in the Deployed job folder. For example: If you deploy a SAS cube job based on the cube "Sales", the deployed job is labeled as "Sales". If you deploy that same cube job again, the next deployed job is labeled "Sales000". Deploy the cube job a third time and it is labeled "Sales001".
Note: Deployed jobs for a cube job can also be accessed from that job's context menu. Right-click on the cube job and select Scheduling. The deployed jobs are listed in the Scheduling drop-down list. A deployed cube job can also be redeployed after the initial deployment. Select a deployed cube job from the Deployed job folder in the Tree View. Then, select Actionsthen selectRedeploy.

Job and Deployed Job Properties

Job Properties

In SAS OLAP Cube Studio, you can view the properties for an OLAP cube job or a deployed job. Select a job from the Tree View and select Properties from the Edit menu or from the job's context menu. The Properties dialog box then opens. A cube job has the same standard dialog box tabs as other cube objects. In addition, it also contains the following tabs:
Process
The Process tab contains options to specify how the job's code is generated (Code Generation).
Pre and Post Process
The Pre and Post Process tab contains options to insert user-written code at the beginning or end of the current job.

Deployed Job Properties

A deployed job has the same standard dialog box tabs as other cube objects. It also contains the Scheduling Details tab for the deployment. This tab includes the command that is used to execute the current job in batch mode. It also includes the settings for the SAS Application Server that is used to deploy the job.