Sto cercando di automatizzare la creazione del mio grafico JMP. Sto creando un'applicazione. Mentre lo script viene eseguito visualizza l'output della query e il report. Quindi salva il report come documento HTML. Lo script completo ha 4 diverse query e report. C'è un modo per eseguire lo script in cui non visualizza nulla? Ho intenzione di fare in modo che l'applicazione mostri un pop-up che dice che il report è in esecuzione, ma non voglio che vengano visualizzati i manufatti reali. In allegato c'è uno script di esempio.
planetQ <SPAN class="token operator">=</SPAN> <SPAN class="token function">New SQL Query</SPAN><SPAN class="token punctuation">(</SPAN>
Connection<SPAN class="token punctuation">(</SPAN>
<SPAN class="token string">"CONNECTION INFO HERE"</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
QueryName<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ON_TIME_SPC_PLANET"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Select<SPAN class="token punctuation">(</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ReleaseMonth"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN> Numeric <SPAN class="token function">Format</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"m/d/y"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"-1"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"NO"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">""</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"PLANET"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN>
<SPAN class="token string">"On-Time"</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN>
Alias<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-On-Time"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
SavedJMPName<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"On-Time"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Aggregation<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
JMP Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-On-Time"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">0</SPAN> <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN>
<SPAN class="token string">"Total"</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN>
Alias<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
SavedJMPName<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Total"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Aggregation<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
JMP Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">0</SPAN> <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Phase"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN> Analysis <SPAN class="token function">Type</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Nominal"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
From<SPAN class="token punctuation">(</SPAN> Table<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ON_TIME_SPC"</SPAN><SPAN class="token punctuation">,</SPAN> Schema<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"dbo"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN> Alias<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Group By<SPAN class="token punctuation">(</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ReleaseMonth"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN> Numeric <SPAN class="token function">Format</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"m/d/y"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"-1"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"NO"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">""</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"PLANET"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Phase"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Order By<SPAN class="token punctuation">(</SPAN>
<SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN>
<SPAN class="token string">"ReleaseMonth"</SPAN><SPAN class="token punctuation">,</SPAN>
<SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN>
Numeric <SPAN class="token function">Format</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"m/d/y"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"-1"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"NO"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">""</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Order<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Ascending"</SPAN> <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN> <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN><SPAN class="token messages"> Run Foreground</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
planetQ <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN><SPAN class="token messages"> New Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"OnTimePct"</SPAN><SPAN class="token punctuation">,</SPAN>
Formula<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-On-Time"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token operator">/</SPAN> <SPAN class="token punctuation">:</SPAN>Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
<SPAN class="token function">wait</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token number">1.0</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
<SPAN class="token function">current data table</SPAN><SPAN class="token punctuation">(</SPAN>planetQ<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
planetP <SPAN class="token operator">=</SPAN> Control Chart<SPAN class="token punctuation">(</SPAN>
Sample Label<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>ReleaseMonth <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Phase<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>Phase <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Sample Size<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
KSigma<SPAN class="token punctuation">(</SPAN> <SPAN class="token number">3</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
Chart Col<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>OnTimePct<SPAN class="token punctuation">,</SPAN> P<SPAN class="token punctuation">(</SPAN> Phase Level<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"1"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN> Phase Level<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"2"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
By<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>PLANET <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
Dovresti essere in grado di specificare di eseguire la query in "Sfondo". Cerca l'indice di scripting in SQL Query per "Esegui sfondo". E per quanto riguarda la Tabella di controllo, puoi sempre specificare l'opzione "Invisibile".
Grazie per la risposta. Sono stato in grado di nascondere le tabelle usando l'opzione "privata" (dato che non volevo doverle chiudere quando ho finito) Non vedo dove utilizzerei l'opzione invisibile quando si genera il grafico:
ppnP = Control Chart(
Sample Label( :ReleaseMonth ),
Phase( :Phase ),
Sample Size( :Name( "Sum-Total" ) ),
KSigma( 3 ),
Chart Col( :OnTimePct, P( Phase Level( "1" ), Phase Level( "2" ) ) ),
By( :name )
);
ppnP = Control Chart (invisibile,
Etichetta di esempio ( : ReleaseMonth ) ,
Fase ( : Fase ) ,
Dimensione campione ( : Name ( "Totale somma" ) ) ,
KSigma ( 3 ) ,
Chart Col ( : OnTimePct , P ( Phase Level ( "1" ) < SPAN class = "token punctuation" style = "dimensionamento della casella: border-box ; colore: # 000000; famiglia di font: Consolas, Monaco, & amp; quot; andale mono & amp; quot ;, & amp; quot; mono & amp; quot;, monospace; dimensione carattere: 14px; stile carattere: normale; font-variant: normal; font-weight: 300; spaziatura lettere: normale; orfani: 2; allineamento del testo: a sinistra; decorazione del testo: nessuna; rientro del testo: 0px; Trasformazione del testo: nessuno; -webkit-text-stroke-width: 0px; white-space: pre; word-spacing: 0px; ">, Livello fase ( "2" ) < SPAN class = "token punctuation" style = "dimensionamento della casella: border-bo X; colore: # 000000; famiglia di font: Consolas, Monaco, & amp; quot; andale mono & amp; quot ;, & amp; quot; mono & amp; quot;, monospace; font-size: 14px; stile carattere: normale; font-variant: normal; font-weight: 300; letter-spacing: normale; orfani: 2; allineamento del testo: a sinistra; decorazione del testo: nessuna; text-indent: 0px; trasformazione del testo: nessuna; -webkit-text-stroke-width: 0px; white-space: pre; word-spacing: 0px; ">) ) ,
Da ( : nome )
) ;
