cancel
Showing results for 
Search instead for 
Did you mean: 

How to use the mii spc(Best to give me an simple example)

Former Member
0 Kudos

Hi,all:

     Recently,I have a project need to use mii spc technology,customers want to achieve the alarm and send email to manager by mii spc.

I don't konw how to do this,I have seen the help document but I still confused, I want to konw step by step,so anybody who can give me an example?

an simple example?

or tell me like this:

1.xxxxxxx

2.xxxxxxx

...........

for exmaple:

1. create a iSPCChart  ......

2.create a transactions, add a SPC/SQC Chart action ......

.....

thanks very much!  I'm Looking forward to your help!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

anybody who can help me.  I am very confused. any suggestion?

jcgood25
Active Contributor
0 Kudos

Do you have the query template and SPC chart display template configured with the desired alarms?

If so, and you have a working applet with a red marker that you would like to send the information in an email, then use the right click menu to get the SPC Results detail (not the standard data).  If you can see this in XML, please look for the proper section in the results (in XML is preferred) for the chart alarms.

This xml data is also what is produced by the SPC/SQC action block in a business logic transaction.  You will need to combine the same query template/display template to produce the data.  Match up the data point number with the relevant information about the data record, limits, etc. and the alarm text.

Determine your logic for building the relevant message from the SPC/SQC results, and send your email accordingly.

Former Member
0 Kudos

Thank you very much, Jeremy.It was very helpful to me.

But I still have some questions(please forgive me rookie):

1. I have the SPC chart display template configured with the desired alarms

2. Which section in the results I need to look for? I can't find any information about chart alarms but I can see the red marker in applet

3. I combine the same query template/display template to produce the data. the next, how to match up the data? the "EncodedImage"? I don't quite understand that you said "Match up the data point number with the relevant information about the data record, limits, etc. and the alarm text".

can you give me some operating documents for this(preferably with pictures)?

hope your help! thanks!

jcgood25
Active Contributor
0 Kudos

Look at the XML results from the action block (not the action block that produces a picture) and you'll see that one of the Rowsets has the alarm text and the data point numbers.  The first Rowset is the summary stats, and the second one is the upper chart data points.

Former Member
0 Kudos

Thanks,Jeremy,I have understand what you mean.

But I'm Sorry, you said the action block which include the XML results is SPC/SQC action block?

if it is,I didn't see that you told me the "Rowsets",I see the contents as below:

There is no "Rowsets" information.

Where have I done wrong?

jcgood25
Active Contributor
0 Kudos

Use the other action block in the quality category - the analysis one, not the chart image.  The correct action will provide you with the calculation data and information (including alarms).  If you have a working iSPCChart applet on a web page and use the right click menu to show the spec results (not the raw query data) you will see the same dataset that the spc/sqc analysis action block generates.

Former Member
0 Kudos

Thanks,Jeremy.I do with your method.

But Sorry, I still can't find the alarms information.Where is the alarm text?

jcgood25
Active Contributor
0 Kudos

In your Results XML you will see Rowsets with 6 different Rowset documents inside.  Rowset[2] is the Upper Chart Data Points, and Rowset[3] are the alarms for the upper chart.

I will repeat one more time - please test your QT/DT as an applet and use the right click menu Data...SPC Results (this has helper text in the output for you to read and follow).  Using the right click menu and selecting Data...SPC Results as XML should show you the same data but display it in xml without the helper text.  This is the XML results that are produced by the SPC/SQC Analysis action block.

You will see something like this in your Rowset[3], which you can easily use in a Repeater action, and the POSITION is the same as found in Rowset[2], along with the data point values, limits, and other attributes.:

- <Rowset>

- <Columns>

<Column Description="POSITION" MaxRange="0" MinRange="0" Name="POSITION" SQLDataType="4" SourceColumn="POSITION" />

<Column Description="DESCRIPTION" MaxRange="0" MinRange="0" Name="DESCRIPTION" SQLDataType="1" SourceColumn="DESCRIPTION" />

</Columns>

- <Row>

<POSITION>5</POSITION>

<DESCRIPTION>5 of 5 points steadily increasing or decreasing</DESCRIPTION>

</Row>

- <Row>

<POSITION>6</POSITION>

<DESCRIPTION>5 of 5 points steadily increasing or decreasing</DESCRIPTION>

</Row>

- <Row>

<POSITION>7</POSITION>

<DESCRIPTION>5 of 5 points steadily increasing or decreasing</DESCRIPTION>

</Row>

- <Row>

<POSITION>7</POSITION>

<DESCRIPTION>Outside of specification limits</DESCRIPTION>

</Row>

</Rowset>

Former Member
0 Kudos

Thanks,Jeremy.Maybe I expression is not clear enough.

Yes,I saw you said but I mean is that I don't know how to  judge  whether have alarm information and then decide whether to send email.


If upper chart no alarm, the Rowset[3] don't have "Row" node.

If  upper chart no alarm but lower alarm,the Rowset[6] have "Row" node what include alarm information.


Now the problem is that I don't  know how to write the judgment expression in Conditional action block.

Like the upper chart no alarm or have alarm, what is the judgment expression?


Please forgive me this stupid student.

Really appreciate you help me so much!



Former Member
0 Kudos

First Repeater action I can get the RowSets, But how to get the "Row" blew RowSet[3] and RowSet[6]?

is like this?

The second Repeater action XPath expression is right?

if the XPath == Repeater_0.Output/Rowset/Row  then the result is all Row not the Rowset[6].

What should I do?

Former Member
0 Kudos

I have the problem too.How to get the special Row in /Rowset/Row in XMII , as /Rowset[5]/Row?but it does not work in XMII

jcgood25
Active Contributor
0 Kudos

To repeat on the SPC SQC results xml use:  SPC_SQC.Results{/Rowsets/Rowset[3]/Row}  - every iteration in the repeater will give you access to the Row and POSITION and DESCRIPTION information.  The same can be done for the lower chart alarms with SPC_SQC.Results{/Rowsets/Rowset[5]/Row}

Not all charts have both upper and lower, such as XBAR, EWMA, etc.

Concerning the rules for your conditional logic I can't help very much here since I don't have any idea what you are trying to accomplish.  I was attempting to explain where the alarms would appear, and how to get the relevant information from the results of the SPC_SQC Analysis block.  Using the runtime applet helps you to visualize the information and see the alarm details.  If you can point to an alarm(s) on the running chart and say that an email should be sent to alert someone about the alarm, then the logic in your transaction would have to use the proper approach to check the xml results.

Former Member
0 Kudos

Jemery,Really thank you very much! all your replies were very helpful to me and give me great encouragement,so thank you! thank you very much!

Actually,I want to do only two things:

1. Judge whether the running chart is abnormal.

2. If have,get the alarms information and send email to alert someone.

Concerning the rules for my conditional logic, in fact,I just judge whether the RowSet is I want,such as RowSet[3]. Now it seems as if that isn't necessary,you have gave me a right way.

Now,I met the problem has basically solved. Thanks for  your help! I learned a lot from your replies.


Former Member
0 Kudos

it is very helpful,thanks!

Answers (0)