ImportMDX
The ImportMDX() function imports data from a Microsoft MDX cube.
Related functions: ImportCSV, ImportExcel, ImportText
Syntax
ImportMDX ()
| Source | |
| Query | The query to pass to the ODBC source, for example: “Select Asset_Code,Asset_Description,Value from Portfolio_Assets” |
| Filter Expression | The expression representing the filter criteria to apply to the data, for example: “where Portfolio_ID = ‘5039’ and Date = ’31 March 2015′” |
| Columns | The columns that need to be returned, represented as C1,C2,C3,… If the value is set to ‘*’ or omitted, then all columns are returned. |
| Arr1 | If the filter expression contains wildcards, for example, “where Portfolio_ID = ? and Date = ?”, arr1 contains the array of values to insert in place of the wildcards, in the order they occur in the filter expression. Note: this parameter can be a Quintessence function that returns an array. |
Examples
Example 1. Select all records from a database table
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example 1. Select all records from a database table
The ImportODBC() function is used to return all records from the Customer table.
| Parameters | Values | Return all records |
| Connection String | Driver={SQL Server};Server=myServer;Database=myDatabase;Uid=sa;Pwd=12345; | =ImportODBC(B2,B3,,,) |
| Sql | Select * from Customers | |
| Criteria | ||
| Columns | ||
| Arr1 |