BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

5000 rows


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Fri Oct 02, 1998 4:59 am 
Post subject: 5000 rows



Hello, listers!

I'd love to hear from those of you, that had to do something to work around the 5000 rows limitation
in BO. Any solutions, ideas?
I have got a report that _will_ return more than 5000 different rows in a short time. And it will grow...
I have no idea how to deal with it, so far...

Ryszard Mikke

PS. Pointings to manuals are, of course welcome :-)


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Fri Oct 02, 1998 5:37 am 
Post subject: 5000 rows



Open the Univers in Designer. Select Parameters from the file menu. On the Controls Tab change the max number of rows.

hans
>I'd love to hear from those of you, that had to do something to work around
>the 5000 rows limitation
>in BO. Any solutions, ideas?



_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Fri Oct 02, 1998 5:46 am 
Post subject: 5000 rows



On Friday 2 October 1998 Ryszard Mikke wrote:

>I'd love to hear from those of you, that had to do something to work
around the 5000 rows limitation in BO.
>Any solutions, ideas?
>I have got a report that _will_ return more than 5000 different rows in a
short time. And it will grow...
>I have no idea how to deal with it, so far...

You can change the default limit for the universe under File / Parameters / Controls tab using the Designer.
Another method, which is very handy, is to copy the SQL code generated by the query and run it using Free-Hand SQL.

Lorenzo Escalante, Jr.
BHP IT Perth, Western Australia
escalante.lorenzo.lj@bhp.com.au


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Mon Oct 05, 1998 4:46 am 
Post subject: 5000 rows



Hi!

>From:
>hans.kingma@UNISOURCE-UCS.COM[SMTP:hans.kingma@UNISOURCE-UCS.COM]

>Open the Univers in Designer. Select Parameters from the file menu. On the Controls Tab change the max number of rows.

Umm... Hmm...
First of all: Thanks, that works!
But then, what is the meaning of 'Maximum Number of Rows Fetched' option in Database tab
of Tools->Options in Designer, which has a fixed limi of 10k (in 4.1.2a, which I use now,
in version 4.1.1 that I have been using two weeks ago it was 5k - hence the subject :-) ).

Curious,
Ryszard Mikke


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Mon Oct 05, 1998 7:22 am 
Post subject: 5000 rows



Mikke Ryszard wrote:

>But then, what is the meaning of 'Maximum Number of Rows Fetched'
option in
>Database tab
>of Tools->Options in Designer, which has a fixed limi of 10k (in
4.1.2a,
>which I use now

That's the maximum number of rows fetched when you want to see what records are present in a table or what values a column has (right mouse click, values) on the table or on a column in the structure window in designer (I use the default of 100 rows, that's usually indication enough).

Succes,
Marianne Wagt
IDETA, the Netherlands


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0376 seconds using 17 queries. (SQL 0.0113 Parse 0.0009 Other 0.0254)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo