cancel
Showing results for 
Search instead for 
Did you mean: 

Performance improvement for Infoset

Former Member
0 Kudos

Hello,

For Multiprovider, during reporting, if we require, we improve the performance by creating the Aggregates on Infocube.

Can anyone tell us the steps to take care for improving the performance of the Infoset?

There are 4 cubes that are joined using infoset and the report is built on it.

Advise

Regards

Hoa

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182470
Active Contributor
0 Kudos

Hi,

Cubes with aggregates and secondary indexes(performance tab) will always gives best performances in any platform.

Important points to consider while creating and reporting on Infoset

1) Try to reduce as many joins as we can

2) Uncheck the fields in the infoset definition which we are not going to use in the query

3) You may use advanced feature like Filter condition on joins if your requirement supports

4) Keep the value as X for read mode in RSDIPROP t-code for your Infoset

Regards,

Suman

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi Suman,

Thanks for reply,

If we create aggregates in infocube will it improve performance?

former_member182470
Active Contributor
0 Kudos

Yeah, you can try with aggregates as well as my suggestions too.

Former Member
0 Kudos

Hi Hoa,

Like MP infoset also doesn't holds any data. So I think if we create the aggregates Infocubes which are under Infoset then works in same way.

Friends please correct if I am at wrong.

Thanks,

Ram