Loading selective data with use of custom settings

To load selective data, you can use custom settings or parameters, or both, and create a copy of the fact table with a _temp suffix in its name. The table must use an IncrementalLoad query.

You can add custom settings manually or import them.

Custom settings are used as variables to select data to load.

For example, you can create a CA_Adventurer custom setting with the value of 102, which relates to Tony Roast in the example from the "Best practices to load data from the source system to Infor EPM OLAP" topic and load data only for this one adventurer.

After you added or imported a custom setting, in EPM Administration, select Dashboards > Data Integrations > Relational Modeling.
Select the staging table with the _temp suffix and click the Load Queries tab.
In the Query Editor, copy the IncrementalLoad query.
Click Add and specify this information:
Name

Specify the name of the query.

Source Connection

Select Data Lake.

Description

Optionally, specify the description of the query.

What to do with conflicts?

The Update check box is selected by default. If selected, new records are added and existing records are updated.

Query Editor
Paste the copied query and replace the WHERE LastModified > '<<LAST_IMPORT>>' condition with this condition:
```
WHERE <dimension name> = @CustomSettings.<setting name>
```
For example:
```
SELECT [RecordID]
,[ID]
,[Calendar]
,[Adventurer]
,[Coffee]
,[Measure]
,[Value]
,[ModifyDate]
,CURRENT_TIMESTAMP AS dEPMLastModified
,'Actuals' AS Scenario
FROM ['CA_FactCoffeeAdventure']
WHERE Adventurer = @CustomSettings.CA_Adventurer
```
Click Save and then click Load and Load Data.
Select Dashboards > OLAP > Edit Database and select the application and then the appropriate cube.
Click the Mappings tab and then New Mapping.
On the Source tab, specify this information:

Mapping Name

Specify the mapping name.

Mapping Unique Name

Specify the mapping unique name.

Comment

Optionally, specify a comment about the facts mapping definition.

Data Connection

Select Staging.

Fact Table Name

Select the fact table with the _temp suffix.
Click the Column Mapping tab and specify this information:

Select Value Column Mode

The Single option is selected by default.

Value Column Name

Select Value.

Clear Cube Area

For the dimension to which to load data, specify @CustomSettings.<setting name>. For the Scenario dimension, specify Actuals.

Clear Values

This function is enabled by default. Keep it enabled.

Writing Mode

Select Add.
Click Save.