Skip to Content
0

sap design studio getting crosstab data in an array

Apr 18, 2017 at 04:33 PM

176

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Tammy Powlas
Apr 18, 2017 at 05:36 PM
0
Show 1 Share
10 |10000 characters needed characters left characters exceeded


Thanks, Tammy, but this does not give me what I need.

0
Agata L. Apr 19, 2017 at 02:50 PM
0

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
that's the way it should be but the bw developer has it setup in such a way that the total is for all the rows in the query and not just for the top 10 even though in the crosstab component shows only 10 rows (plus the total). I am not a bw developer. is there a way he can limit to have the query return only the 10 rows I need?
0

The BW developer should be able to change the total to display total for the top 10, instead of all the rows. I am not sure if you can change it in Design Studio directly. You could run the query in SAP Analysis, change it there and use this as your datasource, but I don't think this will be a live connection anymore.

0

This is what I need. Can you please tell me what should be done in the query to change that? Or is the change made at the datasource level like infoprovider?

0
abdul peera Apr 20, 2017 at 04:05 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Is there a reason why you don't activate the sub-total in the data source initial view as Agata has suggested?

0

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.

0
Mustafa Bensan Apr 25, 2017 at 10:20 AM
0

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.


bexconditionsum.png (339.4 kB)
Share
10 |10000 characters needed characters left characters exceeded