Skip to Content
0

BEx Query Dynamic Columns based on user selections

Oct 24, 2017 at 06:53 AM

68

avatar image

Hi,

I've a reporting requirement in BEx.

The user wants to create a selection screen based on billing.

The following is the output screens

Based on the different billing types the user wants to display dynamic columns in its place for different billing types. For eg: If user selects "Cancelled bills" it should display column Reversal date and other columns which match its criteria for cancellation. Can we achieve this in BEx?

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

1 Answer

Koen Hesters Oct 24, 2017 at 09:24 AM
0

Hi,

the easiest solution is to create different views upon one query and let the user use their view

grtz

Koen

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

Hi Koen,

Thank you for your prompt reply.

Should I create separate queries for each billing type and create a single view on them?

Can you please provide steps as to how we create query views in BEx?

0

Hi,

you create one query with everything in it, all chars and all keyfigures.

per view (id est per billing type) you create one with the chars and keyfigures corresponding to the billing type.

check out doc:

https://help.sap.com/saphelp_nw73/helpdata/en/46/0294bc82f37041e10000000a155369/frameset.htm

0

Unfortunately, we don't have BEx Web Analyzer in our BW environment to use query views. Could there be a work around for this?

0

when you run the query in bex analyzer (excel) you can save as query view

0