topic Qlikview can query from SSAS data mining structure via DMX in QlikView https://community.qlik.com/t5/QlikView/Qlikview-can-query-from-SSAS-data-mining-structure-via-DMX/m-p/187401#M51094 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>After creating data mining structure in SSAS , i connect to it with msolap provider and i query the structure (microsoft clustring ) with DMX language. I specify sql before my dmx query :this is the query :</P><P>load *;</P><P><B>SQL</B> select FLATTENED [Id Client]</P><P>from [rfm ].CASES</P><P>where ISINNODE('003');</P><P>Don't forgot FLATTENED CLAUSE , it make the result on Tabular format . What do you think about it ?? GREAATTTTTTt</P></BODY></HTML> Tue, 29 Mar 2011 15:08:53 GMT 2011-03-29T15:08:53Z Qlikview can query from SSAS data mining structure via DMX https://community.qlik.com/t5/QlikView/Qlikview-can-query-from-SSAS-data-mining-structure-via-DMX/m-p/187401#M51094 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>After creating data mining structure in SSAS , i connect to it with msolap provider and i query the structure (microsoft clustring ) with DMX language. I specify sql before my dmx query :this is the query :</P><P>load *;</P><P><B>SQL</B> select FLATTENED [Id Client]</P><P>from [rfm ].CASES</P><P>where ISINNODE('003');</P><P>Don't forgot FLATTENED CLAUSE , it make the result on Tabular format . What do you think about it ?? GREAATTTTTTt</P></BODY></HTML> Tue, 29 Mar 2011 15:08:53 GMT https://community.qlik.com/t5/QlikView/Qlikview-can-query-from-SSAS-data-mining-structure-via-DMX/m-p/187401#M51094 2011-03-29T15:08:53Z