Filename substitution formula in Data Readers

Sergi Fernández

Hello everyone,

It could be useful for developers to have the following functionality implemented in Board:

A new substitution formula @filename that returns the name of the file being loaded in the Data Reader. This formula could then be used in the ETL.

Usage example:

The client's cubes have the dimension "Month of Load", and the data files include the suffix "_YYYYMM" to indicate the month in which the data extraction was made.

• With @filename, we could write a simple formula "RIGHT(@filename,2)" in the ETL of the Data Reader to classify the data. Allowing us to load several files in the same Data Reader.
• Without @filename, we would have to either load the data manually and changing the corresponding month in the ETL on each load. Or we would have to create 12 different Data Readers for each cube.

Thank you,

Best regards,