Now that the Jet Hub supports updating data for pivot tables, it would be awesome to have features like options and lookup - like already available for tables based on the NL function set.

A customer could modify for example the filters as he wishes, like date or company. This option should be bound to his rights given by the data source management and Cubes permissions (he only can select a certain company, a certain department code and so on). Or at least it will throw a meaningful error, when trying to access data he is no access to.