Search code examples
olapolap-cubefact-tablekylin

Multiple Fact Tables-Kylin

  1. I am aware that Apache Kylin only allows one Fact Table per OLAP cube.

  2. Is there a way to analyse a database with multiple Fact Tables using OLAP?

  3. Alternatively, Can we query from multiple cubes simultaneously in a single job on Apache Kylin?

Regards Anish Dhiman

Solution

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