Skip to main content
January 9, 2024
Solved

Limit excel upload after workflow closed

  • January 9, 2024
  • 2 replies
  • 0 views

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? 

Best answer by Big_Rick_CPM

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.

2 replies

January 9, 2024

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.

January 22, 2024

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.