Skip to main content
Hello Team,


Ask : I have 4 OLAP Tables with same no. of columns, I need to combine the results of all 4 OLAP tables into in single OLAP Table/Table.

Requesting a help on my ask.

Hi Abdul,

 

I would try it with PQL Operators UNION_ALL or UNION_ALL_TABLE:

UNION_ALL (celonis.com)

 

e.g. Create an OLAP table with 4 columns and within each column you can use a logic like this:

UNION_ALL(TABLE_A.FIELD_1, TABLE_B.FIELD1, TABLE_C.FIELD1, TABLE_D.FIELD1)

 

BR

Dennis


Hi Abdul,

 

I would try it with PQL Operators UNION_ALL or UNION_ALL_TABLE:

UNION_ALL (celonis.com)

 

e.g. Create an OLAP table with 4 columns and within each column you can use a logic like this:

UNION_ALL(TABLE_A.FIELD_1, TABLE_B.FIELD1, TABLE_C.FIELD1, TABLE_D.FIELD1)

 

BR

Dennis

Hello Dennis,

 

Appreciate the quick response, But i need to merge multiple OLAP Components.

Seeking help on the same.

 

Regards,

Abdul A


Reply