cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member198282
Participant
0 Kudos
84

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member198282
Participant
0 Kudos

Hi, Vikram

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

Thanks,

Jonathan.

former_member198282
Participant
0 Kudos

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
0 Kudos

Unfortunately that would not help as well.

-Vikram

Former Member
0 Kudos

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

-Vikram

former_member198282
Participant
0 Kudos

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
0 Kudos

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