Salesforce SOQL: Attribute not found when traversing/querying sObject relationships
I am trying to use RapidMiner (7.2.003) to automate some of my more advanced reporting that requires advanced SOQL across multiple objects for accuracy. Specifically, I need to understand the stage of the opportunity as well as the status of the quote, finally aggregating the quote line data to summarize sales performance from quote to invoice conversion.
I can successfully traverse an sObject relationship to generate a table, but if I attempt to do anything (select attributes, set roles, etc.) with fields accessed via an sObject relationship (fields which are not native to the explicitly declared "FROM" object), RapidMiner throws an "Attribute not found" error. Originally, I thought this could have something to do with the use of dot-notation so I attempted to alias out the referenced fields which did not work. I attempted to fix the data using Rename, Rename by Replacing - none of these worked.
I have to use separate Read Salesforce Operators to pull individual field sets from the individual objects and then join them which is not something I'd like to do, if I have N Read Salesforce operators, I would require N-1 Join operators and, at formally least, N data prep operators. Does anyone have a workaround or access to guide materials for using Salesforce SOQL inside of RapidMiner?
Thanks!