Add Additional Columns to the Customer Flattened Hierarchy in BICC

The Customer Hierarchy Column Flattened data object in Business Intelligence Cloud Connector (BICC) has been enhanced to include the following additional columns for all hierarchy levels 0 through 9, along with the parent level.
Data Store Key:  CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerHierarchyColumnFlattenedExtractPVO
Additional Columns added:

• Party Name
• Party Unique Name
• Party Number
• Sales Account Id
• Parent D-U-N-S Number

This enhancement provides users with a more comprehensive alternative to the data store  CrmAnalyticsAM.PartiesAnalyticsAM.HzCustomerHierarchyBICVO for use in data warehouses, integrations, and downstream reporting. 

Steps to enable and configure

Edit the data store CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerHierarchyColumnFlattenedExtractPVO, and click Select Columns to add these additional columns. See "Preview and Edit a Data Store for an Offering" in the "Creating a Business Intelligence Cloud Extract" documentation for more details.

Tips and considerations

CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerHierarchyColumnFlattenedExtractPVO continues to extract data from table HZ_PARTY_HIER_CF_DENORM which is updated by the scheduled process "Refresh Denormalized Data for Account Hierarchy". 

Key resources

Oracle Business Intelligence Cloud Connector (BICC)

Access requirements

Anyone who has access to BICC will have access to this Extract VO.