Dayalan Punniyamoorthy Blog

Monday, January 29, 2018

Mass loading of Attribute Dimension into Oracle PBCS!!!

We all knew what is an Attribute dimension and how to create one in Oracle PBCS/EPBCS. In this post lets see how to bulk load the Attribute dimension into Oracle PBCS/EPBCS.
If we want to create/update more than 100/1000 of attribute dimension it will be cumbersome to get them created/updated via the Standard Interface.

In my case I need to load around 100 attribute dimension members, let's call the attribute dimension as “JobTitle” and need to associate them with the Employee dimension.
  

Yes, just like any other dimensions you can Export/Import them from the Simplified Interface. The trick is you won't find them listed under Dimension,
But when you click on Export/Import button