Error Messages/41016

Error message examples

 The 5th parameter to MdTable must be either a handle to a valid aggregation function,
 or a text value containing the name of a valid aggregation function. The parameter
 passed, 0.417, is neither a handle nor textual.

Cause

It is possible that two or more rows of the first parameter, <<T>>, to MdTable specify identical coordinates. In this case, a conglomeration function is used to combine the values for the given cell. The «conglomerationFn» parameter is either a handle to a valid conglomeration function or a text value specifying which conglomeration function is to be used. Possible conglomeration functions are are Sum(default), Min, Max, Average, and Product.

The fifth parameter, «conglomerationFn», passed to the MdTable function was neither a handle to a function nor a textual value so this error was triggered. The following code would trigger this error:

Mdtable(Flat_fact_table, Rows, Cols, ['Index_a', 'Index_b'], valuecolumn: Countries, conglomerationFn: sum(A))

Remedies

Correct the 5th parameter, «conglomerationFn» passed to the MdTable function to be a handle to a valid conglomeration function or the name of the conglomeration function.

See Also

• Mdtable
• Handle
• Aggregate
• Function calls and parameters