Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Combine Subject Areas — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Combine Subject Areas

Received Response
24
Views
4
Comments
edited May 6, 2020 2:29PM in Reporting & Analytics for Sales 4 comments

Summary

Trying to combine Snapshot SA with Pipeline SA

Content

Hello,

I need to combine the Pipeline SA with the Snapshot SA. "Sales - CRM Pipeline" with "Sales - CRM Opportunity Sales Stage Snapshot". I need to use the Employee Resource hierarchy from the Pipeline SA. I noticed that is not a dimension in the Snapshot SA. First question, Is this why I'm getting SQL error when try to join? They are not a common dimension. Second question, how do I filter the Snapshot data by the Employee Resource hierarchy? 

Thanks,

Stephanie

Version

11.1.1.9.0

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!