Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.
If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. https://ibm.biz/AnalyticsIdeasPortalRegister
This is something that used to work as expected in prior releases, but stopped working since v18.0.0.1 that we are aware of.
Steps taken towards issue:
Step 1: add a Source node
Step 2: add a Sort node
Step 3: select a few fields in Sort node to sort with
Step 4: connect a Filter node between the Source and Sort nodes
Step 5: in the Filter node, rename a field used by the Sort node (ie. rename field3 to field3a)
Step 6: open the Sort node
Observation:
Obs1: In v14.2.0.3 - the field appears red, signifying an invalid field name
Obs2: In v18.0.0.1 - the field is not flagged(highlighted) and looks valid even though it is not.
Obs3: The aggregate node does not have this issue when inserted in this scenario
Step 7: Click Preview
Observation:
The stream will run and complete in either version, and the log messages warn of the missing field.
Example of log messages after renaming "field3" to "field3a" in the filter node:
Information: Stream execution started
Ignore the invalid field "field3" in the Sort node
Stream execution complete, Elapsed=0.09 sec, CPU=0.05 sec
Moving forward:
This seems like something the application should flag as SPSS Modeler does with any other anomaly.
We would like to see this corrected in future releases if possible.
Real Scenario + Problem Statement
|
|
Role Summary | |
Who would benefit from this IDEA? | |
Revenue Opportunity
|
|
Idea Priority | Low |
How should it work?
|
|
Owning Tribe | |
Owning Segment | |
Submitter Tags | |
Customer | |
Geo - Use for OBDR Reporting only | |
Why is it useful?
|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions
Please submit a support ticket on this.
Attachments Open full size
I began by submitting a support ticket for this:
TS000108837 - Invalid field name not flagging on sort in SPSS Modeler 18.0.0.1
https://www.ibm.com/mysupport/s/case/50050000012XReH/invalid-field-name-not-flagging-on-sort-in-spss-modeler-18001?t=1495123326130&tabset-0d016=1
The IBM support representative advised me that this behaviour "is working as expected (run time catching that discrepancy). You can always place a request into the RFE(Request Functional Enhancement) and request that be placed back into the latest version.
http://www-01.ibm.com/support/docview.wss?uid=swg21605672"
Attachments Open full size