Hi Dries,
30 seconds seems pretty slow to me. I just tried it on a test system and it took more like 7 seconds.
The behavior where the system reads the fact table joined to the dimension tables is normal for BW. BW is a star-schema ROLAP model, so any query of the cube is going to involve joining the dim-tables with the e/f-tables. This join is fast because the tables are fully indexed on the join key (or at least we hope they are ;-).
The system needs to read the cube whenever you post a journal so that it can write a delta record (the calculated value minus the value already on the database) if you are posting a journal to an intersection that already has data. Journals are additive, but since the journal functionality still goes through the normal write-back routine, I think it still does this delta calculation. I haven't looked at the ABAP for a while, so it could have changed, but that's what I recall.
The fact that the query is running more than 10 times does seem odd to me, but I haven't looked into the query execution for journal posting, so I'm not sure what it it doing. Do the multiple queries run sequentially or in parallel? Is the total time for the multiple queries similar to the total time for posting the journal, or is there something else going on?
Ethan
Edited to clarify about journal delta calculation - journals are additive to values already on the database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.