Logiacl sql for cross subject area analysis
Summary
Logiacl sql for cross subject area analysisContent
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,
Tagged:
1