Difference between revisions of "Error Messages/40448"

Latest revision as of 19:33, 29 March 2016

Error message examples

In the call to MdTable, the «Vars» parameter cannot be omitted when the «valueColumn» is explicitly specified.

Cause

You passed the «ValueColumn» parameter to the MdTable function without passing in the «Vars» parameter.

MdTable function converts a flat 2-dimensional table in pure-relational or fact-table format to a multidimensional table. You don't need to specify parameters «Vars» or «ValueColumn» to convert a table in pure relational format to a multidimensional format. You need to pass in the «ValueColumn» parameter to specify how the multiple value columns are divided in the fact-table format, and the «Vars» parameter, list of index identifiers, to specify the dimension of the final result.

The documentation on MdTable and Relational tables and multiD arrays explains the function in more detail and provides examples on how the function can be used.

Remedies

For data in pure-relational table, you can remove the «valueColumn» parameter to the MdTable function.

For data in fact-table format, you will need to provide the «Vars» parameter to specify the dimension of the final multidimensional result.

@@ Line 1: / Line 1: @@
-= Error Message Examples =
+[[Category: Error messages]]
- In the call to MdTable, the «Vars» parameter cannot be omitted when the «valueColumn» is explicitly specified.
+== Error message examples ==
-= Cause =
+:<code>''In the call to MdTable, the «Vars» parameter cannot be omitted when the «valueColumn» is explicitly specified.''</code>
-You passed the '''ValueColumn''' parameter to the MdTable function without passing in the '''Vars''' parameter.
+== Cause ==
-[[MdTable]] function converts a flat 2-dimensional table in pure-relational or fact-table format to a multidimensional table. You don't need to specify parameters '''Vars''' or '''ValueColumn''' to convert a table in pure relational format to a multidimensional format. You need to pass in the '''ValueColumn''' parameter to specify how the multiple value columns are divided in the fact-table format, and the '''Vars''' parameter, list of index identifiers, to specify the dimension of the final result.
+You passed the «ValueColumn» parameter to the [[MdTable]] function without passing in the «Vars» parameter.
-The documentation on [[MdTable]] and the Analytica User Guide explains the function in more detail and provides [[Mdtable#Examples|examples]] on how the function can be used.
+[[MdTable]] function converts a flat 2-dimensional table in pure-relational or fact-table format to a multidimensional table. You don't need to specify parameters «Vars» or «ValueColumn» to convert a table in pure relational format to a multidimensional format. You need to pass in the «ValueColumn» parameter to specify how the multiple value columns are divided in the fact-table format, and the «Vars» parameter, list of index identifiers, to specify the dimension of the final result.
-= Remedies =
+The documentation on [[MdTable]] and [[Relational tables and multiD arrays]] explains the function in more detail and provides [[Mdtable#Examples|examples]] on how the function can be used.
-For data in pure-relational table, you can remove the valueColumn parameter to the MdTable function.
+== Remedies ==
-For data in fact-table format, you will need to provide the '''Vars''' parameter to specify the dimension of the final multidimensional result.
+For data in pure-relational table, you can remove the «valueColumn» parameter to the [[MdTable]] function.
-<br><comments />
+For data in fact-table format, you will need to provide the «Vars» parameter to specify the dimension of the final multidimensional result.
+==See Also==
+* [[Function calls and parameters]]
+* [[Arrays and Indexes]]
+* [[Relational tables and multiD arrays]]
+* [[MdTable]]