Hi all,
I'm investigating possibilities to save arbitrary selections (see post linked below) but I find that even if I can manage to save them to a text cube, it is impossible to "restore" them when needed in the context of a maintenance interface.
However, it is possible in the context of a procedure, to save the current selection and then to restore it at a different point of the procedure.
Therefore I understand that Board is quite capable of saving and restoring selection using a specific format.
Now my idea is, could we do the same using a cube, and not a variable inside a procedure ?
Then we would have two additional actions in the selection part of a procedure :
- Save selection to cube
- Restore selection from cube
Let's say I want to associate a selection (which can be made on several trees with a total of 70+ entities) with an allocation rule.
I would create a text (?) cube structured by the entity "Allocation rule".
I would select the rule (through a pager for example) and create my selection thanks to multiple selectors in the screen. Then i would use a procedure to "save selection to cube".
When going back to that rule, I would then restore the screen selection by first filtering on the "Allocation rule" then using the stored selection in the cube to restore the selection to screen in the procedure.
Note: the format used to store selection could be the same as the one existing in the excel addin to pass a selection in a formula:
"Entity1=member_code;Entity2=member_code"
