Use setting grids as a model Import Dat Source

0 Kudos

Use setting grids as a model Import Dat Source

There are certain fields in the settings tables of a model that would be very useful to be able to easily import into a module for further calculation/model usability. The uses I have already encountered would be:

  • The 'user settings' table - this would allow filters and dynamic cell access more easily based on role, or to provide an in model snapshot/historic view of user access. 
  • The 'actions' table - specifically the 'Start Date and Time (UTC)' value would be very useful to be able to expose to end users, to show exactly when various process were last run without needing to give them workspace access.
  • The 'general lists' table - specifically for the 'Next item index' value, to be able to easily aggregate and create warnings within Anaplan when a list is approaching the max index. 

Currently these settings tables can be exported, and that export can be save as an export definition to be run by end users. However, there is no functionality to import those tables directly into a module within the model. The only workaround would be to have the end user export the file, then re-upload that file as an import, which is cumbersome and error prone. 

 

I could imagine the 'Select Source' having a 'Settings' radio button in addition to 'List', 'Module', and 'Saved View': 

NoahJ_1-1628785963707.png