Dear Community, I'd like to make a OLAP table that have Activity count and Connection count. Is there any way to make this OLAP table? Thank you. Best regards,Takayoshi Ichikawa

Activity count and Connection count in one OLAP table

Dear Community,

I'd like to make a OLAP table that have Activity count and Connection count.

olaptable

Is there any way to make this OLAP table?

Thank you.

Best regards,

Takayoshi Ichikawa

Page 1 / 1

Which data do you have?

Hello Nihat,

Upper-left table in screenshot above is activity data.

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

Hi David,

Thank you.

With the PQL you offer, I was able to get the number I want.

I really appreciate it.

Best regards,

Takayoshi Ichikawa