Re: MDX queries on kylin cubes.

[Joanna He (Jingke He)]

Try this blog. Let me know if  this solution works for you.
http://dekarlab.de/wp/?p=363

Joanna He


From: Prasanna 
Reply-To: "user@kylin.apache.org" 
Date: Wednesday, 17 January 2018 at 12:36 PM
To: "user@kylin.apache.org" 
Subject: MDX queries on kylin cubes.

Hi all,

  I am using kylin 2.2.0 version. Present I am using only sql type queries on 
kylin cubes like select with aggregation functions. I would like to use MDX 
queries on cubes. If anybody is using please can you guide me, any document is 
available regarding of this.


Thanks,
Prasanna.P

Re: Kylin window function

[Joanna He (Jingke He)]

The tech blog I referred.
http://kylin.apache.org/blog/2016/11/16/window-function/


何京珂
Joanna He


From: "Joanna He (Jingke He)" <jingke...@kyligence.io>
Reply-To: "user@kylin.apache.org" <user@kylin.apache.org>
Date: Tuesday, 25 July 2017 at 9:41 AM
To: "user@kylin.apache.org" <user@kylin.apache.org>
Subject: Kylin window function

Anyone familiar with kylin window function? I am trying to get running total of 
past 12 months sales based on sql below and I am having difficulties getting 
the correct syntax.
The tech blog below mentioned kylin syntax follow calcite but on the calcite 
function page, it does not specify the syntax within the window.



select g.categ_lvl3_name
,c.month_id
,sum(price) as sales
from KYLIN_Sales s
join KYLIN_CAL_DT c
on s.part_dt=c.cal_dt
join KYLIN_CATEGORY_GROUPINGS g
on s.leaf_categ_id=g.leaf_categ_id
and s.LSTG_SITE_ID=g.SITE_ID
group  by g.categ_lvl3_name, month_id
order by g.categ_lvl3_name,month_id


何京珂
Joanna He

Kylin window function

[Joanna He (Jingke He)]

Anyone familiar with kylin window function? I am trying to get running total of 
past 12 months sales based on sql below and I am having difficulties getting 
the correct syntax.
The tech blog below mentioned kylin syntax follow calcite but on the calcite 
function page, it does not specify the syntax within the window.



select g.categ_lvl3_name
,c.month_id
,sum(price) as sales
from KYLIN_Sales s
join KYLIN_CAL_DT c
on s.part_dt=c.cal_dt
join KYLIN_CATEGORY_GROUPINGS g
on s.leaf_categ_id=g.leaf_categ_id
and s.LSTG_SITE_ID=g.SITE_ID
group  by g.categ_lvl3_name, month_id
order by g.categ_lvl3_name,month_id


何京珂
Joanna He