Uses of Interface
net.pricefx.formulaengine.scripting.Matrix2D

Packages that use Matrix2D

Package	Description
net.pricefx.formulaengine	Provides Formula Engine API classes.
net.pricefx.formulaengine.scripting	Provides API related to scripting, including interface PublicGroovyAPI, that represents what can be reached in the Groovy element syntax as api.
net.pricefx.formulaengine.scripting.portlets

Uses of Matrix2D in net.pricefx.formulaengine

Methods in net.pricefx.formulaengine that return Matrix2D

Modifier and Type	Method	Description
Matrix2D	TableContext.executeQuery(String queryString)
Matrix2D	TableContext.executeQuery(Query query)
Matrix2D	DatamartContext.executeSqlQuery(String sql, Object... sources)	Executes an ANSI compliant SQL SELECT statement in the PA DB. Important note: A non-compliant statement that does not fail at the present time may well fail in the future releases. The DB schema that can be queried is constructed on the fly by means of view definitions.
Matrix2D	DatamartContext.executeSqlQuery(DatamartContext.SqlQuery sqlQuery)	Executes an ANSI compliant SQL SELECT statement in the PA DB.
Matrix2D	DatamartQueryResult.getData()	Retreives the query result data.
Matrix2D	TableContext.select(String selectSql)	Deprecated.

Methods in net.pricefx.formulaengine with parameters of type Matrix2D

Modifier and Type	Method	Description
List<Long>	ModelCalcFormulaContext.addTree(String treeName, Matrix2D data, Collection<String> levelCols)	Adds a tree to this model, consisting of nodes constructed from a data set, usually a PA query result.
List<Long>	ModelCalcFormulaContext.addTree(String treeName, Matrix2D data, Collection<String> levelCols, Collection<String> labelCols, String outputColName, String outputColFormat)	Creates or replaces a tree as in ModelCalcFormulaContext.addTree(String, Matrix2D, Collection), with the additional specification of an output or output format, and/or labels.
void	DatamartRowSet.loadRows(Matrix2D data)	Add rows from a #Matrix2D.
void	DatamartRowSet.loadRows(Matrix2D data, Collection<String> columns)	Add rows from a #Matrix2D, possibly only a subset of the matrix columns.
void	DatamartRowSet.loadRows(Matrix2D data, Map<String,String> fieldMapping)	Add rows from a #Matrix2D, possibly only a subset of the matrix columns.

Uses of Matrix2D in net.pricefx.formulaengine.scripting

Methods in net.pricefx.formulaengine.scripting that return Matrix2D

Modifier and Type	Method	Description
Matrix2D	Matrix2D.addColumn(String colLabel)	Add a column to this Matrix2D, without any values
Matrix2D	Matrix2D.addColumn(String colLabel, Object[] colValues)	Add a column to this Matrix2D, with the value on each row retreived from the given values array.
Matrix2D	Matrix2D.addMappedColumn(String colLabel, String mappedColLabel, Map<String,Object> mapping)	Add a column to this Matrix2D, with the value on each row looked up from the given map, using the mapped column's value as the lookup key.
Matrix2D	Matrix2D.addMappedColumn(String colLabel, List<String> fromColLabels, Map<MultiKey<String>,Object> mapping)	Add a column to this Matrix2D, with the value on each row looked up from the given map, using a set of existing columns' values as a composite lookup key.
Matrix2D	Matrix2D.indexOfMax()
Matrix2D	Matrix2D.indexOfMin()
Matrix2D	Matrix2D.max()
Matrix2D	Matrix2D.mean()
Matrix2D	Matrix2D.min()
Matrix2D	Matrix2D.normalize(long... cols)	Normalizes numeric column values, by dividing each value in the column by the total for the column.
Matrix2D	Matrix2D.normalizeRowValues(Collection<String> colLabels, int precision)	Normalizes the values on a row-by-row basis.
Matrix2D	Matrix2D.renameColumns(Map<String,String> old2NewColLabels)	Renames the columns in this matrix so that the old column label = key, and the new column label = value in the given map.
Matrix2D	Matrix2D.replaceMissingValues(String colLabel, Object val)	Replaces nulls in the given column with the given value.
Matrix2D	Matrix2D.select(long startRow, long endRow, long startColumn, long endColumn)	Selects a subset of rows and columns in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.selectColumn(long col)	Selects a column in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.selectColumn(String label)	Selects a column in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.selectColumns(long startCol, long endCol)	Selects a subset of columns in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.selectRow(long row)	Selects one row in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.selectRows(long[] rows)	Selects a subset of rows in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.selectRows(long startRow, long endRow)	Selects a subset of rows in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.selectRows(Collection<? extends Number> rows)	Selects a subset of rows in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
Matrix2D	Matrix2D.sortRows(long col)
Matrix2D	Matrix2D.sortRowsReverse(long col)
Matrix2D	Matrix2D.std()
Matrix2D	Matrix2D.sum()

Uses of Matrix2D in net.pricefx.formulaengine.scripting.portlets

Methods in net.pricefx.formulaengine.scripting.portlets that return Matrix2D

Modifier and Type	Method	Description
default Matrix2D	ResultMatrix.toMatrix2D()