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.
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.
Page 1 / 1
Hi Abdul,
I would try it with PQL Operators UNION_ALL or UNION_ALL_TABLE:
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:
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.