Hi,   In the SAS Visual analytics designer 7.4, I would like to create an interactive reports with interactions and filters but the data are wihtin multiple facts tables.   So, I would like to know what is the best way to create a VA report using these type of data, do i need to join all the tables ? How can i create rate over year if the population per year is in an other database and incidence cases are in another database ?   For example, I have cases (50 000 cases per year) that have calls associated with and for each case or calls I can have interventions, product intoxication, analyzes made by a doctor and so on. So, if i join all the tables I will have a table with high volume  over years (millions of lines). Here a small example of the data.   For an example of reports, I would need to set promps for date, sexe, age, products and present these kind of information :   Trend over-time for cases (number and rates) Trend over-time for calls Cross table of different variables for cases Cross table of different variables for calls Top 10 Intoxication product Top 10 Analyzes Top 10 Interventions   Regards,   Cases :   ID_Case Date Sexe Age 1 2019-01-01 Men 18 2 2019-01-02 Women 24 3 2019-01-03 Men 32   Calls for each case :   ID_Case ID_Call Date 1 1 2019-01-01 1 2 2019-01-02 2 3 2019-01-02 3 4 2019-01-03 3 5 2019-01-13   Intoxication product for each case :   ID_Case ID_Product 1 1 1 2 2 1 3 4 3 2 3 6   Intervention for each call :   ID_Call ID_Intervention 1 1 1 2 3 1 5 6   Analyze for each call :   ID_Call ID_Analyse 2 1 2 2 4 1 4 5   ... View more