I am a General Supervisor. I have modified a universe within designer and changed the max number of rows fetched in the parameters settings from 20,000 rows to 100,000 rows. I successfully export the universe. When I build a report in BO, it maxes out at 20,000 rows. When I try to change the partial results options from within the query panel, it tells me that it cannot exceed 20,000 rows. When I go back to designer and view the universe parameters again, it has reverted back to 20,000! I then close everything and delete the universe and re-import it. However, the same thing occurs. When I log into BO on my machine as another user, the max rows is 100,000 like it should be. I am perplexed!! The tech support we have has been no help in explaining this. I have checked every possible thing I can think of but my user name seems to be the magic key…but why and how do I fix! Please help, this is holding me up from a deadline.
I am a General Supervisor. I have modified a universe within designer and changed the max number of rows fetched in the parameters settings from 20,000 rows to 100,000 rows. I successfully export the universe. When I build a report in BO, it maxes out at 20,000 rows…
I believe in the Supervisor module, you can limit the number of rows by user for each universe. Perhaps this is your problem. Go into Supervisor, select the desired user, choose the desired universe, and then look at the Control tab under Resource Properties. Good luck.
Thanks, but I looked in Supervisor too. No limits are set on me.
From: Bill Wolff[SMTP:William.Wolff@HEALTHNET.COM]
Sent: Thursday, November 05, 1998 9:32 AM
I am a General Supervisor. I have modified a universe within designer and changed the max number of rows fetched in the parameters settings from 20,000 rows to 100,000 rows. I successfully export the universe. When I build a report in BO, it maxes out at 20,000 rows…
I believe in the Supervisor module, you can limit the number of rows by user for each universe. Perhaps this is your problem. Go into Supervisor,
select the desired user, choose the desired universe, and then look at the Control tab under Resource Properties. Good luck.
Check the universe parameters in Supervisor for the userid you are logging in with, with regard to the universe in question. BO allows different limits to be set this way, which override those limits set in Designer.
Unfortunately, I checked that too. It is set to 100,000 rows.
From: Jason Beard[SMTP:Jason_Beard@SEAGRAM.COM]
Sent: Thursday, November 05, 1998 9:41 AM
Check the universe parameters in Supervisor for the userid you are logging in
with, with regard to the universe in question. BO allows different limits to be
set this way, which override those limits set in Designer.
Jason Beard
AGD Computer Services
partial results options from within the query panel, it tells me that it cannot exceed 20,000 rows. When I go back to designer and view the universe
parameters again, it has reverted back to 20,000! I then close everything and delete the universe and re-import it. However, the same thing occurs. When I log into BO on my machine as another user, the max rows is 100,000 like it should be. I am perplexed!! The tech support we have has been no help in explaining this. I have checked every possible thing I can think of
but my user name seems to be the magic key…but why and how do I fix! Please help, this is holding me up from a deadline.
Your issue is simply because you are a GENERAL SUPERVISOR. As a GENERAL SUPERVISOR, not many of the limitations are set for you. Just as you can OPEN any UNIVERSE or DOCUMENT without being specifically Granted the access, you can query for the DEFAULT number of rows.
Just make sure that a TEST user sees the limit on the number of rows and you are set. Also… check the version of Business Objects you are on. You will typically want to be on the latest version. I believe the was a change from 4.0.x to 4.1 or from 4.1 to 4.1.x that changed how the limits worked for users. It’s all in the README files.
Bottom line. Don’t worry about the GS limits as they appear. The GS is All-mighty and it might be confusing you on this issue.
Thanks Robert, I did end up creating a new user for myself as a last resort. However, if the default parameters for the universe is 100,000 rows why would I (regardless of being a general supervisor) be seeing less than that? Unless there is another default number I am not aware of. I am on version 4.1.3.
From: Robert[SMTP:digpen@EARTHLINK.NET]
Sent: Thursday, November 05, 1998 12:43 PM
Michele,
Your issue is simply because you are a GENERAL SUPERVISOR. As a GENERAL SUPERVISOR, not many of the limitations are set for you. Just as you can OPEN any UNIVERSE or DOCUMENT without being specifically Granted the access,
you can query for the DEFAULT number of rows.
Just make sure that a TEST user sees the limit on the number of rows and you
are set. Also… check the version of Business Objects you are on. You will typically want to be on the latest version. I believe the was a change
from 4.0.x to 4.1 or from 4.1 to 4.1.x that changed how the limits worked for users. It’s all in the README files.
Bottom line. Don’t worry about the GS limits as they appear. The GS is All-mighty and it might be confusing you on this issue.
When I log into BO on my machine as another user, the max rows is 100,000 like it should be. I am perplexed!! The tech support we have has been no help in explaining this. I have checked every possible thing I can think
of
but my user name seems to be the magic key…but why and how do I fix! Please help, this is holding me up from a deadline.
Thanks Robert, I did end up creating a new user for myself as a last resort. However, if the default parameters for the universe is 100,000 rows why would I (regardless of being a general supervisor) be seeing less than that? Unless there is another default number I am not aware of. I am on version 4.1.3.
Did you check for multiple copies of the .unv file in your file system? Perhaps there is another copy of the .unv file hanging around and confusing things…
Try the following:
change the limit in designer to whatever value. 2. export the universe to repository (the .unv file will be moved into the sub-folder in your businessobjects\universe directory) 3. Check there are no other .UNV files in the BusinessObjects directory tree 4. Log in (or re-log in) to BusinessObjects 5. Check the Options/File locations tab, the universe directory should be set to your “businessObjects\universe” folder)
Now, try the report again
Let me know what happened…
Hope this helps
Walter
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
change the limit in designer to whatever value. 2. export the universe to repository (the .unv file will be moved into the sub-folder in your businessobjects\universe directory) 3. Check there are no other .UNV files in the BusinessObjects directory tree 4. Log in (or re-log in) to BusinessObjects 5. Check the Options/File locations tab, the universe directory should be set to your “businessObjects\universe” folder)
Now, try the report again
I forgot to mention: re-edit the query before running it!! It’s not enough to just “refresh”…
W.
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
I tried this and unfortunately, I am still getting a limited set of rows (20,000). I think I have given up. But thanks
From: W.Muellner[SMTP:w.muellner@DELPHI.AT]
Sent: Friday, November 06, 1998 7:32 AM
W.Muellner schrieb:
Try the following:
change the limit in designer to whatever value. 2. export the universe to repository (the .unv file will
be moved
into the sub-folder in your businessobjects\universe
directory)
Check there are no other .UNV files in the BusinessObjects directory
tree
Log in (or re-log in) to BusinessObjects 5. Check the Options/File locations tab, the universe directory should
be set to
your “businessObjects\universe” folder) 6. Now, try the report again
I forgot to mention: re-edit the query before running it!! It’s not enough to just
“refresh”…
W.
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at