HANA Modeling - Usage of Dynamic partition check box in Calculation view

[former_member670836]

Hi Gurus,

Could anyone please explain me the usage of Dynamic partition elements checkbox in Ranknode of calculation view with small example.please.

Best regards, Veena.

[Private_Member_484518]

If you want to partition the data using only the partition by columns that query requests for processing rank nodes, select the Dynamic Partition Elements checkbox.

Note: If you do not select this checkbox, the tool partitions the data with all partition columns that you have added in the Partition By section, even if these columns are not requested in the query.

Regards,

Geetha.

[former_member585319]

If you want to ignore a column defined in the Rank node that isn’t included in the query, you set this option.

Regards,

Sundar

[siva_ram20]

Hi All

Can you please elaborate dynamic partition elements in Hana with example

Best regards,

Siva

[gabrielnaraujo]

Hi Veena,

When you select the Dynamic Partitions Elements checkbox, HANA will ignore any of the specified partition columns that are not included in the query. E.g., if you define an specific column as a partition column, but your query does not include this column, HANA will ignore it as a partition column.

BR,

Gabriel

[former_member670836]

Hi Friends,

Could anyone please answer above question?

regards,

Veena