See the attached documents and Rank and Distribution Data Consistency help topic.
As of 5.8.4, all Biotics instances include the DDF_UPDATE_SUBNATIONAL & DDF_UPDATE_NATIONAL procedures which will update the values for all records where DDF is null or does not match the calculated value. To use the procedure to update the values:
- Log into SQL Developer, Tora, Toad or SQLPlus as the biotics_dlink user.
- Run the following SQL statements:
set serverout on size UNLIMITED;
Attached is a log file showing how to log into SQLPlus to run this procedure and the expected result.