Tracking Opportunity Status in the Link Satellite

[saqib]

Hello,

We have Opportunities and Accounts. Each Opportunity may have 1 or more Widget as part of that Opportunity. The Widgets are Dependent Child in the LINK_OPPORTUNITY_ACCOUNT_SALES_ENGINEER. The Sales Engineer Assigned to the Opportunity may change during the course of the Opportunity

We need to track the Status of the Opportunity at the Widget Level. There is a date (STATUS_DATE) associated with transition from one State to another. I am planning to hang a Satellite from the Link with:
LINK_OPPORTUNITY_ACCOUNT_SALES_ENGINEER_HASHKEY + LOAD_DATE + STATUS_DATE as the PK for the SAT.

Is this in-line with the DV Standards?

What I am unsure about is that the LINK and the SATL will be at different grains.

Please advise.

Thanks.
Saqib

[patrickcuba]

Seems fine,

“a sat is a sat is sat”

whether the parent is a link or a hub, it’s still a SAT.

• SAT
• SAT+DEPKEY
• MSAT

[saqib]

Thanks @patrickcuba . I just wasn’t sure since we added the STATUS_DATE to the PK of the SAT. That changes the grain of the SAT compared to the LINK it is hanging from.

[patrickcuba]

But in essence it is now the dependent-child key of the sat right?

[saqib]

@patrickcuba . I thought the dependent child could only live in the LINK_.

[patrickcuba]

Nope, and we had discussed this before. Please review earlier discussions on this forum.

[saqib]

Thanks @patrickcuba