SAP Knowledge Base Article - Public

2458733 - Opportunity History Snapshot Data Source Cannot Be Used For New Join

Symptom

You try to create a new joined data source with the Opportunity History Snapshot data source and it is not available.

Reproducing the Issue

1. Log on to your CLOUD FOR CUSTOMER System
2. Go to the Business Analytics work center and the Design Data Sources view
3. Click on New and Joined Data Source
4. Click on Add Data Source and search for data source Opportunity History Snapshot (technical ID CRMOPPHHB)

You will see the message No search results.

Cause

The data source Opportunity History Snapshot (CRMOPPHHB) is using a temporal join type = "Based on validity time stamps", therefore the join is not supported from analytics framework.

Resolution

This is the expected system behaviour. It works as designed.

 

See Also

You can use the data source Opportunity History Snapshot for new combined data sources.

Or as an alternative you can use the data source Opportunity History (CODOPPHHB) for new joined data sources.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP HYBRIS C4C ADDINS 1705 ; SAP Hybris Cloud for Customer 1611 ; SAP Hybris Cloud for Customer 1702 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711