To Delete Dimension Related Record

//To Delete Dimension Related Record

Error :: A financial dimension value is based on the "ID" record and
 has been used on a  transaction. You cannot delete the "ID" record

Delete Record from below Table. And then try to Delete

DimensionAttributeLevelValue
DimensionAttributeValueCombination
   DimensionAttributeLevelValue    attributeLevelValue;
    DimensionAttributeValueCombination  attributeValueCombination;

    ttsBegin;
    delete_from attributeValueCombination
        where attributeValueCombination.DisplayValue like ProjTable.ProjId;
    delete_from attributeLevelValue
        where attributeLevelValue.DisplayValue like ProjTable.ProjId;
    ttsCommit;
    super();