Import/Upload restrictions on Flat List and Flat List Modules

vivekdasgupta
vivekdasgupta
in Modeling

Hi All,

I have a flat list which is a concatenation of Lists - Company Code, Costcenter, Costelement and KPI, ex - IN11_CC2222_CE3333_PL50. There are more than 5000 list members. We already have a module based on this flat list. Users from different regions upload Planning data to this module using offline csv files. The Process has 2 actions, one to create/update Flat list and other to upload plan numbers in Modules.

Currently there is no security/restrictions in place. During our last planning cycle, we had issues with focal managing company code IN11, mistakenly updating data for another company code US85.

Currently we have selective access for Lists - Company Code and KPI. We want to bring in additional security/restrictions in place. We want to solve the below:

  1. User is able to create Flat list for only his Company Code and KPI.
  2. User is able to upload data for only the Company code and KPI he has access to.
  3. Multiple users can use the feature at the same time

Can you please suggest the best way to go about this requirement?

Looking forward to your responses.

Regards,

Vivek

Answers

  • devrathahuja
    devrathahuja

    @vivekdasgupta - Make the list a child of the company code list so one would only be able to load data for their company. The column in file can be mapped to the dimension & list would be created only for unique combination of the other 3 properties.

Categories