Performance of Universe Using Infosets

[nick_vanlent1]

We are in the process of replacing some of our old crystal reports with universes and web intelligence reports.  The crystal reports pull directly from tables in an SAP database.  We have created some infosets in those databases, and setup a universe on those infosets (in the Information Design Tool).  We are finding that the performance is much worse going through the infosets and universes (about 2 seconds for a crystal report, compared to about 60 seconds for the same report in web intelligence).  Is there something we might be overlooking, or is this just the way it is?

(This was originally posted under SAP Crystal Reports: http://scn.sap.com/message/13824579#13824579)

[Former Member · Accepted solution]

Hi Nick,

BO Performance on InfoSets will be a slighltly lower than CR, the reason being, Crystal uses direct drivers to connect to tables, and in Webi two layers are involved in between with servers.

Also you can try to increase heap size of APS, as IDT uses that to fetch BW tables in UNX.

You cannot use BICS, as BISC to not hit table it hit only Bex Queries.

Thanks,

Avinash

[Former Member]

Hi Nick,

did you already do the comparison from Crystal Reports 2011 direct to InfoSet and Crystal Reports for Enterprise through universe?

Best regards,

Victor

[nick_vanlent1]

Unfortunately, we have not implemented Crystal 2011 or Crystal Enterprise yet, but when we do, we will give those a try to help us narrow down where the issue is.  Thanks for the suggestion.

[Former Member]

Hi Nick,

Use aggregate function in the object definition like sum(tablename.column). This will aggregate at the source, rather then BOE, resulting in performance improvement.

Check this out...

Regards,

Rama

[nick_vanlent1]

We use aggregate functions in the select statements wherever possible.  However, to keep our test as simple as possible, there was no aggregation involved; we are just using a couple tables and looking at the raw data.  Right now, the universe has no measures; all objects are dimensions.

[Former Member]

Hello Nick,

You could prefer using BICS to connect crystal to BW. You would observe significant improvement in the performance.

You could find some useful information here:

http://scn.sap.com/docs/DOC-21797

Thanks,

Madhumitha

[nick_vanlent1]

In this case, we want to try and use universes, but using BICS may be a good step in the troubleshooting process.  Thanks for the suggestion.