UJSTAT statistic explanation

[haley_zhang]

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

[former_member186338]

"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.

[haley_zhang]

Hi Vadim,

Thanks for the helpful information!

[former_member186338]

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

[former_member186338]

P.S. Small correction

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