Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
OTBI Analysis - Results from subject area incorrect join (OR no join?) — 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

OTBI Analysis - Results from subject area incorrect join (OR no join?)

Question
15
Views
0
Comments
edited Sep 15, 2020 10:34AM in Reporting and Analytics for SCM

Summary

OTBI Analysis on subject area Product Management - New Item Request Approval Real Time

Content

Hello,

I am trying to create a simple analysis on which I am interested in showing following information
1. Item Number, Item Class
2. Associated New Item Request Number, Status, Sequence Number, Status Start Date, status finish date.
3. Step Sequence Number details like Step Sequence Number and Step Start and Finish time.

The issue here is that, the step sequences are only associated with sequence number 20 and hence my expectation is that step sequence number should only appear against the sequence number 20. Where as on the subject area, when I pick these columns the step sequence number appears against all the sequence numbers.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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