How do we handle 2D grids with holes (& pagination)

[RickMoynihan]

Somehow support pagination and 'holes' in 2D grids. For example in PublishMyData's spreadsheet view, we paginate on the rows, not the observations.

[ricroberts]

In PublishMyData, we do this as a single nested query, where we select (and paginate over) the rows in an inner query before joining it to the observations in an outer query.

I suggest to support this via GraphQL, we offer users a way to:

• get the list of possible values for a single dimension within a slice (i.e. for a set of locked dimensions). This could be paginated, and ordered.

• Get observations for a set of locked dimensions, plus a set (or list) of values for one of the dimensions (i.e. the one we asked for above).