Skip to Content
author's profile photo Former Member
Former Member

IDT client tool slows dramatically in business layer

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 12, 2012 at 09:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2014 at 08:51 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.