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.

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.