Additional Information on Missing Leaf Dimension Members and Continue on Error
  • 1 Minute to read
  • Dark
    Light
  • PDF

Additional Information on Missing Leaf Dimension Members and Continue on Error

  • Dark
    Light
  • PDF

Article summary

This is an optional configuration to continue data loading even when there are missing leaf dimension members. If this option is configured, then the data load API will continue to load the valid data and will notify users with the list of missing leaf dimension members for which data has not been loaded.

This flag in the Data Load API continues to load data even when an Invalid member or Invalid number is encountered.

<continue-on-error>true</continue-on-error>

This optional flag in the Data Load API adds missing leaf dimension members, if any, to the corresponding dimension in the Master and Analytic Model Data Load API, and then loads the data.

<add-missing-dimension-members>true</add-missing-dimension-members>
Note:
To add missing leaf dimension members, the <continue-on-error> property must be set to true.

Additionally, you can specify where the additional leaf dimension members should be added.

<missing-dimension-members>       
<entry>       
 <key>dimensionname</key>       
 <value>rollupname</value>       
</entry>       
</missing-dimension-members>

Insert the <entry> ... </entry> section for each dimension that you want to specify where new members should be added.

Use Case 1:

This will continue the data load even if there are any missing leaf dimension members or invalid numbers found in the data load and will only load the data with the valid dimensions members.

<continue-on-error>true</continue-on-error>

Use Case 2 :
This will continue the data load even if there are any missing leaf dimension members or invalid numbers found in the data load. Then it adds missing leaf dimension members to the corresponding dimensions and loads the data.

<continue-on-error>true</continue-on-error>
        
<add-missing-dimension-members>true</add-missing-dimension-members>

Use Case 3:

This will continue the data load even if there are any missing leaf dimension members or invalid numbers found in the data load. Then it will add missing leaf dimensions members to Dimension1Name and Dimension2Name and will load the data.

Note:
<missing-dimension-members> ... </missing-dimension-members>

This section is optional. If this item is not included, the missing leaf dimension members will be added to DLR_DimensionName, if it exists. Otherwise DLR_DimensionName is created and the additional leaf dimension members are placed there. This occurs in each corresponding dimension with new members.


Was this article helpful?

What's Next