Smart MdTable library
Smart_MdTable library contains functions Smart_MdTable and Smart_MdTable_count. They are similar to the built-in function MdTable, but they save you the effort of having to create a global index corresponding to each of the index columns in a relational table. Instead they return a multidimensional array with a local index corresponding to each index column, containing its unique values. Smart_MdTable_count applies to a relational table with no measure column(s) and returns a multidimensional array with a count of the number of rows in the table that match the coordinates of each cell in the result.
Another difference between Smart_MdTable and MdTable is that the former has parameter «measureCols» that contains the measures (a subset of «cols» that contain numerical values), which don't have to be the last M columns of «cols», unlike the «valueColumn» parameter of MdTable.
Download the Smart_MdTable library from here:
Enable comment auto-refresher