Disable Custom Objects and Attributes from the Data Warehouse

Document created by Sarmistha_Purkayastha Employee on Nov 15, 2016
Version 1Show Document
  • View in full screen mode

To disable a custom master object from the Data Warehouse, first disable all the custom sub objects for that master object. Once the subobjects are disabled, disabling the master object also disables the custom attributes for the master and subobjects from the Data Warehouse.

After deleting or disabling an object or attribute from the Data Warehouse, run the Load Data Warehouse job for the changes to take effect. Verify that the Full Load option is selected when running the job. We recommend that you run the Load Data Warehouse job at least once before re-enabling an object or attribute for the Data Warehouse.

Important! Do not delete or disable any attribute available from an add-in because doing so can break reporting functionality. Also, before disabling custom objects or attributes from the Data Warehouse, verify that those objects and attributes are not used in any views or reports. We recommend that you notify all users to remove those objects or attributes from any views or reports that are currently using them. If the users do not remove those objects or attributes from the views or reports, they can create new views and reports. The existing views and reports become unusable. A system error appears when they try to access the existing views or reports.

You can work around the system error and allow users access to the previously saved views and reports. Complete the following procedure.

Follow these steps:

  1. Re-enable the disabled or deleted objects or attributes for the Data Warehouse.
  2. Read the custom objects and attributes to the Data Warehouse and domains by running the Load the Data Warehouse job.
  3. Access the ad hoc views and reports that use the re-enabled objects or attributes. Manually remove the appropriate objects or attributes from the ad hoc views and reports and save.
  4. Disable the appropriate objects or attributes from the Data Warehouse:
    1. Disable a custom object or attribute from the Data Warehouse by deselecting the Include in the Data Warehouse check box for the object or attribute.
    2. Disable multiple custom attributes at once by selecting them on the attributes list page and then checking the Exclude from Data Warehouse option.
  5. Remove the custom objects and attributes from the Data Warehouse and domains by running the Load the Data Warehouse job.

Attachments

    Outcomes