Loading selective data

To load selective data, you must use custom settings 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.

After you added or imported a custom setting, select d/EPM Administration > 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>
```
Click Save and then click Load and Load Data.
Select d/EPM Administration > 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.