[Mondrian] mondrian and oracle synonym

[Wright, Jeff]

Thanks Luc!

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Luc Boudreau
Sent: Monday, October 24, 2016 1:55 PM
To: Mondrian developer mailing list <mondrian at pentaho.org>
Subject: Re: [Mondrian] mondrian and oracle synonym

Hi Jeff,

I've added some notes to these cases so that we consider this as a platform-wide enhancement. I can't make any promises, but I made sure that Mondrian and others will be considered. BISERVER-7658 is the case to track.

Luc

On Mon, Oct 24, 2016 at 1:43 PM, Wright, Jeff <jeff.s.wright at truvenhealth.com<mailto:jeff.s.wright at truvenhealth.com>> wrote:
We’ve observed that the aggregate matching logic doesn’t support an aggregate table accessed via a synonym. We addressed this locally by making a small change to mondrian.rolap.aggmatcher.JdbcSchema, method loadTables(). It’s also necessary to make sure includeSynonyms=true is part of the Oracle connection string, when column metadata is fetched.

Checking JIRA, I see a couple open defects on the platform, but nothing specific on Mondrian.

http://jira.pentaho.com/browse/BISERVER-7658 “Support Synonyms Across the BA Suite”
http://jira.pentaho.com/browse/BISERVER-6761 “For a db connection, the wizard shows tables but not views” (basically describes the code change we made)

Is there any value in having a JIRA for synonym support more specific to Mondrian?

--jeff


_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20161024/4cfd15e3/attachment.html