Multiple fact tables in Data foundation

[Former Member]

Hi,

Can i have multiple fact tables in data foundation of an Analytic view? Is there any pre-condition for doing so.

Rgds

[Ibrahem · Accepted solution]

No you can't. but you can use Calculation view to achieve this.

[Former Member · Accepted solution]

Thanks Ibrahem! so if i have my facts in multiple table i need to create multiple analytic views with corresponding attributes (if any) and use these view in one calculation view. is that right?

rgds

[Former Member · Accepted solution]

Hi rgds,

You can achieve the requirement using just calculation view without the need of analytic view wherein facts from multiple tables are allowed.

Regards,

Shireesha

[muthuram_shanmugavel2 · Accepted solution]

Hi,

If you have multiple fact tables, you can't connect all fact tables in single analytic view.

You have two options.

1. For each Fact Table, Create one Analytic View.

    Connect All Analytic Views in Calculation Views.

2. Connect all Fact Tables in Calculation View itself.

Regards,

Muthuram

[Ibrahem · Accepted solution]

like what Shireesha Kandukoori and Muthuram Shanmugavel said, calculation view is the solution for this case.
this link may help you SAP HANA Academy - Creating a Calculation View - YouTube