Forum Discussion

Kishore_Boyd's avatar
Kishore_Boyd
New Contributor II
2 years ago

Ghost data unable to delete

I am copying a scenario to scenario to rename it as the latest one, we are trying to delete the copied numbers to do the copy over again, but the copied numbers are not deleting and the numbers resides only at parent level, ran consolidation as well but numbers not deleting and it seems like some ghost data, need help on this on how to delete those numbers.

The copy over was done using Data Management job.

OSAdmin - Attached some screenshots for reference.

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor

    Hey,
    Can you run the copy using a BR at scenario level?
    Can you do a scenario reset for your Target? Reset scenario has to be used with care as it will delete everything! You will find it in a DM job.
    Thanks

  • Drill all the way down and check the cell status of the lowest level of data. Try both navigating the quickview and navigating via the formal Drill Down menu. Alternatively, find that data in the System/Database/Data Records tool and check the status there (though you'll have to look up the status code meanings.) Knowing things like if the data is real or derived, if it's calculated, if it's durable, et al can provide insight into how it needs to be deleted. Durable data in particular can be tricky to delete.
    If you want the scenario truly empty, then Nicolas' suggestion to attempt a Scenario Reset is the easiest way to get there but do note it is very thorough and resets stage data, cube data, workflow status: everything.