Pentaho Analysis - Mondrian

Allow Mondrian to not quote tables and columns when generating SQL

Details

  • Type: Improvement Improvement
  • Status: Resolved Resolved
  • Priority: Severe Severe
  • Resolution: Fixed
  • Affects Version/s: 3.2.1 GA (3.7.0 GA Suite Release)
  • Fix Version/s: 4.0.0 (TBD GA Suite Release)
  • Component/s: None
  • Labels:
    None

Description

Pentaho Metadata and Pentaho Data Integration allow the user to specify whether objects in the database are quoted. Allowing this option in Mondrian will make it easier for folks using Agile BI.

Issue Links

is related to

Improvement - An improvement or enhancement to an existing feature or task. PDI-8912 As an Administrator and Pentaho, I want to install (copy) the Operations Mart with only one and the same Mondrian schema independent of the database

  • Critical - Crashes, loss of data, severe memory leak.
  • Open - The issue is open and ready for the assignee to start work on it.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Julian Hyde added a comment -
Makes sense.

To implement this, we will probably need to add a MondrianMetaData (new interface) as a parameter to the constructor of a Dialect object. Then we can add metadata to the connection that is about the preferences of the user, not about the capabilities of the database. Then Mondrian is run inside the platform, the MondrianMetaData object will be implemented under the covers by Kettle's database metadata object.
Show
Julian Hyde added a comment - Makes sense. To implement this, we will probably need to add a MondrianMetaData (new interface) as a parameter to the constructor of a Dialect object. Then we can add metadata to the connection that is about the preferences of the user, not about the capabilities of the database. Then Mondrian is run inside the platform, the MondrianMetaData object will be implemented under the covers by Kettle's database metadata object.
Hide
Permalink
Julian Hyde added a comment -
I removed "On a per connection or schema basis, ..." prefix to this case's description. It is not easy to change SQL generation preferences per connection. I prefer that they are a property of the schema. You need to set the quoteSql attribute of the Schema XML element.
Show
Julian Hyde added a comment - I removed "On a per connection or schema basis, ..." prefix to this case's description. It is not easy to change SQL generation preferences per connection. I prefer that they are a property of the schema. You need to set the quoteSql attribute of the Schema XML element.
Hide
Permalink
Julian Hyde added a comment -
Fixed on lagunitas branch in https://github.com/pentaho/mondrian/commit/d4c5da437882ff94d44737fbbb7e95f669753c10
Show
Julian Hyde added a comment - Fixed on lagunitas branch in https://github.com/pentaho/mondrian/commit/d4c5da437882ff94d44737fbbb7e95f669753c10

People

  • Assignee:
    Julian Hyde
    Reporter:
    Will Gorman
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: