Adding the date of a REST API run?

Hi,

I am planning to use the REST API- support to import data into one of my cubes. This will replace a manual Excel import we currently use. The current Excel’s contain a column giving the date of the export. In other words: this column is not part of the original system as such but it is used to report the original’s system state at a given point in time. Is there a way to add this in the mapping?

Hi,

You can create a caluclated column in the REST API data source with the code returnign current date:

The Javascript code giving the date of import:

Kindly,
Janis, eazyBI support