search

pentaho / mondrian

Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time.
http://mondrian.pentaho.com/
Eclipse Public License 1.0
1.12k stars 713 forks source link

Retrieving FOREIGN TABLEs from PostgreSQL #478

Open gabitoju opened 9 years ago

gabitoju commented 9 years ago

I'm using Saiuku with Mondrian 4 and CitusDB's cstore_fdw for storing the fact tables.

Mondrian can't retrive the FTs from Postgres and that's something very similar to this issue #354.

cstore_fdw it's a great choice for a BI solution and Mondrian should support that.

The change should be trivial, maybe somehing like this:

src/main/mondrian/gui/JdbcMetaData.java null, dbs.name, null, new String[]{"TABLE", "VIEW", "MATERIALIZED VIEW", "FOREIGN TABLE"});

src/main/mondrian/rolap/aggmatcher/JdbcSchema.java String[] tableTypes = { "TABLE", "VIEW", "MATERIALIZED VIEW" , "FOREIGN TABLE"};

Thanks!

jazzido commented 8 years ago

+1

buggtb commented 8 years ago

Someone pointed me to this commit. We run a fork currently, and I go thtem to test the change and it seems to work fine. So the next Saiku release due tomorrow (probably) will include the updated mondrian.