Skip to Content
avatar image
Former Member

SAP BO Webi Crosstab

I need to build 3 crosstab reports for datewise,weekwise and monthwise calculations. I need below help:

Is there a way that user can select a value of period count from 1 to 70 and that is not available in my Universe and based on that count report will show results.

ex. If user will select 20 as period count for daily report then he will get 20 columns with different date names on the column header and so on.

I am not able to generate integer LOV from 1 to 70 in report. There is no counter i found which can generate this value.

Please help guys.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 27, 2017 at 04:45 PM

    If I am understanding you correctly I think you can do this with an Input Control on your Period Count.

    For example, I created an Combo Box Input Control on Year with a Custom List of Values which I specified as 2003, 2004, 2005, and 2006 even though 2003 is not represented in the data. In your case, you would have to manually enter 1 through 70.

    For some reason I had to apply this to the "Whole Document" rather than "Current Report" on the Dependencies tab. Now when I choose year my crosstab filters to just he years less than or equal to whatever year I chose.

    Does that approach work for you?

    Noel

    Add comment
    10|10000 characters needed characters exceeded