Cannot delete master data because it is in use by a query

[former_member198282]

Hi, all.

I am trying to delete some master data and it is in use by a query according to SLG1. Is there a good way to delete the master data content without deleting the query?

Thanks,

Jonathan.

[former_member198282]

Hi, Vikram

Can you explain more on why that wouldn't help?

Thanks,

Jonathan.

[former_member198282]

Hi, Vikram

Thank you for your feedback. But since I do not want to modify the queries(there would be quite a few to do), can I just re-initialize the master data and wouldn't that do the trick? But then what is the purpose of deleting the master data then?

Regards,

Jonathan.

[Former Member]

Unfortunately that would not help as well.

-Vikram

[Former Member]

You need to remove the restriction in the query for the value of master data you are planning to delete.

-Vikram

[former_member198282]

Hi, Pavan.

The master data is not used anywhere else since I have already cleared all the cubes and DSO. The only thing the SLG1 is complaining is the query.

Actually, the reason I am doing this is because the data on the system is kind of old. After we refresh the source system with production data, we are trying to repopulate all the cubes again. I am wondering if we actually need to delete all the master data. Doesn't re-initializing the master data will do the job? If that is the case, is there any reason to delete the master data?

Thanks,

Jonathan.

[Former Member]

Hi Jonathan,

Check if your master data is being used in any of the Data Targets like DSo & cube... If so, first you will have to delete all the transactional data from DSO, cube etc & then you will be able to deletre your master data.

Hope it helps!

Regards,

Pavan