Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How to create a report combing planning and item category information with 2 subject areas

edited May 8, 2023 6:43AM in Reporting and Analytics for ERP 3 comments

Summary:

Unable to create a report combing planning and item category information with 2 subject areas

Content (required):

There is an existing OTBI report created thru Supply Chain Planning Real Time for planning module, and I would like to add the category show in the report. However, Category Set Name could not show required category from both subject areas "Product Management - Cross Reference Item Real Time" and "Product Management - Item Catalog Category Hierarchy Real Time".

"Compound Layout

 Error View Display Error Error during query processing (SQLExecDirectW).

  Error Details

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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