Skip to Content
0

UJSTAT statistic explanation

Apr 28 at 02:40 AM

39

avatar image

Dear colleagues,

I am wondering if there is a document that explains what the items and sub-items in UJSTAT performance statistics report are doing?

For example, for Write Back Application Data/Shared Query Engine Read/Parallelization framework main session, what action in EPM Add-In will trigger these items?

And for the same item, why are the sub-item below it different sometimes?

(see pic SQE-read 1 & SQE-read 2).

And specially, could anyone tell me what the sub-item Update Audit and Writeback Callback is actually doing under item Write Back Application Data? It takes several seconds to do that most of the time for one model. However, the case is nearly 0 second in another model. Why is that?

And the item Generate tuple for row and column is also taking several seconds to finish, which is confusing us...

Any ideas are welcomed, thanks in advance!

Best regards,

Haley

sqe-read1.png (25.8 kB)
sqe-read2.png (25.7 kB)
write-back.png (45.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Apr 28 at 07:22 AM
0

"could anyone tell me what the sub-item Update Audit and Writeback Callback is actually doing"

Audit update: if you have data audit enabled for the model and for the dimension members then it will take time to write to audit tables.

Writeback Callback: If you have write back badi it will also take time to process.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

Thanks for the helpful information!

0

If your question is answered, please accept the correct answer!

0

P.S. Small correction

Writeback Callback: during callback default.lgf is processed (interpreted)

0