QPR Knowledge Base 2012.1

OLAP Mass Import

OLAP Mass Import

Previous topic Next topic  

OLAP Mass Import

Previous topic Next topic  

From the Integration View, you can perform a OLAP mass import. In other words, you can import many values at once using this feature. You can import values for one measure and all series, for all measures and one specific series or for all measures and all series.

 

This is where element identifiers and series identifiers become crucial. These identifiers are used during the mass importing process. For example, if in the database the value "3.2" is associated with the element identifier "MEA168", then this value will be imported into the element with the identifier "MEA168" in your model. For this reason, it is important that a mass import query produces results which contain columns for element identifier and series identifier.

 

 

To import values from an OLAP database, do the following:

 

1.Click the btn_integration_view Integration View button on the View tab of the ribbon. The Integration View window opens.
2.Select OLAP Mass Imports from the drop-down list.
3.Select the New... button. The OLAP Mass Import window opens.
4.Select whether to use a local or a server data source for the import.
5.Define a name for the import into the Task name field.
6.Type in a valid Connection string or click the Configure button to open the Connection Parameters window.
7.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.
8.In the Query field, type the query you want to execute.
9.Click Execute.
10.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.

 

 

11.In the Values in column drop-down list, select the column from which the value will be imported.
12.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.
13.In the Scorecard drop-down list, you can define a scorecard identifier that will be used with the import. If the scorecard identifier is defined, the import target will be defined by the scorecard + element combination. The scorecard identifier can also be left undefined, in which case the import target will be defined solely based on the element identifier. However, you can also define the scorecard identifier even if all rows in the imported data do not contain a scorecard identifier. In those cases rows with an empty  scorecard identifier are matched only by the element identifiers.
14.In the Element drop-down list, select the column containing the element identifiers which serve as the element ID's. It is also possible to select an element from the current model by choosing the Select element from model option in the drop-down list.
15.In the Series  drop-down list, select the column containing the series identifiers which serve as the series ID's. It is also possible to select a series from the current model by choosing the Select series from model option in the drop-down list.

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.

 

Note: Values cannot be imported to series that have a formula as their input type. In the case you try such an import, an error message is written to the log file.