BEx Query Dynamic Columns based on user selections

[#1]

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?

[kohesco]

Hi,

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

grtz

Koen

[faisalfa]

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?

[kohesco]

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

[faisalfa]

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

[kohesco]

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