Calculated dimension consumes long time to load the data.

[deep2021]

Hi All,

I am using the below calculated dimension in a chart to show the data.

if(len(CP_Key_P)>0,protocol)

But there are too may records and it is consuming a long time to display the data.

Can you please suggest how to write optimized condition for this.

Note: all the above fields are coming from different tables and if I can join the tables table size is increasing.

Thanks

[BrunPierre]

Hi, maybe changing to a set analysis expression.

Dimension: protocol

Expression: Count({$<CP_Key_P={"*"}>} DISTINCT CP_Key_P)

On the other hand, filtering in the script uses the least amount of memory and ensures high performance.

To remove null values in the model, you can add a where clause to the load statement

Where Len(Trim(CP_Key_P)) > 0 ;