Skip to Content
0
Former Member
Jul 04, 2016 at 09:42 AM

SAP Business Intelligence Query Builder

286 Views

Hi, I am running the below query to get the objects from Favorites Folder. I have almost 20000 reports in Favorites.

SELECT TOP static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS WHERE DESCENDENTS("SI_NAME='Folder Hierarchy'", "(SI_KIND='FavoritesFolder')")

So I want to split up the query in 2 parts. First part will extract first 10000 results and the other part will extract another 10000 results.I have to divide the query otherewise query is getting hanged.

First set of results I can get by adding Top 10000 after Select clause.

But how I will get the next 10000 results ? I tried with Bottom 10000 but no Luck.