Teiid 7.4 version adds a new OLAP Translator. This translator mimics more like File translator. Designer needs to add support for this translator. In order to use this translator supported procedure, Designer also need to support "arraytable", I think once the Designer libraries are upgraded to 7.4 this will be generally available. Until this JIRA is user can always hand model the procedure for OLAP source, which in the from

ResultSet invokeMDX(String mdxQuery)

The Resultset above should have a single column called "tuple" with data type "Object". During the runtime, this Object is really Object[] that can be used as below

select t.* from (call invokeMDX('query')) x, arraytable(x.tuple COLUMNS col1 string, col2 integer) t;