Hi James, It would be my pleasure!
2014-04-24 1:53 GMT+02:00 James Taylor <[email protected]>: > 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 >>>> >>> >>> >> >
