How to increase performance of an IDT Universe in BO 4.1

[Former Member]

Hi All,

I am working on enhancing performance of an IDT universe designed on top of BW info sets.

If I pull the same objects and conditions in BW system, it takes hardly 1 min to give me results but if I pull the same objects in Universe query in IDT or if I create Webi report using those objects in BI Launchpad then it takes around 10 min.

Data is coming from R3 system in BW infosets and in R3 also, processing is very fast and it takes just 1 min or less to give me the results.

But in IDT query or Webi report is taking too much time. Any idea how to increase performance of this Universe.

Thanks.

[Henry_Banks]

Hi,

You might find this discussion useful http://scn.sap.com/thread/3342777

also, I was thinking - why not expose the infoset (via a transient provider) to a bex query, by using the in-built BW-mart inside ERP? (rather than replicating it into BW too),

Then you could use BICS connection ( from BI4.x) as your access type. I expect this will prove to be faster

regards,

H