2 weeks ago
Hello,
First of all, this is my first post. Forgive me if I made a mistake.
i wanted to implemet this business content in my tenant:
After my investigations, I found that the error is in fact views such as SAP_FI_HL_JournalEntryBalanceTimeseries etc.
"INNER JOIN "SAP_FI_HL_TimeSeriesMonthlyValues" as "TimeSeries"
ON "GLAccountLineItem". "PostingDate" <= "TimeSeries". "TimeSeriesDate""
I see that the inner join operation multiplies the number of records in my transaction table. For example, the number of 96m records increases to 384 million. Is this a normal situation? Should my data not be multiplexed?
Thanks a lot!
Hi Enes,
Welcome to SAP Community !
Yes, the inner joins multiples the number of records in the result set of the query.
In your specific example: "INNER JOIN "SAP_FI_HL_TimeSeriesMonthlyValues" as "TimeSeries"
ON "GLAccountLineItem". "PostingDate" <= "TimeSeries". "TimeSeriesDate""
It seems to be there is a high probability there will be multiple records on "GLAccountLineItem". "PostingDate" <= "TimeSeries". "TimeSeriesDate""
I'd recommend you to focus on some multiplied sample records and you would see it.
Regards,
Tuncay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
11 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.