An error is reported when Statistica's correlation analysis workflow is imported into Spotfire as a data function

[jiangyi Liu1706757917]

Hi~ 

With reference to the example 1 described in the linked documentation belows,an error reported when importing the corr.sdm which run successfully into Spotfire as data function.

corr.sdm and data files called OEE-dashboard010.csv are attached at the end of the artical.

The configuration operations are as follows:

 

1. Correlation Matrices node setting:

input:OEE-Dashboard010, variables:Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11 Var13 Var18 output(downstream):summary correlations

Result:

2. Spotfire(version:12.5) setting:

2.1 input:

2.2 parameters:default,no options are selected

2.3 outputs:

3. corr parameters setting:

3.1 input: no fillter,no mark

3.2 output:

After all the above configuration Settings are completed, an error is reported:

Statistica Data Function failed: corr

Error in node 'Correlation Matrices':

At least two variables should be selected to proceed with the analysis.

2024-03-20 16:22:50.998 [Information] Received message: ["run C:\Users\Admin\AppData\Local\Temp\TIBCO\Spotfire\12.5\unj4zx15.q3q\WorkspaceToExecute.sdm  --overwrite    --input C:\Users\Admin\AppData\Local\Temp\TIBCO\Spotfire\12.5\unj4zx15.q3q\Inputs   --output C:\Users\Admin\AppData\Local\Temp\TIBCO\Spotfire\12.5\unj4zx15.q3q\Outputs   --output-format spotfire-data "]
2024-03-20 16:22:51.025 [Information] Running task: "C:\Users\Admin\AppData\Local\Temp\TIBCO\Spotfire\12.5\unj4zx15.q3q\WorkspaceToExecute.sdm"
2024-03-20 16:22:51.473 [Information] Opened workspace "C:\Users\Admin\AppData\Local\Temp\TIBCO\Spotfire\12.5\unj4zx15.q3q\WorkspaceToExecute.sdm"
2024-03-20 16:22:51.645 [Error] > Exception in automation method [CDataMinerDoc::XDMNodeHelper::GetNumberOfSelectedVariables]: Invalid variable list
2024-03-20 16:22:51.673 [Error] > System.Runtime.InteropServices.COMException (0x80004005): At least two variables should be selected to proceed with the analysis.
   in StatSoft.DataMinerNodes.Model.CorrelationMatrices.ExecuteModelBase(IDMNodeHelper DataMiner, DataMinerNode pThisNode, Object inputDescriptorArray, StaDocCollection pResultsDocs, InputDescriptor& ppOutputData)
   in StatSoft.DataMinerNodes.Model.ModelBase.Execute(IDMNodeHelper DataMiner, DataMinerNode pThisNode, Object inputDescriptorArray, StaDocCollection pResultsDocs, InputDescriptor& ppOutputData)
2024-03-20 16:22:51.675 [Error] > Workspace ThrowNuggetException related to node [Correlation Matrices], message [At least two variables should be selected to proceed with the analysis.
]
ErrorCode: 0x80004005
ErrorInfo: An unspecified error
2024-03-20 16:22:51.676 [Error] > At least two variables should be selected to proceed with the analysis.

2024-03-20 16:22:51.677 [Error] > Exception in automation method [CDataMinerDoc::XDataMinerDispatch::Execute]: Error in node 'Correlation Matrices':

At least two variables should be selected to proceed with the analysis.

2024-03-20 16:22:51.724 [Fatal] Runtime error:
System.Runtime.InteropServices.COMException (0x80040201): Error in node 'Correlation Matrices':

At least two variables should be selected to proceed with the analysis.

   in STATISTICADataMiner._DataMiner.Execute()
  in Statistica.Engine.Application.Sta.Run(String runPath, RunOptions opt, Spreadsheet ssIn, Spreadsheet& ssOut, Workbook& outputWorkbook)
   in Statistica.Engine.Application.Sta.Run(RunOptions opt)
   in Statistica.Engine.Application.Sta.LocalServer(ListenOptions opt)

Hope that someone can help me out. I'd appreciate it,thanks!

 

corr.sdm OEE-Dashboard010.csv

[Tomas Jurczyk]

Hello

From the screenshots above I would say the problem is that the variable names do not match. In Statistica workspace, you have these variables:

And in dashboard, you are sending these variables:

 

 

Correlation node will be looking for Var1, Var2,...

Another problem is that input data in Statistica data function are not properly loaded into Statistica (as first row should be variable name, not as a text in first row of the data, also percentages data are not properly loaded).

I have changed the workspace to have proper variable names. 

Please, try to use workspace in the attachment instead.

Best regards

Tomas

 

corr2.sdm

[jiangyi Liu1706757917]

Thank you very much ! it runs perfectly now.