[Mondrian] Trying to get all datasources from the BA platform, including Mondrian 4.

[Brandon Jackson]

Hi Kurt,

Thanks for the hint.  My pentaho-solutions/system/olap4j.properties file
contains the following:

OLAP4JPropFileFoodmart.name=FoodMart
OLAP4JPropFileFoodmart.className=org.pentaho.platform.plugin.services.connections.PentahoSystemDriver
OLAP4JPropFileFoodmart.connectString=jdbc:mondrian4:DataSource=Foodmart;Catalog=/public/FoodMart/FoodMart.mondrian.xml

Do I need to mirror these settings in the Datasource Manager in PUC and
import the schema?  The datasource is still not being reported to Saiku
when it asks about available schemas for loading.

Brandon

On Tue, Feb 3, 2015 at 7:58 AM, Kurtis Walker <kwalker at pentaho.com> wrote:

>  ​The mondrian 4 catalogs in the BA platform are loaded from the file
> pentaho-solutions/system/olap4j.properties.  Each set of connection
> properties are grouped together by providing a prefix for each value.  You
> need to use jdbc:mondrian4 instead of jdbc:mondrian in the connect string.
> For example:
>
>  foodmart.name=foodmart
> foodmart.connectstring=jdbc:mondrian4:host=localhost;dbname=foodmart;
> catalog=/some/path/to/foodmart.xml;username=auser;password=apassword
>
>  Kurt
>
>
>
>  ------------------------------
> *From:* mondrian-bounces at pentaho.org <mondrian-bounces at pentaho.org> on
> behalf of Brandon Jackson <usbrandon at gmail.com>
> *Sent:* Monday, February 2, 2015 6:35 PM
> *To:* Mondrian developer mailing list
> *Subject:* [Mondrian] Trying to get all datasources from the BA platform,
> including Mondrian 4.
>
>   I've been doing more testing on Mondrian 4, specifically the osgi
> bundle planted in Pentaho 5.3-RC. (I planted it there).  I have had success
> running MDX queries against Mondrian 4.2.0-R via CDA and manually
> specifying the path in the JCR to the FoodMart.mondrian.xml schema file.
>
>  Now I am trying to introduce schemas to Saiku.  My expectation was that
> whatever schema I added to the system through the Datasource Manager would
> be reported to the plugins and leave it up to them to handle it correctly.
>
>  I traced the following snipit of code within the Saiku plugin and only
> the two schema files that ship with the platform are returned.  Steelwheels
> and SampleData.
>
>
> https://github.com/OSBI/saiku/blob/mondrian-4/saiku-bi-platform-plugin-p5/src/main/java/org/saiku/plugin/PentahoDatasourceManager.java#L100
>
>  Should I be using some other class to ask for schema information back?
> My gut feeling is that somehow it is grabbing a CatalogService object from
> Mondrian3 and perhaps since mondrian3 does not know about Mondrian 4 style
> schema, it just ignores them completely.
>
>  If someone knowledgeable could point me in the right direction I will
> pursue upgrading Saiku to support both Mondrian 3 and 4.
>
>  Thanks,
>
>  Brandon
>
>
> _______________________________________________
> Mondrian mailing list
> 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/20150203/9fa8e6ef/attachment.html