I would like to constrain which dimensions the user can select. I can (sometimes) get a list box to make it so a dimension has 'always one selected value'. But I would have one pivot table (based on dimensions not used anywhere else) that I would like not to let the user click on and reduce. Any ideas how this is possible?
Maybe you can set your pivot table properties to "Read Only". In this case the table will react on selections made anywhere, but not allow to click on the table itself. Obviously this solution is not usable if you want to allow to click on some dimensions.
Great, this works for my purposes- thanks, I hadn't experimented with that check box before!
While I'm asking questions - is there a way to constrain selections so that at most one value can be selected in a dimension? I can use list boxes so that always one is selected, but that's not quite the same...
"At most one" - do you mean that it is allowed to clear all or select one, but not allowed to select more than one?
There is no such property. It is possible to do it using a macro which will be triggered on select in the field, will check how many selected, and if more than one - clear the field and produce a message. If you're going to use your application in AJAX, you better avoid using macros.