Pentaho Reporting and Pentaho Report Designer

As a reporting user, I want the ability to declare additional mondrian connection properties (like 'jdbcconnectionuid') on a mondrian connection

Details

  • QA Validation Status:
    Validated by QA

Description

When run in standalone == false (inside BI server), PRD disregards the catalog properties that are present in datasources.xml. It builds a new connection string with a small subset of those properties (in PentahoCubeProvider).

This should be changed so that all properties in the catalog string are used to build the Mondrian Connection. This is relevant so that PRD can use the jdbcconnectionuid property newly introduced to Mondrian and, subsequently, share the Mondrian cache with the other platform components.

We propose that the PentahoCubeProvider class/mechanism should be replaced with a PentahoCatalogStringProvider that will create a catalog string with all the properties in datasources.xml

Issue Links

relates to

New Feature - A new feature of the product, which has yet to be developed. PRD-4140 As a reporting user, I want to address server side mondrian connections via a logical name inside PRPT files

  • Severe - Major loss of function.
  • Open - The issue is open and ready for the assignee to start work on it.

Activity

Ascending order - Click to sort in descending order
Jared Cornelius made changes -
Field Original Value New Value
Issue Type Bug [ 1 ] New Feature [ 2 ]
Assignee Triage [ project admin ] Unassigned User [ unassigned ]
Fix Version/s 4.0.0 GA (5.0 GA Suite Release) [ 10723 ]
Priority Unknown [ 7 ] Severe [ 3 ]
Hide
Permalink
Kurtis Cruzada added a comment -
This was addressed in 3.9.1.
Show
Kurtis Cruzada added a comment - This was addressed in 3.9.1.
Kurtis Cruzada made changes -
Status Open [ 1 ] Open [ 1 ]
Assignee Unassigned User [ unassigned ] Kurtis Cruzada [ kcruzada ]
Fix Version/s 3.9.1 GA (4.8.0 GA Suite Release) [ 11455 ]
Fix Version/s 4.0.0 GA (5.0 GA Suite Release) [ 10723 ]
David Kincade made changes -
Status Open [ 1 ] Closed [ 6 ]
Resolution Fixed [ 1 ]
Hide
Permalink
Pedro Alves added a comment -
Actually, this issue should be reopened. It still disregards connection properties, what was done in PRD was allow the user to explicitly pass properties. The user still has to replicate the properties that already exist in olap/datasources.xml
Show
Pedro Alves added a comment - Actually, this issue should be reopened. It still disregards connection properties, what was done in PRD was allow the user to explicitly pass properties. The user still has to replicate the properties that already exist in olap/datasources.xml
Hide
Permalink
Will Gorman added a comment -
Reopening based on Pedro's comments, Brandon, can you double check that this capability wasn't implemented?

Thanks,

Will
Show
Will Gorman added a comment - Reopening based on Pedro's comments, Brandon, can you double check that this capability wasn't implemented? Thanks, Will
Will Gorman made changes -
Resolution Fixed [ 1 ]
Status Closed [ 6 ] Reopened [ 4 ]
Assignee Kurtis Cruzada [ kcruzada ] Brandon Bruce [ bbruce ]
Hide
Permalink
Thomas Morgner added a comment -
PRD does not access 'datasources.xml' as this is a pure server side file and it is not exposed to remote clients. If you are ONLY talking about "reports run in the server" then please change the title of the case. PRD means: Running outside of the server inside the product called "Pentaho Report Designer".
Show
Thomas Morgner added a comment - PRD does not access 'datasources.xml' as this is a pure server side file and it is not exposed to remote clients. If you are ONLY talking about "reports run in the server" then please change the title of the case. PRD means: Running outside of the server inside the product called "Pentaho Report Designer".
Hide
Permalink
Pedro Alves added a comment -
Thomas, you are absolutely correct. I always meant the reporting plugin , prd was an abuse of language
Show
Pedro Alves added a comment - Thomas, you are absolutely correct. I always meant the reporting plugin , prd was an abuse of language
Thomas Morgner made changes -
Summary PRD disregards connection properties in datasources.xml Reporting engine running in the server disregards connection properties in datasources.xml
Will Gorman made changes -
Link This issue is related to ESR-2392 [ ESR-2392 ]
Thomas Morgner made changes -
Link This issue relates to PRD-4140 [ PRD-4140 ]
Hide
Permalink
Thomas Morgner added a comment -
Changed this case once more to reflect the work that we actually did based on the original description. This way, the commit log and the change-log for the PRD-3.9.1 release are accurately reflecting the features we added.
I created a follow-up case PRD-4140 to solve the implicit problem stated by this case: That we want to reuse existing connections on the server instead of having manual connection definitions inside a PRPT file.
Show
Thomas Morgner added a comment - Changed this case once more to reflect the work that we actually did based on the original description. This way, the commit log and the change-log for the PRD-3 .9.1 release are accurately reflecting the features we added. I created a follow-up case PRD-4140 to solve the implicit problem stated by this case: That we want to reuse existing connections on the server instead of having manual connection definitions inside a PRPT file.
Thomas Morgner made changes -
Summary Reporting engine running in the server disregards connection properties in datasources.xml As a reporting user, I want the ability to declare additional mondrian connection properties (like 'jdbcconnectionuid') on a mondrian connection
Component/s Data Source [ 10128 ]
Thomas Morgner made changes -
Assignee Brandon Bruce [ bbruce ] Thomas Morgner [ tmorgner ]
Thomas Morgner made changes -
Status Reopened [ 4 ] In Progress [ 3 ]
Hide
Permalink
Thomas Morgner added a comment -
No checkin, just walking through the work-flow.
Show
Thomas Morgner added a comment - No checkin, just walking through the work-flow.
Thomas Morgner made changes -
Status In Progress [ 3 ] Resolved [ 5 ]
Assignee Thomas Morgner [ tmorgner ] Kurtis Cruzada [ kcruzada ]
Kurtis Cruzada made changes -
Status Resolved [ 5 ] Closed [ 6 ]
QA Validation Status Not Yet Validated Validated by QA
Resolution Fixed [ 1 ]
Transition Time In Source Status Execution Times Last Executer Last Execution Date
Open Open Open Open
27d 23h 44m 1 Kurtis Cruzada 24/Oct/12 11:39 AM
Open Open Closed Closed
11m 34s 1 David Kincade 24/Oct/12 11:51 AM
Closed Closed Reopened Reopened
51d 3h 24m 1 Will Gorman 14/Dec/12 2:15 PM
Reopened Reopened In Progress In Progress
2d 20h 26m 1 Thomas Morgner 17/Dec/12 10:42 AM
In Progress In Progress Resolved Resolved
25s 1 Thomas Morgner 17/Dec/12 10:42 AM
Resolved Resolved Closed Closed
99d 1h 41m 1 Kurtis Cruzada 26/Mar/13 1:23 PM

People

  • Assignee:
    Kurtis Cruzada
    Reporter:
    Pedro Vale
Vote (1)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: