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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Some advice on how to performance tune SAP BI BusObjects
3 members found this topic helpful
Goto page Previous  1, 2
 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11429
Location: Manchester, UK


flag
PostPosted: Fri Apr 24, 2015 9:16 am 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

JonnySpec wrote:
Mak, great link.. finally had something to point to for my arguement that millions of rows in a webi is a bad thing. thumbsup.gif thumbsup.gif

Some users were trying to use webi for data dumps banghead.gif


Data dumps? That's nothing, schedule to export to Excel and you can use it for your full ETL process icon_smile.gif

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
pcgeekus
Principal Member
Principal Member



Joined: 16 Oct 2003

Posts: 195
Location: Moline, IL


flag
PostPosted: Thu Mar 16, 2017 3:06 pm 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

Just an update. SAP BI 4.2 SP3+ will execute queries in parallel, but it does have some limits, so keep the number of queries under 6.
_________________
"Another day...another bug"
BO 4/5/XIR2 SP5.2, XI 3.1 SP3.5, Now on 4.1 SP5, upgrading to 4.2 SP4. 130K+ reports and 65K users.
Jon F.
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17345
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Fri Mar 17, 2017 1:32 am 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

And the limits are, please? And why stick to at most 6?
_________________
Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
pcgeekus
Principal Member
Principal Member



Joined: 16 Oct 2003

Posts: 195
Location: Moline, IL


flag
PostPosted: Mon Mar 20, 2017 12:31 pm 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

I think that's the SAP default limit, but Alan Mayer said that you aren't stuck with that and it can be set higher.
_________________
"Another day...another bug"
BO 4/5/XIR2 SP5.2, XI 3.1 SP3.5, Now on 4.1 SP5, upgrading to 4.2 SP4. 130K+ reports and 65K users.
Jon F.
Back to top
Mathew.ed
Forum Member
Forum Member



Joined: 29 Apr 2017

Posts: 5



PostPosted: Sat Apr 29, 2017 1:33 am 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

Great stuff Andreas.
Back to top
camillelola
Forum Member
Forum Member



Joined: 20 Nov 2017

Posts: 1



PostPosted: Mon Nov 20, 2017 11:34 pm 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

Thanks for proving the Information.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11429
Location: Manchester, UK


flag
PostPosted: Tue Nov 21, 2017 4:16 am 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

pcgeekus wrote:
I think that's the SAP default limit, but Alan Mayer said that you aren't stuck with that and it can be set higher.


The only Alan Mayer I know is in more of a SAS and VB expert rather than BO. Pinch of salt needed.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14237
Location: England


flag
PostPosted: Tue Nov 21, 2017 4:20 am 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

Alan Mayer is Dave Rathbun's old partner in crime.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11429
Location: Manchester, UK


flag
PostPosted: Tue Nov 21, 2017 4:25 am 
Post subject: Re: Some advice on how to performance tune SAP BI BusObjects

Nick Daniels wrote:
Alan Mayer is Dave Rathbun's old partner in crime.


Ah, we'll let Dave destroy this Alan then. lol.gif

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
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.0283 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0249)
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