OLAP

Source filtering for cube mappings

You can filter the source table data while loading values into a cube. Use the new Source Column Filter column of the mapping definition to restrict the data to one or more elements of a dimension. To separate multiple elements of a dimension, use the pipe symbol (|). The use of parameters and custom settings is also supported.

To load only the latest data of a source table, you can use the Process latest records filter. To use this filter, the source table must have a column with a timestamp or counter.