How to load Attributes in to PBCS application
To load Attributes, prepare file like this.
Employee Number1, Alias, Permanent, Monthly
Employee Number2, Alias, contract, Hourly
Here 3rd, and 4th columns are attributes, which i am going to load along with Emp numbers and Alias metadata using Data Management/Data Exchange.
While creating application, select Dimensions and If needed use prefix.
As it will create dimensions, if you are going to load Custom dimension, select Custom and add Attribute name (Parent member of the attributes which you created in application) and assign UD1/2/3 depends on the no.of the Attributes columns you are loading.
So, create import format, where select Source and Target Dimensions and Attributes.
Note: Few you are getting blanks for few attributes, then generally we will write SQL in mapping, to ignore blanks, but here is the catch. If you ignore Attribute it will ignore that complete line. That means metadata also will not build. so, if you want to use to load metadata along with attributes, you must need one member in Attribute to assign for blanks in attribute list. Attribute will not duplicates also, so, if you want to use like NoAttribute1, and NoAttribute2 etc.
While loading metadata, you can ignore blanks not metadata members, so above tip will be helpful.
Load and Test once it's completed...!!
Reference:
https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/integrations_erp_async_integration.html#GUID-D9049165-6F30-43DD-B9F8-C52C01DFF2B8
