Sunday, July 3, 2016

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();

2 comments:

  1. Sangeeth, can you contact me about this article?

    ReplyDelete
  2. hi. Tell me any other information required on this?.

    ReplyDelete

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...