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

How to use APD partitioning characteristics?

Dear Experts

I tried searching in the forums for APD partitioning characteristics and process data concurrently for Datasource Query.

Please could you provide some useful guides on how to use this feature in BI 7?

Thanks for reading.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2013 at 02:36 PM

    It's easy:

    the partitioning characteristic splits the result of the used APD-query in parts.

    The package size is the number of distinct values of the characteristic in one package.

    For example: 0plant is used as a partitioning characteristic; the query returns 6 plants, and the package size is 2.

    then we would get 3 packages and each package contains 2 plants.

    There is also the possibility to process the packages in parallel.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi

      I am facing one similar issue with one simple APD where I get the query output if I run it in Bex, but if I calculate the intermediate results .. I am getting zero results. I have checked properties of query in APD and noticed that "divide data collection into packages" is checked with 0PLANT and package size = 5,000. I get the intermediate results if I un-check this setting and calculate direct. What am I missing here ? Please advice !

      Please let me know if I should start a new thread. I am really new to SAP.



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.