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
