Forum Discussion

JoelBeh's avatar
JoelBeh
New Contributor II
27 days ago
Solved

Clear ALL Data related to a specific Member.

Hello everyone,  I'm just wondering if there's a method or a way to delete ALL Data with a click of a button. I know about data management steps and the use of it along with the finance BR. So my ...
  • rhankey's avatar
    26 days ago

    By design, there is no convenient out of box way to clear all the data for a specific member or members, so you could let's say delete the member(s).  The reason for this I would speculate is because doing so is very dangerous and breaks OS's attempt to maintain data integrity.

    However, it's fairly easy to write a business rule to accomplish this if you truly need to do so.  For each Cube Data Unit containing values in the member(s), you need to replace the values for those members with a cell status of IsNoData=True, IsValid=False.  That will zap Cube data that came from Stage, Forms or Journals and Calculated data.  If the goal is to be able to delete the member(s), you also need to zap the data in Stage, Journals & Annotations containing the member(s) too.  Clearing Imported, Forms and Journal data from the Cube, Stage, Annotations and Journal tables in such a manner can circumvent Certifications, Locks, enforcing balanced journals, etc that the majority of OS users expect of the product.  And if someone accidentally chooses the incorrect member to clear-out, you are almost certainly going to need to roll back the database, which means rolling back what everyone else was doing too.

    Do you get the sense such a tool is quite dangerous?  I keep such tools rather far out of reach, even from Admins.