cancel
Showing results for 
Search instead for 
Did you mean: 

Is there any restriction to number of table can be joined in attribute view ?.

pavneet_rana
Active Participant
0 Kudos

Hi to all,

How many table we can joined in attribute view?.

Is there any max number defined?.

Regards

Pavneet Rana

Accepted Solutions (1)

Accepted Solutions (1)

rindia
Active Contributor
0 Kudos

Hi Pavneet,

We can find the limit by simply executing query

SELECT * FROM M_SYSTEM_LIMITS;

It is 255 for joins(HANA SPS6 rev 63)
The value differs based on HANA version you are using.

With this query use also find other limits too.

Regards

Raj

rindia
Active Contributor
0 Kudos

One point to add:

After creating the attribute view, we join the attribute views to the data foundation of Analytic view,and all the joins together in a statement should not exceed 255.

Regards

Raj


Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Pavneet,

As Raj explained, you will have a view called M_SYSTEM_LIMITS under "SYS" schema in HANA system.

Check the data preview of this view to see the complete information about all the system limitations.

Regards,

Venkat