on 12-09-2015 10:20 AM
Hi Experts,
I am a new bird in SAP SFIN. I am going through different SFIN blog posts and documents and getting confused on some of the points. It would be really thankful to you if you would clear my below doubts.
How the system will calculate the aggregate values on the fly in BSEG table as the materialized aggregate tables have been already obsoleted in SAP SFIN?
Materialized view (BSIS,BSAS,BSIK,BSAK etc.) and Materialized aggregate(GLT0,FAGLFLEXT etc.) are now obsolete in SFIN but still exist with compatibility view. what does it mean?
Appreciate your early feedback.
Regards,
Mohammed Kalim
Hey Mohammed,
Please refer one of the existing thread where this issue was discussed:-
http://scn.sap.com/thread/3775286
About your query, the idea of having aggregates and index was for faster reporting.
But with Hana you can have aggregates very quickly,
So all the old tables ( as mentioned by you) are replaced by view, which will not have data footprint and will collate data on the Fly when referred.
Hope this helps,
Please close the thread.
Regards,
Rishab
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Mohammed,
By on the Fly, SAP means that you can get the sum / total values very quickly. That means the reporting will be made quicker and on data model side there will be less number of tables.
Previously we would have total's / index table to enable faster reporting, now with HANA this is not needed.
I think your question is how
With HANA db there are a lot of changes, faster access, Row-Column storage etc.
So this is my take:-
1) BSEG may be a column table ( could not verify this), so summation at db level becomes faster.
2) Other aspect can be views which are available on BSEG which may help in faster reporting of aggregates
Found one ( my guess )
Hope this helps,
I wish I could better explain this point but not an expert in HANA.
If this is clear please close the thread.
Regards
Rishab
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.