QPR Knowledge Base

Schedule SQL and OLAP Import

Hide Navigation Pane

Schedule SQL and OLAP Import

Previous topic Next topic No expanding text in this topic  

Schedule SQL and OLAP Import

Previous topic Next topic JavaScript is required for expanding text Mail us feedback on this topic!  

Comments (...)

When performing either an SQL import or an OLAP import, you can schedule the task to occur on a certain day of a period or at intervals (on a specified date and time). This is helpful for automatically updating your model to contain the latest values of your company database. For example, you can schedule the import to run every night and thereby automatically update your model every night.

 

 

Defining Scheduled Imports from SQL or OLAP Databases

To define a scheduled import from an SQL or OLAP database, do the following:

 

1.Open the Element Properties window and click the Value tab.
2.In the Value tab, select a series and select either SQL Import or OLAP import  from the Input type for selected series: drop-down menu. Then click the Define... button. The SQL or OLAP Import window is displayed. Select the Scheduled tab.
3.Select the Scheduled check box (to specify that the import will be a scheduled one). In the case you are editing multiple imports, the initial appearance of the checkbox indicates the current scheduling status of the selection in the following way:
Checkbox checked: All selected imports are scheduled
Checkbox not checked: None of the selected imports are scheduled
Checkbox checked, but grayed: Some of the selected imports are scheduled
4.Type the starting date of the import in the Start Date field. You can also select the date from the calendar that opens when you click the arrow in the Start Date field.
5.Type the starting time of the import in the Start Time field.
6.If this import has previously been specified as scheduled, the Last Executed and Status information will be displayed in the corresponding fields.
7.In the Scheduling based on box, select to either base the import interval on the Period of the Element or on the Calendar Time.
8.If you have selected to schedule based on the Period of the Element, specify the Day of Period on which the import will occur. If you have selected to schedule based on the Calendar time, select the Interval after which the import will occur, in days. For example, if you select 7, the import will be executed every seven days.
9.In the Values in column and the Periods in column fields, specify the column title and its corresponding number, which is assigned by its order in the columns displayed in the Imported Values tab. Note that period information for the series is optional.
10.In the Scorecard field, you can define a scorecard symbol that will be used with the import. If the scorecard symbol is defined, the import target will be defined by the Scorecard + Element combination. However, mainly for backwards compatibility, the Scorecard column can be left undefined (i.e. the "Select column for scorecard symbol" option is chosen) and the import will be done based solely on the Element information.
11.The Element and Series which correspond to the current values are shown in these fields.
12.If all the above information is correct, click the Save button. The import is now set to be performed at the scheduled intervals.

 

If you want to cancel a scheduled import before it is executed, remove the selection from the Scheduled check box and click Save Settings. To see all the scheduled tasks,  click the btn_integration_view Integration View button on the View tab of the ribbon.

 

 

Note: Changing SQL Import settings (DB alias, password, user name, SQL script, value column or date column) requires that user disables the scheduling first. You can view the list of scheduled SQL and OLAP imports from the Integration View.

 

Comments (...)