Showing results for 
Search instead for 
Did you mean: 

Break up one big report into smaller reports

0 Kudos

Is is possible to break up my SAP Webi BO report which has over 170k rows into smaller individual reports that contain 20k rows?

Active Contributor
0 Kudos

This is a classic case of trying to get a reporting tool to do a ETL tool's (e.g. SSIS) job. I understand you may have your hands tied in this situation, but I do not believe this is possible.

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hey Jay

Can you please try below

=Count([object])In Report

Use the page function available in the WebI under Misc. category.

  • --Insert a Cell and apply function PageInSection()
Or you can also add a column where you display the total count incremental value and then filter based on that
You could also limit size of the result set in Universe parameter

Read this on how you could add ranking and then filter based on that

Let me know if that helped