You can now use the Workbook Aspects feature in V9.2 to achieve this kind of thing:

https://help.xlcubed.com/Workbook_Aspects

Thanks
XLCubed

Maybe you need an idea to blog about:
We prepare to run our reports with the web edition and come to the point where we need to store some user specific information like parameters or settings.
For example:
– Which KPI the user wants to display in a specific tile in a dashboard? (Customize Dashboards)
– Which was the last selected parameter for a dimension?
– Hide / unhide settings
– ….

A dream would be to have the built-in possibility to define user specific settings. The value could be stored as Cookie on the web or registry setting in an Excel environment or in an SQL database….
Generic formulas would look like:
=XL3GetUserSetting(Section, Key)
=XL3PutUserSetting(Section, Key, Value)
The information should be available during initialization of a report/slicer…

Back to here and now:
In the nearby future we think about to implement some kind of relational table like this:
User Section Key Value
Krampe Parameter Month 03
Krampe Parameter PreferedKPI OpEbit
Krampe Display ShowDetails 1

We will have to handle select and update via an SQL connection. I think this is feasible with XLCubed.
How would you implement such a kind of requirement with the current toolset. Use Analysis Services writeback instead?

Best Regards,
Sven