Since I am now missing the possibility of the outer index area, looking for other approaches to get similar functionality. From
I was wondering, is it maybe possible to change the pivot information from within AIMMS code? Than I could create a widget action that shows popup where you can re-arrange the pivot information (and also create the element parameter/sub index selections for the outer-index areas). I have not seen that many references to the widgets in the webui library, but maybe there is some way that this is possible?
Best answer by Gertjan
This will not solve all your requests likely, but I think you can use a selection box that slices the info in the table. If you want to, you can also do selections (multi-select) - we promote filter panels rather than widgets on the page. You link them via either adjustment of content, or the Display Domain option of the table. Furthermore, these results can also be achieved using the end user table filter (no development needed); and this can also filter on data values (not just index values); there is no control from the model here, but it comes out of the box and gives end users lots of ways to explore data right in the table. [see examples below]
Both ideas should be able to allow the users to dive into the data (slicing it) and understand it better.
The re-arranging/dicing part can be arranged by adjusting the pivot, but not sure if you like to expose end users to this (and it can’t be controlled from the model). Alternative is to indeed get creative. You could think of creating a DisplayLayer and a DataLayer and make a transformation between the two (each time rebuild the DisplayLayer). We have seen people be very creative in their work. Curious what you come up with.