Bex Query requiremnt

[former_member215240]

Hi,

I have Plant, Material, Vendor and total Amount in cube level.

The user want the report output based on same Plant and Material across all vendors. Please see the below screenshot and suggest.

The requirement should be achieved at query level not at transformation level.

Thanks and regards

Santhosh

[KodandaPani_KV · Accepted solution]

Hi,

put the rows panel Plant and Material.

free char panel put the vendor.

total amount should be in column panel.

after executing the query you will see the report only for plant and material.- here will see the total amount for all vendor

then drill down the vendor to rows panel.- it will show vendor wise total amount

now will see the desired report output.

Thanks,

Phani.

[former_member215240 · Accepted solution]

Sorry the required output should be like below. The user needs Vendor in the report Output. Please see below screenshot

Thanks

Santhosh

[KodandaPani_KV · Accepted solution]

Hi,

create the new formula -> put the total amount accross all vendoers or amount -> hit the aggreagtion tab -> use the summation/total /conter for all detail values that are null or zero-> use the reference char -> vendor -> save it.

then check the report in RSRT or BEx analyzer.

let me know have any queries.

Thanks,

Phani.

[former_member215240 · Accepted solution]

Thank you Phani

[Former Member]

Hi,

First Remove the vendor from report, then you will get required output. Include across all the vendors in Report name. Still any issue let me know...

Thanks & Regards,

Srinu.Rapolu