hash (optional) – String. Base64 string containing encoded username and password. hash is available if you connect to OLAP cube via Flexmonster Accelerator. Please use either username with password or hash, not both.

subquery – String. The parameter to set the server-side filter which helps to decrease the size of the response from the OLAP cube. For example, to show reports only for one specific year set subquery the following way: "subquery": "select {[Delivery Date].[Calendar].[Calendar Year].&[2008]} on columns from [Adventure Works]".

Here is how the connection to MSAS via XMLA represented in dataSource:

roles (optional) – String. Comma-delimited list of predefined roles to connect to a server or database using permissions conveyed by that role. If this property is omitted, all roles are used, and the effective permissions are the combination of all roles.

username (optional) – String. Username of the database user.

password (optional) – String. Password of the database user.

hash (optional) – String. Base64 string containing encoded username and password. hash is available if you connect to OLAP cube via Flexmonster Accelerator. Please use either username with password or hash, not both.

Here is how the connection to Mondrian via XMLA represented in dataSource:

dataSourceType – String. Type of data source. In this case it is "iccube".

proxyUrl – String. The path to proxy URL.

subquery – String. The parameter to set the server-side filter which helps to decrease the size of the response from the OLAP cube. For example, to show reports only for one specific year set subquery the following way: "subquery": "select {[Delivery Date].[Calendar].[Calendar Year].&[2008]} on columns from [Adventure Works]".

Here is how the connection to icCube via XMLA represented in dataSource:

CSV data sources

Here is a list of dataSource properties used to connect to CSV data sources:

browseForFile – Boolean. Defines whether you want to load the file from the local file system (true) or not (false). Default value is false.

dataSourceType – String. Type of data source. In this case it is "csv".

fieldSeparator – String. Defines specific fields separator to split CSV row. There is no need to define it if CSV fields are separated by , or ;. This property is used if another char separates fields. For example, if you use TSV, where tab char is used to separate fields in the row, fieldSeparator parameter should be defined as "\t".

filename – String. The URL to the file or to the server-side script which generates data.

ignoreQuotedLineBreaks (starting from v2.1) – Boolean. Indicates whether the line breaks in quotes will be ignored (true) in CSV files or not (false). Default value is true, which makes CSV parsing faster. Set it to false only if your data source has valuable for you line breaks in quotes. Please note that this might slow down CSV parsing a little bit.

recordsetDelimiter – String. Defines which char is used in CSV to denote the end of CSV row. Default value is "↵".

In the following example data is taken from CSV file where colon char (:) is used to separate fields in the row. Line breaks in quotes are not ignored:

Change data source using Toolbar

Please use Connect to choose another data source or Open to load another report in run time. Use Save to save the report with the current data source.

Data in pivot table will be updated and will be saved within the report.
API calls connectTo(), load() and open() are used in Toolbar to change data source in run time. API call save() is used to save the report.