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

Visit Redwood Community
OTBI - Product Management - Cross Subject Area Logical SQL giving Error — 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 - Product Management - Cross Subject Area Logical SQL giving Error

Accepted answer
21
Views
3
Comments
edited Feb 9, 2021 10:47PM in Reporting and Analytics for SCM 3 comments

Summary

OTBI - Product Management - Cross Subject Area Logical SQL giving Error 'The selected request cannot be performed because it references an unknown subject area named'

Content

Hello,

I have created a very simple logical SQL, shown below. Can you please help me in understanding where am I doing the mistake.

SET VARIABLE ENABLE_DIMENSIONALITY = 1;
select SubjectArea1.Inventory_Item_id1, SubjectArea1.Item1, SubjectArea2.Inventory_Item_id2, SubjectArea2.Item_Class2, SubjectArea2.Item2
from (SELECT
   "Product Management - Source System Item Real Time"."Main"."Inventory Item Id" Inventory_Item_id1,
   "Product Management - Source System Item Real Time"."Main"."Item" Item1

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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