I have a question around different ways of surfacing all measures & dimensions to a sheet in a document.
I used to work with another product that did this, similar to the way that when you browse a cube from within Microsoft SSMS /Excel Pivot Tables etc.
Essentially I would like to create a sheet which automatically surfaces up all data from my data source (including any new ones) and then allow users to then select (ideally drag and drop, but suspect this won't be the case) any measures and dimensions they wish and then allow them to appear within a table/pivot.
I would also like them to be able to create their own calculated measures on the fly if needed.
I have come across an attempt at doing this, but it relies on using some external XL files too. It doesn't give me all the functionality I need, but it does allow me to expose a number of measures and dims and then allow a user to add them into a table.