CODEWITHSUNDEEP
olapolap-cubefact-tablekylin
anishdhiman
anishdhiman

Reputation: 41

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

Upvotes: 1

Views: 1104

Answers (1)

anishdhiman
anishdhiman

Reputation: 41

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.

Upvotes: 3

Related Questions