Forum Discussion

leandroM's avatar
leandroM
New Contributor II
2 years ago

Limit excel upload after workflow closed

Hi, 

We are using the Excel upload to load some data to OneStream. A problem arose when we found that even by locking the workflow it was possible to load data using Excel. 

 

Is it possible to prevent this behavior? 

  • It sounds like you are missing entity assignments. Make sure you are assigning the entities to the workflows you are locking if you want to prevent data changes after a workflow gets locked. If you need to lock a portion of the entities data and not all (e.g. lock a certain account type members), you will also need to consider workflow channels in addition to entity assignments.

  • It sounds like you are missing entity assignments. Make sure you are assigning the entities to the workflows you are locking if you want to prevent data changes after a workflow gets locked. If you need to lock a portion of the entities data and not all (e.g. lock a certain account type members), you will also need to consider workflow channels in addition to entity assignments.

  • No, it's not possible. The reason is because locking the workflow doesn't impact cube security and editing things via Excel doesn't involve the workflow at all. Excel directly accesses the cube.

    If you want to lock data down by entity/period, then you'll have to configure security to support it.