QPR Knowledge Base 2012.1

OLAP Import

OLAP Import

Previous topic Next topic  

OLAP Import

Previous topic Next topic  

You can import element values from an OLAP provider. To do this, you need to write a query that retrieves the data. The imported data is displayed in columns in the Imported Values tab, where you can specify which column you want to assign with the value and the period of your element. This value will be specified for the current element and series. In addition, this value can be specified for periods as well.

 

Once you have written the query, you can choose to execute it interactively or scheduled. A scheduled query will be executed later at regular intervals of your choice, for example on a weekly or monthly basis.

 

To import more than one value at a time, OLAP Mass Importing is also available.

 

Before the OLAP Import

Before you start an OLAP import, you need to make sure that MDAC (Microsoft Data Access Components) is installed on your system. You also need to know the name of the provider from which you are importing, as well as the user name and password for it. Contact your system administrator for this information.

 

 

Local and Server Imports

You can choose to import data from a local OLAP provider or a server OLAP provider. Note that the schedule function is only available for server imports.

 

Importing a Value from OLAP Databases

To import a value from an OLAP database, do the following:

 

1.Open the Element Properties window and select the Values tab.
2.In the Values tab, select the series for which you would like to import the value.
3.Right-click over the column of the selected series to open a pop-up menu and select the OLAP Import option in the Input Type submenu.
4.Select the Define... option from the pop-up menu described in the previous tab. The OLAP Import window opens with the Import Settings tab displayed.
5.Select whether to use a local or a server data source for the import.
6.Define a name for the import into the Task name field.
7.Type in a valid Connection string or click the Configure button to open the Connection Parameters window.
8.After defining the settings for the connection, close the Connection Parameters window and click the Test Connection button in the Import Settings tab to verify that the connection is working properly.
9.In the Query field, type the query you want to execute.
10.Click Execute.
11.When the import is ready, the Imported Values tab is displayed with the values imported from the database.

Note: The values which have been selected from the database and displayed in the Imported Values tab can be overwritten within the Imported Values tab.

 

 

12.In the Values in column drop-down list, select the column from which the value will be imported.
13.In the Periods in column drop-down list, select the column that holds the period to be used. You can define the period in three ways: By period index, by period name, or by date. To define a period index, prefix the value with a #, i.e. "#5" would make the value to be imported to the fifth period. To define the target period by the period name, prefix the value with a $, e.g. "$Q3/2009". To define the period by a date, input the date without any special control characters. If you leave this field undefined, then by default, the current period is assigned as the period.
14.The Element and Series fields display the names of the element and series into which the value is being imported. Click the Select Series and Select Element buttons to define the target element and series.
15.Select the Save button to complete the import. The value is now displayed in the Value field, for the specified Period.

 

Note: If the value column that is displayed in the Imported Values tab contains more than one row for the same measure and series, then the last value in the column is the one that is used.

 

dlg_olap_import

The OLAP Import Window