Qlik Explorer for Developers App Open Flow - Report Output Interpretation

[Duber101]

The App open progress report produced by the Qlik Explorer for Developers tool has revealed that an App is spending approx. 80% of it's open time loading fields and tables and then approx. 20% of it's open time doing the following steps:

• Attached to loaded document
• Pre-generating dimensions
• Generated 8 dynamic dimensions

What do each of these 3 steps mean ?

[rwunderlich · Accepted solution]

I believe the generating of dimensions has to do with pre-generating, for performance reasons, calculated dimensions and fields-on-the-fly. See https://community.qlik.com/t5/Design/Calculated-Fields/ba-p/1694383

-Rob

[Duber101]

Thanks @rwunderlich, removing all master dimensions with calculations' - by moving them to load script - have reduced two of those steps to 0 seconds, and reduced App opening time. That leaves one unknown step which is taking a bit of time, do you know what 'Attached to loaded document' means ?

[rwunderlich]

I think "Attached to loaded document" is a checkpoint step rather than a processing step. That "step" is always duration 0 by my calculation.  The fact that you are seeing it as taking time may be due to how QDE reports durations. In my interpretation the duration should actually be attributed to the previous step. For example, here the 0.5s / 18.8% is actually spent in the "Building field relation state" step. And the 1.6s is spent in "Loading fields", not "Loaded 95 fields". 

This may just be a design decision. I'll tag @Øystein_Kolsrud here to comment on QDE.  In QSDA Pro I attribute the duration to the previous line. Here's a similar open report from QDE and QSDA Pro side by side. 

-Rob

[Øystein_Kolsrud]

Yes, the dt-part simply denotes the delta between this, and the previous message in Qlik Explorer. But you're right! Maybe it would be better to more clearly state the time spent on the individual steps instead of using that way to print the delta.

[Onkar_Kulkarni]

@Øystein_Kolsrud - what is the best way to connect QEFD to QlikSense On-Prem server? I was able to connect to cloud tenant using API key, but struggling to connect to customer On prem env. Domain\User ID and Password is not working.

[Øystein_Kolsrud]

It depends on how you're virtual proxies are configured. QEfD supports Windows authentication (that's the connection types "Logged on user" and "Other credentials"), anonymous connection, header authentication, JWT authentication and direct connection using certificates. All but the last one require that you have a virtual proxy configured to support that type of authentication. And the last one requires that you have access to the certificates.