Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 07 at 12:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08 at 11:53 AM

    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.

    Add comment
    10|10000 characters needed 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)