QPR Knowledge Base

OLAP Mass Import

Hide Navigation Pane

OLAP Mass Import

Previous topic Next topic No expanding text in this topic  

OLAP Mass Import

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

Comments (...)

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 symbols and series symbols become crucial. These symbols are used as identifiers during the mass importing process. For example, if in the database the value "3.2" is associated with the element symbol "MEA168", then this value will be imported into the element with the symbol "MEA168" in your model. For this reason, it is important that a mass import query produces results which contain columns for element symbol and series symbol.

 

 

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 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. The scorecard symbol can also be left undefined, in which case the import target will be defined solely based on the element symbol. However, you can also define the scorecard symbol even if all rows in the imported data do not contain a scorecard symbol. In those cases rows with an empty  scorecard symbol are matched only by the element symbols.
14.In the Element drop-down list, select the column containing the element symbols 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 symbols 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.

Comments (...)