FDI CX -Opportunity Revenue Line:Resolving Registry IDs Across Sales Account Hierarchy

Summary:

Hi Team,

I am working in Fusion Data Intelligence (FDI) using the CX - Opportunity Revenue Line subject area and need some clarification on Sales Account Hierarchy behavior.

My requirement is to display the following for each Opportunity:

• Opportunity ID
• Sold-to Customer Number
• Top Registry ID
• Parent Registry ID (Level 8)
• Child Registry ID (Level 6)

I am using the following attributes from:

Sales Account > Sales Account Hierarchy

• Top Level Sales Account Party Identifier
• Level 8 Sales Account Party Identifier
• Level 6 Sales Account Party Identifier

From the generated logical SQL, I can see the hierarchy table being used is:

DW_CXS_SALES_ACCOUNT_CF_DN_DH