Work with Jobs in Cube Designer

Use the Cube Designer Job Viewer to view, monitor and troubleshoot jobs that you run from your particular client. Jobs are operations such as data loads, dimension builds, and calculations.

A record of all Essbase jobs is maintained in the Essbase instance. Each job has a unique ID number.

The jobs listed in the Job Viewer are for one specific user. If a different user logs into the client, then only jobs for that user are displayed.

View Jobs in the Cube Designer Job Viewer

You can view jobs for the specific user that is logged into the client in the Cube Designer Job Viewer.

In Excel, on the Cube Designer ribbon, click View Jobs .

The Job Viewer dialog box opens, showing a list of jobs that have been run from that particular client.

Monitor Cube Designer Jobs

The Cube Designer ribbon shows when a job is in progress. After the job finishes, you can view the status of the job in the Cube Designer Job Viewer.

• While a job is running, the View Jobs icon on the Cube Designer ribbon displays an hourglass .

• When the job finishes running a Job Viewer status dialog box displays, indicating the status of the job.

If you close Excel while the job is running, the job continues to run, but you will not see a status dialog when it finishes. The job is a server process, so it runs regardless of whether Excel is open or not.

Troubleshoot Jobs in the Cube Designer Job Viewer

If a job fails, you can view and troubleshoot errors.

1. In Job Viewer dialog box, select a job and click Details to see the job details.

2. In the Job Details dialog box, select a file from the Server Error Files drop-down menu and click Open to view and troubleshoot errors.

Clear and Archive Cube Designer Jobs

Clear the Job Viewer or archive job viewer logs periodically to improve performance.

• Press Clear All to remove all jobs from the Job Viewer dialog box.

• To selectively remove individual jobs, select one or more jobs and press the Delete key.

  • Use the Shift key to select multiple contiguous jobs.

  • Use the Ctrl key to select multiple non-contiguous jobs.

• To archive the job viewer logs, copy and rename the log file and then delete the original.

  Job viewer logs are located in C:\Users\username\AppData\Roaming\Oracle\SmartView\DBX\Jobs.

  There is a separate log for each user on the client machine.

Removing jobs from the Job Viewer dialog box or archiving job viewer logs only affects the client. You can still view all jobs in the web interface.