Multiple use of text tables

[former_member250148]

Hi,

I have to use same table/attribute view multiple times in HANA calculation view.

What is performancewise best way to implement this.?

e.g. I have 4 material field in fact table. I want to join it with MAKT table.

Do Ineed to use table 4 times? or using once and creating multiple projections etc.

Is there any better way to do this?

Thanks.

Sunil

[Mansoor_Pathan7]

Hi Sunil,

What i understood with your query is MAKT-Material Descp fetching will effect performance issue,

or please give the details for your query.

Regd,

Khan.

[former_member250148]

Hi Mansoor,

Have to use same MAKT table multiple times in my data foundation table join as I have 4 material fields. If I use 4 times table, it will impact the performance. As it is same table, just join field is changing, i am checking for better solution on this.

Thanks.

Sunil