Multiple Fact Tables-Kylin

Question

I am aware that Apache Kylin only allows one Fact Table per OLAP cube.
Is there a way to analyse a database with multiple Fact Tables using OLAP?
Alternatively, Can we query from multiple cubes simultaneously in a single job on Apache Kylin?

Regards Anish Dhiman

score 3 · Accepted Answer · answered Feb 12 '16 at 11:57

3

Problem Solved. I created multiple cubes, each containing a single fact table in Apache Kylin. While querying, I accessed each cube in a sub-query. As a result of this, I was then able to query collectively from all cubes.

answered Feb 12 '16 at 11:57

anishdhiman

41
9

Did you join across multiple fact tables at run time? can you give example of your sub-query? – nir Jun 26 '17 at 18:54
I am also able to run sub-query but can't able to run join query over it – Rahul Jul 04 '19 at 06:36

Multiple Fact Tables-Kylin

1 Answers1