Thanks All for your feedback.
On Thu, Apr 24, 2014 at 12:08 PM, Juan Rodríguez Hortalá < [email protected]> wrote: > 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 >>>>> >>>> >>>> >>> >> > -- Thanks & Regards, Anil Gupta
