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
    • 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

        Will Gorman created issue -
        Jared Cornelius made changes -
        Field Original Value New Value
        Status Open [ 1 ] Open [ 1 ]
        Priority Unknown [ 7 ] Critical [ 2 ]
        Assignee Triage [ project admin ] Luc Boudreau [ lboudreau ]
        Fix Version/s 4.8.0 GA (4.8.0 GA Suite Release) [ 11451 ]
        Will Gorman made changes -
        Assignee Luc Boudreau [ lboudreau ] Will Gorman [ wgorman ]
        Will Gorman made changes -
        Assignee Will Gorman [ wgorman ] Pedro Alves [ pmalves ]
        Pedro Vale made changes -
        Assignee Pedro Alves [ pmalves ] Pedro Vale [ pamval ]
        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.
        Pedro Vale made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Brandon Bruce made changes -
        Assignee Pedro Vale [ pamval ] Unassigned User [ unassigned ]
        Brandon Bruce made changes -
        Assignee Unassigned User [ unassigned ] Brandon Bruce [ bbruce ]
        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
        Brandon Bruce made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        QA Validation Status Not Yet Validated Validated by QA
        Joe Grajewski made changes -
        Workflow Pentaho Engineering 9.0 Workflow [ 604367 ] Pentaho Bug 1.0 Workflow [ 628517 ]
        Joe Grajewski made changes -
        Workflow Pentaho Bug 1.0 Workflow [ 628517 ] Pentaho Engineering 9.0 Workflow [ 652655 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Open Open
        13d 21m 1 Jared Cornelius 02/Aug/12 2:06 PM
        Open Open Resolved Resolved
        63d 22h 6m 1 Pedro Vale 05/Oct/12 12:13 PM
        Resolved Resolved Closed Closed
        6d 2h 29m 1 Brandon Bruce 11/Oct/12 2:42 PM

          People

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

            Dates

            • Created:
              Updated:
              Resolved: