Pentaho BI Server

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

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 4.8.0 GA (4.8.0 GA Suite Release)
  • 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

Ascending order - Click to sort in descending order
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
Permalink
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
Permalink
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
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
Vote (1)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: