Adhoc reports based on Multiple fact tables
- we have multiple fact tables (Claims Fact, Policy Fact etc.) and their dimensions. In Yellowfin we want to be able to compare the data in these fact tables. In order to do that, all the data has to be present in one view. It works with single fact table but if two fact tables both have a common field like Policy Id or a date key then it’s a reference to the Policy & date dimension, a circular join is created, and this is not supported by Yellowfin.
- Based on above scenario, please suggest how users can create adhoc reports on multiple fact tables in YF to enable self-service capabilities?