Returning Metadata Hierarchy Based Only on Cloned Saved Search in NSPB Sync
By default, when a metadata saved search is run, a full metadata hierarchy is built in the saved search result. If any parent is missing in your cloned saved search, it is added in the hierarchy based on the default metadata saved search.
You can choose to skip running the default metadata saved search and use only the data from your cloned saved search to build the hierarchy. This enables you to:
-
Decrease the volume of the data load.
-
Use only a subset of data in the saved search.
To skip running the default metadata saved search:
-
Go to Planning & Budgeting > Setup > Saved Search Settings.
-
Click Customize next to the saved search of your choice.
-
Under the Parent Level Transaction section, check the Return Hierarchy Based Only on Data in This Search box.
-
The box is clear by default.
-
If a parent is missing, the top-level parent is used. Therefore, make sure your saved search contains all data that you need to build the hierarchy.
-
NSPB Sync doesn't support using the box and the Filter dropdown list at the same time. If you try to save a search with the box checked and a filter selected, you receive an error message.
-
The box is not available for Accounts and Customer Project metadata saved searches.
-
-
Click Save.
Related Topics
- Metadata Export from NSPB Sync to Planning and Budgeting
- Supported Metadata Saved Searches in NSPB Sync
- Supported Prefixes of Metadata Saved Searches IDs in NSPB Sync
- Item Metadata in NSPB Sync
- Vendor Metadata in NSPB Sync
- Location Metadata in NSPB Sync
- Accounts Metadata in NSPB Sync
- Class Metadata in NSPB Sync
- Customer Metadata in NSPB Sync
- Department Metadata in NSPB Sync
- Project Metadata in NSPB Sync
- Customer Project Metadata in NSPB Sync
- Employee Metadata in NSPB Sync
- Subsidiary Metadata in NSPB Sync
- Custom Segment Metadata in NSPB Sync
- Creating the Hierarchy of Metadata in NSPB Sync
- Optimal Number of Metadata Records to Import from NSPB Sync to Planning and Budgeting
- Account Type Mapping in NSPB Sync
- Item Type Mapping in NSPB Sync