Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Go to solution Solved by Tomas Jurczyk,

Recommended Posts

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

image.png.8e8861ab3e0252cd1b7fa60e190d956a.png

Result:

image.thumb.png.8c523794c6c2a01175d1cc2ee214e3f7.png

2. Spotfire(version:12.5) setting:

2.1 input:

image.png.df2612e97174c2160cdae78c15a7b9a3.png

2.2 parameters:default,no options are selected

image.png.9a8d29625b6f6c373ad172abcd189d96.png

2.3 outputs:

image.png.ca81887364b512a7d358bef0962ce2f8.png

3. corr parameters setting:

3.1 input: no fillter,no mark

image.png.a7ded84d0c282447de647f523d8beae0.png

3.2 output:

image.png.dbc4482eabd92ef3f280c6b0cc61df07.png

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

Link to comment
Share on other sites

  • Solution

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:

image.png.725cb988d67caa016c86e9c1f79ea29f.png

And in dashboard, you are sending these variables:

 image.png.e5c88df58f7e8bd10ceb1d07d04d5d45.png

 

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. 

image.png.5e11e51edd7054eca6e3a41dd7d1bb9b.png

Please, try to use workspace in the attachment instead.

Best regards

Tomas

 

corr2.sdm

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...