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

Logiacl sql for cross subject area analysis

edited Jun 26, 2020 9:19AM in Reporting and Analytics for ERP 4 comments

Summary

Logiacl sql for cross subject area analysis

Content

Hello All,

I am trying to create a cross subject area logical sql for receivables as below. However I still get error while running this sql. Can anybody help on what is wrong with this sql

 

SET VARIABLE ENABLE_DIMENSIONALITY = 1; 
SELECT 
SubjectArea1.s_1 s_1, 
SubjectArea1.s_2 s_2, 
SubjectArea1.s_3 s_3, 
SubjectArea1.s_4 s_4, 
SubjectArea1.s_5 s_5, 
SubjectArea1.s_6 s_6, 
SubjectArea1.s_7 s_7, 
SubjectArea1.s_8 s_8, 
SubjectArea2.s_9 s_9, 
SubjectArea2.s_10 s_10 

FROM 

SELECT 
"Receivables - Receipts Details Real Time"."Receipts"."Receipt Accounted Amount" s_1, 
"Receivables - Receipts Details Real Time"."- Paying Customer Details"."Paying Customer Number" s_2, 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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