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

Report performance while creating report on BEx

All all!

I am creating a report on BOE 4.0 on top of BEx connection as a source. I have developed reports on top of universe in the past and i know that if we keep calculations on reporting end it hampers the report performance. Is this the same case with BEx? if we are following the best practices is it ok to say that we should keep all heavy calculations/ aggregation on BEx or backend for better report performance.

Can you guys please provide your opinion based on your experiance and knowledge. Any feedbacks will help! Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 08:46 AM

    Hi,

    As per my experience, I would say it is better to have your calculations at Bex or backend side for better performance.

    Regds,

    Vidula

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 18, 2012 at 10:45 AM

    Hi,

    Definitely best-practice to delegate a maximum of CKF to the Cube where possilble, put RKF in the BEx query, and Filters too.

    also, add Default Values to your Variables (this will speed up generation of the bics transient universe)

    also, since Patch2.10, we are seeing some significant performance improvements reducing 'document initialization' and 'time to prompts' by up to 50% (step such as these often took 1.5 minutes, even on sized systems)

    Also, make sure you have BW corrections like this implemented: 1593802 Performance optimization when loading query views

    In the BusinessObjects landscape - especially with BI 4.0 - it's all about Sizing and Tuning . Here is your bible the 'sizing companion' guide : http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000738725&_OBJECT=011000358700000307202011E

    Pay particular attention to BICSChunkSize registry settings

    Also, the -Xmx JVM Heap Size for the Adaptive Processing Server that is running the DSL_Bridge service.

    Regards,

    H

    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.