Problem while Creating HANA Restricted Columns

[former_member462348]

Hi Experts,

Am facing issues while creating the Restricted Columns in the Top Aggregation node.

restr.jpg

though there are many columns in the Semantics node, But still I could not find any columns in the drop down available in Restricted Columns.

It will be good if someone can let me know what will be the issue here.

Thanks
Rufus Samuel

[pfefferf]

Please can you share a little bit more information about your model, like does your model have measures, ...?

[former_member462348]

Hi Florian,

Yes my Data Model has one Counter created in Aggregation node which acts as a Measure. attached the image for your reference.

Thanks
Rufus

img.jpg

[former_member607745 · Accepted solution]

Hi Rufus,

Counters or calculated columns created at top aggregation node have aggregation type : none or formula.

To consume a column of measure type in restricted column ,a measure should have an aggregation type : Sum/max/min/count.. etc