Logiacl sql for cross subject area analysis

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,