This is fantastic, Juan! Thanks so much for posting this. Would be fantastic if you did a guest blog on this at https://blogs.apache.org/phoenix.
Regards, James On Wed, Apr 23, 2014 at 11:25 AM, Juan Rodríguez Hortalá < [email protected]> wrote: > > > Hi, I've been able to use Phoenix with Saiku http://meteorite.bi/saikuacting > as a Mondrian front-end, using Phoenix 3.0.0 and HBase 0.94.6 > CDH4.4.0. I use the following configuration for the Saiku datasource ( > http://docs.analytical-labs.com/saiku/documentation/configuration/2013/08/15/datasources.html): > > > type=OLAP > name=phoenix > driver=mondrian.olap4j.MondrianOlap4jDriver > > location=jdbc:mondrian:Jdbc=jdbc:phoenix:localhost;Catalog=res:phoenix/Phoenix.xml;JdbcDrivers=org.apache.phoenix.jdbc.PhoenixDriver > > And for example for a simple HBase table like > > create 'phoenix', 'fact', 'customer', 'day' > > which Phoenix table is: > > CREATE TABLE "phoenix" ("key" VARCHAR not null primary key, "fact"."count" > INTEGER, "customer"."name" VARCHAR, "day"."month" INTEGER); > > the cube definition in Phoenix.xml can be as follows: > > <Cube name="Customers"> > <Table name="phoenix"/> > <Dimension name="Customer"> > <Hierarchy hasAll="true" allMemberName="All Types"> > <Level name="Name" column="customer.name" uniqueMembers="true"/> > </Hierarchy> > </Dimension> > <Dimension name="Day"> > <Hierarchy hasAll="true" allMemberName="All Assignees"> > <Level name="Month" column="day.month" uniqueMembers="true"/> > </Hierarchy> > </Dimension> > <Measure name="Count" column="count" aggregator="sum" > formatString="Standard"/> > </Cube> > > Greetings, > > Juan Rodríguez Hortalá > > > > 2014-04-23 19:28 GMT+02:00 Vladimir Rodionov <[email protected]>: > > There have been attempts to "marry" Mondrian OLAP server and Phoenix. I >> think it is still work in progress. With Mondrian OLAP server you can use >> any BI tool that support MDX: Pentaho, Jaspersoft. >> >> >> On Tue, Apr 22, 2014 at 11:51 PM, anil gupta <[email protected]>wrote: >> >>> Hi All, >>> >>> We are looking into the possibility of using Phoenix with Tableau. So, i >>> would like to get feedback from users who tried using Tableau with Phoenix. >>> I have never used tableau so i just know that its a Data visualization >>> application. >>> I saw this post and as per this it looks like Phoenix cannot be used >>> with Tableau: >>> https://groups.google.com/forum/#!topic/phoenix-hbase-user/Oz9Du8tQuCE >>> >>> What other data visualization products focused on business intelligence >>> are being used with Phoenix? >>> >>> -- >>> Thanks & Regards, >>> Anil Gupta >>> >> >> >
