SPC Chart Usage in xMII

[Former Member]

I have requirement to draw spc chart by doing calculation taking the real time data from r/3.

I able to do the calculations and in the last stpe i have to draw the spc chart. The output of calculation is in the form of xacute query.

I selected as the source for the spc chart. It contains two different values one quantity and date.

date should come in x-axis and qunatity should come in y-axis, this is my requirement. Please let me know how to do this.

Thx

supriya

[Former Member]

hi

map date column to "attribute columns" in data mapping and "x axis label attribute" in ext mapping. now it will work

-senthil

award points if this is helpful

[Former Member]

Hi Senthil,

I am getting the output but the lables in the x and y axis are not correct.

1. X-axis should contain dates - so there are 5 dates which should be displayed in the x-axis.

2. The coressponding y-axis ranges from 80 130 so my y-axis should start from 80. with a 10 tehre should be values up to 130.

Please help me

thx

supriya

[Former Member]

hi,

give quantity in value columns of data mapping tab. dont give date in value columns. give date as per i said earlier. Go to upper chart tab, here set min range below 80 say 75 and Max range as more than 130 say 140. set user lower spec limit = 80 and user target as some value between 80 to 130, say 100. set user upper spec limit =130. and check only

show control limits, show tick marks, show labels check boxes on this same tab.

then move to limits tab, here set Lower control limit as 80, centerline as some value say 100 and upper control limit =130.

save this. now it will work.

-senthil

[Former Member]

Hi Senthil,

I amgetting teh required output. The labels in the x-axis are getting overlapped as they are date values. Please help me out for this.

Do let me know the importance of the upper, lower spec limit and user target fields in upper chart. When should we use lower chart.

thx

supriya

[Former Member]

hi,

in spcchart display template go to SPC axes tab and set in X axis settings -> ticks per label as 1 and label depth as 3. then you wont get overlapped output.

upper and lower limit are used to set an alarm values i.e if any of value going beyond these limits then that value marker (circle, square ..) appeared in different color to show it is beyond limit.

Lower chart is used in when range, Median values, Std Dev are used.

for more help see this link

http://localhost/LighthammerCMS/Help/Advanced_Topics/Illuminator_Quality_Portal/iSPCChart_Reference.... Reference

-senthil

award points if this is helpful

[Former Member]

Hi

The USL, LSL & Target are used when user wants to analyse the measurement values over a given time range. User can understand how much measurement points lie beyond USL and LSL if USL & LSL values are shown by mapping them in Display Template. And also Target is used to check how much measurement points lie closely almost near to Target over the given time period

The lower Chart is used when user wants to analyse the SPC Chart as Simple Average and Moving Range (Chart Type : XBAR-MR) or Simple Average And Range

(Chart Type : XBAR-RANGE). Here user can see chart comprising of 2 parts one upper chart, another lower part. In this cases, the lower chart is used to be confgured/set from Display Template

Regards

Som

Please feel free to ask furthers, if necessary

[Former Member]

Hi Senthil,

Thanks for the help. I am able to generate the graph in the spc chart. My requiremnet is i have to set the target say suppose 1000. And all the value points in graph below this target should be red in color. And there should be some tool tip visible for these points stating the reason why it has come down.And as soon as click on this a new graph should open showing all the matreial quanities genearted for that day. form which user can estimate due to which product the problem has occured.

Can you please reply me as early as possible.

Thx

supriya.

[Former Member]

Hi Som,

I got the expaination but can u tell how to implement this. I have given values for upper spec limit as 130 and target as 100 and lower spec limit as 70 in upper chart tab.

I have value which comes below 70 in the chart. How should i do some analysis on this. Please help me on this

thx

supriya

[Former Member]

hi,

for this you should go to upper chart limit tab on SPCchart and set lower and target as say 1000. now all point sbelow this value will display in red. you can change color of values below this limit in right side of this same tab. generate the applet by using dynamic page generator by selecting query and display templates.

copy applet source form view->source. copy this code in web page. add this code

before </applet> tag in this applet.

<param name="UpperChartClickEvent" value="<function name>">. save this page. say webpage1.htm (in wwwroot directory)

get the values of this chart via query and display templates in grid. query should be as select * from <this table name> where date=<today date>. set result of this in display template (grid). generate applet as said before from dynamic page generator and copy code of this from view ->source and paste it in seperate web page. save this web page.(for ex say webpage2.htm)

in our prev SPCChart applet, call function mentioned in UpperChartClickEvent. write a code in javascript for this function. In this function call our webpage2 as window.open("http://<server name>/wepage2.htm").

now call webpage1.htm. it will work as you expected.

-senthil

[Former Member]

Hi Senthil,

The points are not getting diplayed in red.

On the x-axis the value are dates. On click on each single point, the date should be captured and sent to the next page which should open.

Please explain on this in details

thx

supriya

[Former Member]

Hi Supriya

Suppose u hv some points below LSL/USL, then u can make a "comment" on that specific point that <b>This point lies beyond LSL/USL</b>.

This comment can be made by this following steps:

<b>Step 1</b> : Select any inspection data point on the SPC Chart

<b>Step 2</b> : Right-Click, then go to Upper Chart > Comments

<b>Step 3</b>: Then a popup window (Point Comments) comes up, then user click the Add button to get another smaller popup window (Comment Entry) to write a new comment and click the Add button. The comment entry is shown in the table ‘Point Comments’ as follows. Then click the Close button

When u hv made a comment, u'll see a red colored small icon on the selected point.

Limitations:

• Comments can only be made in simple average chart.

• When sub-group size equal to 1 (does not work for bigger size)

• Comments entered cannot be deleted, will always be visible when the data point is chosen

If u want to see the collection of comments made by different users, then u can get this by going Query Template Editor > New > SQL Query > Server = Quality Portal and Mode = Query. there u'll find an available table named <b>Comments</b>

Now if u want to analyze over all details of the SPC Chart, u can right-click, then go to Data > Summary Statistics

Regards

Som

Please feel free to ask furthers, if necessary

[Former Member]

Hi Som,

I am specifying the values in upper chart and i believe it does not belong to a lower chart. And the limitation for posting comments for a data point in a chart is it should be a lower chart.

So i my case it does not work ? I have tried the way how u mentioned. Right click on any data point and upper chart - > comments.

When i am saving the comments - i am getting a error as unable to save.

Can you also please me on other requirement -- > when the user clicks on data point which is below the limit. The material details for the value should be displayed. From which user will analyze due to which the problem has occurred.

thx

supriya

[Former Member]

Hi supriya

1) First of all. check whether or not the <b>MSSQL Server QualityPortal</b> is configured/enabled in your xMII system. Bcoz, this server has an available table "Comments" where all user-entered comments are stored (as mentioned about this in previous post).

Nope, if there is only one SPC Chart, this is considered as the Upper Chart. And You can make comments only for a SPC Chart with Chart type as Simple Average (XBAR). You can not make comments any other SPC Charts else than XBAR typed SPC Chart

2) When user clicks on any data value in the SPC chart, 4 options u can get details -

a) right-click -> Data > <b>Raw Data Details.</b>

b) right-click -> Data > <b>SPC Results Detail.</b>

c) right-click -> Data > <b>Summary Statistics.</b>

d) right-click -> Data > <b>Upper Chart Data Points.</b>

all of above details are for the whole SPC Chart, not only for one specific measurement points. But just simply get the detail for any specific data point from the list of all over point details, if u want.

And, for only one data point, u can make comment entry to be analyzed.

Now, if u want to show the details of data points in a new page, then use javascript in the IRPT page to show using this method call <b>document.iSPCChart.showUpperChartPoints()</b>, if u know use of IRPT page and have installed <u>SAP xMII Script Assistant</u>, then u can get many optional method calls to get desired details of SPC Chart

Please feel free to ask furthers, if necessary

Regards

Som

[Former Member]

Hi Som,

Can you please suggest me how to chekc whether the mssql server qulaity portal to be installled.

If it is not how to install.

thx

supriya

[Former Member]

Hi Som,

Please let us know how to do the IRPT page and SAP xMII Script Assistant.

thx

supriya

[Former Member]

Hi supriya

1. Check this pathname to Quality Portal installed in your xMII system

<servername>\Lighthammer\Illuminator\QualityPortal

This is installed along with xMII system installation.

2. In the xMII Menu, under the section <b>Visualization Services</b>, click "Wizard Install" for SAP xMII Script Assistant

3. for IRPT pages, u need to have knowledge on javascript. For a web page creating with applets do make a notepad with javascript tags and save that with .irpt extension in <b>
<servername>\wwwroot\<newfolder>\<IRPTPageName>.irpt</b>

To have more clear conceptions on xMII, please this

<a href="http://help.sap.com/saphelp_xmii115/helpdata/en/index.htm">link</a>

Regards

Som

[Former Member]

Hi Som,

I able to see that directory in my Light Hammer directory. It contains two sql files. In the MSSQl file contains a query to create commnets table as u mentioned earlier.

How to proceede on this.

I have knowledge about java script. My question is how to do integration can u explain on this.

thx

supriya

[Former Member]

Thanks

Supriya