Estoy tratando de automatizar la creación de mi gráfico JMP. Estoy creando una aplicación. A medida que se ejecuta la secuencia de comandos, muestra el resultado de la consulta y el informe. Luego guarda el informe como un documento HTML. El script completo tiene 4 consultas e informes diferentes. ¿Hay alguna forma de ejecutar el script donde no se muestre nada? Planeo que la aplicación muestre una ventana emergente que diga que el informe se está ejecutando, pero no quiero que se muestren los artefactos reales. Se adjunta un script de ejemplo.
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>
Debería poder especificar para ejecutar su consulta en "Fondo". Busque en el índice de secuencias de comandos en Consulta de SQL para "Ejecutar fondo". Y en cuanto al Gráfico de control, siempre puede especificar la opción "Invisible".
Gracias por la respuesta. Pude ocultar las tablas usando la opción "privada" (ya que no quería tener que cerrarlas cuando termine) No veo dónde usaría la opción invisible al generar el gráfico:
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 = Gráfico de control (invisible,
Sample Label ( : ReleaseMonth ) ,
Phase ( : Phase ) ,
Tamaño de muestra ( : Name ( "Suma Total" ) ) ,
KSigma ( 3 ) ,
Columna ( : OnTimePct , P ( Phase Level ( "1" ) < SPAN class = "token punctuation" style = "box-sizing: border-box ; color: # 000000; font-family: Consolas, Monaco, & amp; quot; andale mono & amp; quot;, & amp; quot; ubuntu mono & amp; quot;, monospace; tamaño de fuente: 14px; estilo de letra: normal; Variante de fuente: normal; peso de la fuente: 300; espacio entre letras: normal; huérfanos: 2; text-align: left; texto-decoración: ninguno; texto-sangría: 0px; transformación de texto: ninguna; -webkit-text-stroke-width: 0px; espacio en blanco: pre; espacio entre palabras: 0px; ">, Nivel de fase ( "2" ) < SPAN class = "token punctuation" style = "tamaño de caja: border-bo X; color: # 000000; font-family: Consolas, Monaco, & amp; quot; andale mono & amp; quot;, & amp; quot; ubuntu mono & amp; quot;, monospace; tamaño de fuente: 14px; estilo de letra: normal; Variante de fuente: normal; peso de la fuente: 300; espacio entre letras: normal; huérfanos: 2; text-align: left; texto-decoración: ninguno; texto-sangría: 0px; transformación de texto: ninguna; -webkit-text-stroke-width: 0px; espacio en blanco: pre; espacio entre palabras: 0px; ">) ) ,
Por ( : name )
) ;
