Pentaho BA Platform
  1. Pentaho BA Platform
  2. BISERVER-7429

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • QA Validation Status:
      Validated by QA

      Description

      PentahoXmlaServlet was rewritten in 4.5, and in the process now has difficulty with sharing caches with Analyzer, XActions, PRPTs, etc. We need to fix the XMLA service to make sure it shares the same cache as the other sub-systems.

        Activity

        Hide
        Pedro Vale added a comment -

        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.

        Show
        Pedro Vale added a comment - 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.
        Hide
        Brandon Bruce added a comment -

        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

        Show
        Brandon Bruce added a comment - 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

          People

          • Assignee:
            Brandon Bruce
            Reporter:
            Will Gorman
          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: