Once a view has been properly configured it can be scheduled for automatic export to a QlikView (QVX), Comma Separated Values (CSV), or a tab delimited (TXT) file. To access the scheduler, click on the Scheduler icon in the view toolbar. You will see a screen similar to the one shown below:
If this view has not been previously executed, the filename will be automatically populated with the name of the file the data is to be exported to.
|
NOTE: This file will be placed in the export directory specified during installation. You can use the TM1Connect configuration manager to change this setting. |
Once the filename has been supplied, you can set up the scheduler to automatically execute the export on a future date and time by setting enabling the schedule and setting the options, or you can click on the Save and Run Now button. The Save and Run Now will immediately queue a request for export with the TM1Connect data agent.
Export Execution Status
When you first open the scheduler screen, you will be presented with an execution status of the last export that was run (if previously executed). The date and time along with the filename and size of the QVX file (if the file exists) will be shown here. It will also display the status of the TM1Connect data agent for that file, whether it is waiting, running, succeeded or failed.
If an error occurs, you can check the TM1Connect error log for details of the failure, and the TM1 Message Log for additional details (if needed).
|
NOTE: TM1Connect uses a dynamically created Turbo Integrator process specifically optimized for maximizing the speed of exporting data that is used to create the QVX file. Under normal circumstances this process is not visible in TM1, however the execution of that can be seen in the message log similar to the following example: |
Scheduling Extracts
The scheduler allows for various execution schedules, including the ability to execute and run immediately. The available scheduling options are:
One-Time execution mode will execute the export on the specified date and time selected. No other executions will occur until the schedule is updated.
|
Daily allows you to select a date that the export is to begin and then the frequency (in hours or days) of which the export is to recur.
|
Weekly execution provides for the view to be extracted on regular weekly intervals occurring on specific days of the week to be repeated each specified week. With this schedule you can create exports such as Monday of every week, or Tuesday of every other week, etc.
|
Monthly scheduler has two modes of operation: On a specific day of the month, or on a relative day of the month.
With a specific day of the month, you can schedule extracts on the 3rd day of every month, or the last day of each quarter.
With relative scheduling, you can choose dates such as the second Tuesday of each month, or the first Friday of summer months.
|
Once a view has been scheduled for export, the navigation pane will now display a clock icon to indicate that the view is scheduled.
