PerformancePoint LoadingControlID

From time to time, I’ll be questioned how a record was created in PerformancePoint Planning.  A quick check of the LoadingControlID in the table of interest can provide insight into how the record was generated.  This field provides a code, normally 1000 or 2000.  But if you don’t know the meaning of the code, it does not help too much.  I performed a search over the Internet and found very little on the topic of the LoadingControlID.  So, I hope you will find this post helpful.  There is a table in the application database called LoadingControlID that contains all the definitions of these LoadingControlID’s.  Below are the definitions.

0         Unknown
1000   ReferenceDataSubmission
2000   DataLoad
3000   GenericCalculation
3001   SharesCalculation
3002   Consolidation
3003   IntercompanyReconciliation
3004   CurrencyConversion
3005   OpeningBalanceRule
3006   MovementRule
3007   SeedingRule
3008   AllocationRule
4000   DataSubmission
5000   TypeLibraryGenerated
6000   AssociationFactDataMovement

My experiences have shown that data loaded via the PPSCmd have a LoadingControlID of 2000 (DataLoad).  Data that is manually entered via the Planning Business Modeler has a code of 1000 (ReferenceDataSubmission).

When loading new records via the PPSCmd or from the “Load Data From Staging” command in Planning Business Modeler, there’s no need to populate this field as PPS generates the correct code on its own.

-ez