Skip to Content

sap design studio getting crosstab data in an array

I have BEx query that has top 10 vendors which i show in a cross-tab component.

I need to take these top-10 vendors and get a subtotal for amount-due measure.

I can do this by going to the bex query data source (ds_1) but using get-data the query walks me through every row (100s) in the ds_1 instead of just top-10.

Is there a way to iterate thru the cross-tab rows similar to data iterator SDK component? The client does not want to use any sdk component.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 18, 2017 at 05:36 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2017 at 02:50 PM

    Apologies for a silly question but does your BW query not have a subtotal for the top 10 vendors? Alternatively, you can add a total in your query's initial view in Design Studio.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 20, 2017 at 04:05 PM

    It seems the only answer is using the iterator SDK component.

    Add comment
    10|10000 characters needed characters exceeded

    • Mustafa,

      Thanks for response. As I explained to Agata in my comments that the bex is setup in such a way that the total rows shows total for all the rows in the query and not just for the top-10 that are listed. That's strange. I don't know enough about bex to tell the developer what he can do to fix it. Obviously, he thinks he has it setup correctly.

  • Apr 25, 2017 at 10:20 AM

    Hi Abdussamad,

    BEx Conditions simply hide the display of rows rather than actually filtering the result set. This is why the default total shows the total for the entire result set even though just the Top 10 are displayed. You can override this behaviour directly in Design Studio by setting the Calculate Totals As option of your Amount-Due measure to Sum in the data source Initial View, as shown in the example below:

    This should give you the desired result of totalling only the displayed Top 10.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded