XE provides a currency data API and if you have an account with them, you can use their API to pull data for use in your database tables and cubes. Below is a link to an example utility process that pulls mid-market currency rates from their API and populates a database table...
Hi Everyone,
On MODLR, you can now interact with an FTP server using the new FTP process functions. The FTP feature is available starting with Build 2.4.524.
To get started, you first need to establish an FTP connection using the FTP function ftp.Connect():
const client = ftp.Connect("sftp"...
If you want to filter by a specific dimension, here is an extended version:
Copy Scenario Process Script - Extended
The dimension must exist on the cube for this to work.
Imagine that on the model, we have the following model variables:
Month.Current Month
Year.Current Year
Create a custom process script and under the pre() function, prompt the user for the values:
function pre() {
//this function is called once before the processes is executed.
//Use...