cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BO Webi Crosstab

Former Member
0 Kudos

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.

former_member492038
Participant
0 Kudos

Don’t think this is possible within the report - are you saying you have no ability to change the universe?

Accepted Solutions (0)

Answers (1)

Answers (1)

nscheaffer
Active Contributor
0 Kudos

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