Data manipulation

The three main UI components displaying data:

• chart
• tabular view
• pivot table

are called data presentations.

All the data presentations will take as input a Table object, which is very close to a 2D JavaScript Array, and render the content of this table. This has three implications:

1. When a user wants to display the result of an MDX query in a presentation, the CellSet received from the server is automatically converted into a table before being passed to the presentation (See TableFromCellSet).
2. The same thing happens with a drillthrough query: its result will be converted to a Table. In this situation the conversion is more straightforward than with a CellSet (See TableFromDrillthroughDataSet).
3. You can render your own data coming from any source in a presentation. You just need to have it in a Table object which has a simple structure. Take a look at the DataApi to see how to do it.