Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again.

(1) ShareShare
ReportReport
Posted on by 7

Good Day,

I created a Rating Model with six levels as part of a Measurement to be used within a Goal.

I now want to delete one of the levels, but I get the error "Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again."

Any assistance would be appreciated.

Regards,

SA

  • WinStep Profile Picture
    7 on at
    RE: Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again.

    Hi Parag,

    I tried to delete from "RatingLevel" using the Workbook Designer.

    As you probably know: Levels are part of Rating Models, which in turn are used by Measurements, which in turn are used within Goals.

    1. I have already deleted all Goals.

    2. I have already deleted the Measurement which originally made use of the Rating Model in question.

    3. If I try to delete the Rating Model, I get "Rating models cannot be deleted while dependent Levels exist. Delete dependent Levels and try again."

    4. I have therefore been trying to delete the Level(s).

    Fun, right?!

    Regards,

    Stephen

  • Suggested answer
    Parag Chapre Profile Picture
    12,252 Most Valuable Professional on at
    RE: Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again.

    Hi,

    Did you try to delete the data for measurement table using excel workbook designer and getting the error?

  • WinStep Profile Picture
    7 on at
    RE: Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again.

    Hi Parag,

    I have also tried the Excel Workbook Designer, but it gives the same error when I try to delete the entries.

    Regards,

    Stephen

  • Suggested answer
    Parag Chapre Profile Picture
    12,252 Most Valuable Professional on at
    RE: Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again.

    Hi Stephen,

    you can use excel workbook designer, find that entity and delete the entries.

    If you search for excel workbook designer in search box then you can find the form.

    I hope this helps.

  • WinStep Profile Picture
    7 on at
    RE: Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again.

    Hi Parag,

    Thank you for your attention and willingness to assist.

    I have already deleted the associated Measurement (and Goal) that I initially tested the Rating Model with, but the message persists.

    I was able to view the HcmMeasurementDetails table (using the Table Browser Caller for D365 F&O), and I can see the entries I would like to delete.

    However, deleting from there is not possible because this is a Tier 2 Sandbox environment.

    Is there a way forward that you are aware of?

    Regards,

    Stephen

  • Suggested answer
    Parag Chapre Profile Picture
    12,252 Most Valuable Professional on at
    RE: Levels cannot be deleted while dependent HcmMeasurementDetail exist. Delete dependent HcmMeasurementDetail and try again.

    Hi Stephen,

    As error says, you have dependency on measurement details. Could you please delete measurement details related to rating model first?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 353 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 276

#3
Jonas "Jones" Melgaard Profile Picture

Jonas "Jones" Melgaard 190 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans