Activity count and Connection count in one OLAP table

Hi @takayoshi.ichik ,

I assume you already have the OLAP table with the connections using SOURCE/TARGET.

You should be able to add the "Source Activity Count" using a PU_COUNT together with DOMAIN_TABLE. It would look like this:

PU_COUNT(DOMAIN_TABLE(SOURCE("Activities"."Activity")), SOURCE("Activities"."Activity"))

The "Target Activity Count" can be calculated accordingly:

PU_COUNT(DOMAIN_TABLE(TARGET("Activities"."Activity")), TARGET("Activities"."Activity"))

Hope this helps!

Best,

David