PsiDataSrc (“src_name”, {val_col_names }, (data), [idx1_name], [idx1_elements], [idx2_name], [idx2_elem])
When creating a custom visual in Power BI or Tableau, use PsiDataSrc() to specify the parameters in the Excel model that you would like to be able to edit or chart in Power BI.
src_name: Required - This argument names the text file that is translated to the RASON datasource name. (This argument must be surrounded by quotes.)
val_col_names: Required - An array of strings (or a single string). Each string is translated to the name of a RASON data element, to which a value column of the datasource will be bound.
Data: Required - A (potentially multi-area) cell reference in the XLL version. (This argument is limited to a single-area cell reference in Analytic Solver Cloud.) Each area (cell range) corresponds to one string name in val_col_names. The size and shape of each cell range provides dimension information (but not values) for the corresponding RASON data element. Normally, the Excel model's formulas will also reference cells within these ranges, so the RASON models' formulas will reference the corresponding RASON data elements.
idx1_name, idx1_elem, idx2_name, idx2_elem – Idx1_name and idx2_name are strings and are translated to names of the datasource index columns. Idx1_elem and idx2_elem are cell references where the cells contain the index elements. At least one index must be present and at most two.
idx1_name: Required - Enter the name of the 1st index set for the data specified in the Data argument. The first index set should always be the index set that describes the row elements. (This argument must be surrounded by quotes.)
idx1_elem: Required - Enter the Excel range containing the data (or elements) for the 1st index set.
Idx2_name: Optional - Enter the name of the 2nd index set, if present, for the iata specified in the Data argument. The second index set should always be the index set that describes the column elements. (This argument must be surrounded by quotes.)
idx2_elem: Optional - Enter the Excel range containing the data (or elements) for the 2nd index set, if present.