IDT client tool slows dramatically in business layer

[Former Member]

IDT performance is agonizingly slow when working with the business layer.

It's fine when i build connections and then the data foundation.

virus software disabled.

when i create a business layer (unx) it takes 20 secs just to change

the description of a measure.

The business layer is only two tables from two sources - 1 sql table on

bi4 box and sap cube with 10 fields.

Steps for Reconstruction

1. build 2 relational connections in ITD (sql, sap bw cube)   
2. build data foundation for 2 connections   
3. build business layer. business layer then is slow. very slow.

I realize there is network traffic...but all of the other client tools are fine...is there anything else I can do?

[Former Member]

Pedro - I never got this resolved.  We have a 3rd party hosting provided and they installed IDT on our dev box.  I remote desktop there and it works fine.  We tried everything and were basically told 'good luck' by SAP.  I provided wire shark logs for traffic ...b/c one was slow, one was not and nothing stuck out to anyone that was considered an expert in that area.  Something about CORBA kept popping up but eventually I had to get some actual work done so I settled for the remote desktop option.  This is not idea at all though.

[Henry_Banks]

Hi,

Is this a Multisource-enabled BW-SQL relational foundation?

If so, then this workflow is using the Data Federator APS server on the BIPlatform: Although you are using a Client Tool (IDT) the data access processing is actually on the Server. So it's effectively a 3-tier setup: IDT -> DF APS -> BW, with all the latency in-between.

Have you split out and up sized your DF service?  (as per doc here: http://scn.sap.com/docs/DOC-31711 and Note 1694041 - BI 4.0 Consulting:- How to size the Adaptive Processing Server )

So you might want to try allocating 2g or 3g of RAM to the dedicated DF APS. This will help increase your 'bandwidth' when actually crunching data.

You might want to start monitoring where 'time is spent' when doing your transforms . IDT (local task mgr)? Data Federator APS on BIPlatform? BW worksprocess in SM50?

You can also use the Data Federator Admin tool to help monitor and optimize DF processing (tune sql exec plan etc) .

Please be aware that IF your BOE user is part of a complex security model, and IF your SAP usr has a number of restrictive authorizations, then security checks increase, and response time will be slower. (i.e. Administrator and SAP_ALL may be faster)

Also, if your BIPlatform has all components (web tier (Tomcat), processing tier (WPS/APS), security tier (CMS)) installed on a monolythic box (i.e. not distributed accross a cluster), and not sized according to the info above, then this could be part of the problem.

Best of luck!

Regards,

Henry

[Former Member]

henry - I'm going to follow some of your steps.  First, I wanted to mentioned something...we have a 3rd party host.  I got them to import what i had built and the IDT is extremely fast.  I would think it would be a network issue, but all of the ports seem to be open.  Does sap have some IDT application diagram that shows all ports it uses?

thanks for the info.

[Former Member]

I realize this thread is old, but it never got a definitive answer and I am having a related issue. My universe has a multisource data foundation on just one Oracle 11g source and the business layer is also very slow for me. It can take up to five seconds from the moment I left-click an object to the moment its code and properties show up on the right side of the screen. A single-source universe on the same Oracle source performs these operations far more quickly -- not instantly like the old Universe Design Tool, but still much faster than with a multisource data foundation.

Both the BO and Oracle servers are in-house (although physically far from me), not on a third-party host.

Does anyone know why these operations are so slow? I can understand there being latency when I validate the code, or when I do a Show Values on a dimension, but just clicking back and forth between objects? If there is a need to fetch something from the server, why doesn't IDT cache it the first time instead of experiencing a delay each time I click on the same objects again?

Using BO 4.0 SP6 Patch 2.