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

EPM Add-in SP17 new feature: Query Options

Hi,

In SP17 a new option has been added to the Report Editor in the EPM Add-in for BPC 10.

It is "Query Options" and has very minimal information in the help guide, except:

16.1.4 Query Options

Applies to:

Planning and Consolidation connections.

In very specific cases and in order to increase time performances, you can use the Query Options

field to pass on information to the server.

I always encourage the idea of performance improvements in BPC, so it would be great if anyone has more information on how it can be used.

Many Thanks,

Nick

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2014 at 01:39 PM

    Any news?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2014 at 09:35 AM

    Hi Nick,

    I am looking at more information on using the 'Query Options' too, as the user guide mentions it could be used to increase time performances.

    The only option that I had used recently is turning on the parallel processing by mentioning 'parallelization=true' in Query Options and it did help a lot to improve data retrieval in large reports when used together with setting the global parameter 'ENABLE_PARALLEL_EXECUTION' to 'X' from TCode SPRO.


    However I am not really sure on what all VALID parameters could be passed through the Query Options other than 'parallelization=true' to the server. ‚Äč

    It would be great to have the information.

    Thanks

    Srujana

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2014 at 09:25 PM

    Hi Nick,

    Take a look at OSS Note

    SAP Note 1854228 - How to enable parallel query for

    reporting

    The note describes how to enable parallel execution of queries for BPC NW and how the Query Option section in EPM is leveraged for this functionality.

    I hope this helps

    Carlos

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2015 at 07:47 AM

    Hi Nick,

    where did you get the documentation of user/help guide for EPM Add-in SP17?

    I couldn't find it @help portal

    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.