How to config a dimension of Saiku

Friday, July 4, 2014

Recently I am trying to use Saiku http://ift.tt/1ffgPQy. I have a mysql table, which stores statistics for each day. Its schema is shown below:



CREATE TABLE `f_android_active_user_data` (

`event_date` date DEFAULT NULL,

`channel_id` varchar(100) DEFAULT NULL,

`version` varchar(100) DEFAULT NULL,

`active_user_count` int(11) NOT NULL DEFAULT '0'

) ENGINE=MyISAM DEFAULT CHARSET=utf8;


Now I want to config event_date as a dimension, however, I don't see an example of how to use a table's own column as a dimension. It seems there's not much material about Saiku. Could anybody help on this problem?







http://ift.tt/1klqJ1x