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
>>
>
>
