Skip to Content
0

How to generate dynamic Bex report column's based on user input

Mar 07 at 03:55 AM

43

avatar image
Former Member

Hi All,

Whenever the user enter the fiscal year/period range, then I need to display month wise values as separate columns.

Number of columns should be changed dynamically as per the input fiscal year/period range.

Please find the attachment.

Please help me.

Thank you.

Sam

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

2 Answers

Cornelia Lezoch Mar 07 at 12:17 PM
1

Hi Sammar,

you define just one KF for sales.

put this to the columns of your query and above or below use 0fiscper in your query drilldown.

regards

Cornelia

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 08 at 11:53 AM
0

Hi Cornelia,

Thank you for your reply.

I dropped fiscal year/period, but the result is not coming with moth wise.

Result is displaying in single column.

Could you please suggest how to split the key figure result in to month wise.

Thank you.

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

it would be easier to understand what you do if you posted a picture of your query.

what we are talking about is the most easy way of building a query.

if you define your query like this:

the result will be

just that in your case it´s 0fiscper and sales where I use 0fiscper3 and amount

query-1.jpg (15.4 kB)
query2.jpg (20.4 kB)
0