The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Clearing data for a very specific intersection / Data Unit
Hi all, Trying to delete an unnecessary member from the metadata but it won't delete due to 'existing' data. There isn't actually a value where it says a value exists but OS believes there is data ...
If you have a problem, if no one else can help, and if you can find them, maybe you can use... finance Api rules!
api.Data.ClearCalculatedData(True, True, True, True, "A#MyAccountParent.Base", "F#MyFlowParent.Base") '... other filters if necessary api.Data.SetDataCell("A#MyAccount:F#MyFlow", 0,True) ' other members as necessary, if not specified will fall back to NoneDrop that in a Custom Calculate, execute it with the related Data Management step, and you should be able to clear the specific intersections you need.
There could be translated data at a non-local currency. Go to System > Database tab > then Data Records. Put in the Time in the format T#2023 (full year) and in this view Value1, Value2, Value3 represent the Months M1, M2, M3. This will at least identify the intersection of data where the data exists.
If it is only translated data, and the source data in Local has been deleted, then you just need to run a Force Consolidate to clear the translated data.
Lastly, I have a BR that will do a targeted clear of a data cell. If you paste a reply here of the intersection you are trying to clear (Entity, Account, Origin, etc) I'll mock it up and post the code here for you.
Hope that helps.
JackLacava
OneStream Employee
OneStream EmployeeIf you have a problem, if no one else can help, and if you can find them, maybe you can use... finance Api rules!
api.Data.ClearCalculatedData(True, True, True, True, "A#MyAccountParent.Base", "F#MyFlowParent.Base") '... other filters if necessary
api.Data.SetDataCell("A#MyAccount:F#MyFlow", 0,True) ' other members as necessary, if not specified will fall back to None
Drop that in a Custom Calculate, execute it with the related Data Management step, and you should be able to clear the specific intersections you need.
Thank you so much for this - it will be very handy for us as we have to clear > 2000 members. Very much appreciated!!
Jack, on the SetDataCell, it says if members aren't specified then it defaults to None. What if you want it to do all members for those not specified? Is that possible? Like I'm wanting to zero all members associated with that account and entity or does that do data explosion with zeros?
