Regression in 4.5 - PentahoXmlaServlet needs to use datasources in order to easily share cache with Analyzer, etc

Pedro Vale added a comment - 04/Oct/12 7:54 PM This is solved, except for the PRPT which needs changes to the PRD UI. In order to validate, ensure that the latest mondrian trunk snapshot is being used and change the datasources.xml from             <DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo> to             <DataSourceInfo>Provider=mondrian;DataSource=SampleData;UseContentChecksum=true;JdbcConnectionUuid=SampleDataUUID</DataSourceInfo> Now, open Analyzer and in SteelWheels, drag customer to rows and sales to Measures. Make a top 10 on customers on Sales. Using the xmla4js plugin, execute the query: select NON EMPTY {[Measures].[Sales]} ON COLUMNS, NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales]) ON ROWS from [SteelWheelsSales] this is roughly the same query that Analyzer generated. Check the mondrian logs and verify that no sql statements have been executed when the second query is ran. To test XActions, go to Plugin Samples -> CDF -> Documentation -> Component Reference -> Core Components -> XAction Component and open the XAction Component dashboard. After you get the chart on the UI, check the mondrian logs. Again, no sql statements should have been executed to return the results for this query.

Brandon Bruce added a comment - 11/Oct/12 2:42 PM I followed the steps provided and no SQL shows in the pentaho log when the MDX is run from XMLA. The xaction also does not generate SQL in the log