Break up one big report into smaller reports

[former_member680965]

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

[nscheaffer]

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.

[vinita_kasliwal]

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 thathttps://stackoverflow.com/questions/22467403/set-max-lines-displayed-in-webi-bo-report
You could also limit size of the result set in Universe parameter https://stackoverflow.com/questions/20968696/limit-number-of-result-or-rows-returned-in-bo-using-web...

Read this on how you could add ranking and then filter based on thathttps://stackoverflow.com/questions/60548997/web-intelligence-limit-row-number-in-a-block

Let me know if that helped
RegardsVinita