SAP BW Administration side - Queries

[former_member197527]

Hello Experts,

Am trying to understand some queries from an administration aspect so that can update my client. Am not a BASIS person, hence would really need some one to help me understand.

Please let me know if this is not the right forum.

• Are there any web based tools for administration purpose in SAP BW? Is it the NWA alone and is it part of the BW license? Also is it the visual console which is user friendly? Does it cover all the administrative features that a standalone BW system is capable of? Please correct me.
• Also is there any Admin Console to start/stop services as a part of server management? Is it the Management Console only? Also its used only for start/stop services? Nothing else?
• How do we monitor Memory, disk space, virtual server, any other parameters?
• Any limitation on the no.of processors and Scalability?
• Integrate with LDAP and inherit role based authentication / authorizations used in the application?
• What are the different platforms supported for BW tool from sizing aspect?
• Command Line interface is applicable only for start/stop servers on an AIX? Any other facility that administrators use this?
• Does the BW tool have the ability to do parallel processing – to multiple targets, heterogeneous targets?
• Does the BW tool support FTP? For e.g. make an FTP connection to a remote host to transfer files?
• Real time monitoring, to avoid problems i.e. monitoring Server CPU, runaway queries, kill and restore processes from a remote console?
• Web-based Authoring possible?

Awaiting your valuable inputs.

Regards,

Aditya

[Former Member · Accepted solution]

Hi Aditya,

Here are replies as per my experience -

1. Web based consoles are not as capable as actual BW system. NWA is the one for administration but its not a replacement for BW system.

2. SAP Management console does that and many other things like monitoring ICM statistics etc.

3. These things are done from basis transaction in BW system only like ST04, ST02 etc.

4. That is decided as per the load of the system at the time of designing of the system.

5. That can be done.

6. Not aware about this.

7. Command line interface of AIX is like THE  MOST important thing for administrators. All sort of problems can be identified and fixed from there.

8. Yes.

9. Yes.

10. Real time monitoring is done through alert framework inbuilt in system administered through CCMS.

11. Not aware.

Hope this helps,

Regards,

Ashutosh Shukla

[former_member197527 · Accepted solution]

Thank you but would like to know more from the above answers.

Can some one please help:

• Regarding the Processors and scalability, would really like to understand if there are certain standard limitations or sizing, where in a system should have these many no.of processors to manage certain increased scalability so that in future when there is increased DWH, it should support from capacity as well. Any info on this pls?
• Integrate with LDAP and inherit role based authentication / authorizations used in the application?Please let me know at a high level how can this be achieved?
• How can we ensure BW supports FTP? Any suggested approach?
• Difference between NWA and MC? Both come as a part of BW license? Are the same administrative features available in NWA as well? If not, what are not supported? This is not reg development but purely related to performance and administration.
• Can BW be compatible with Windows/LINUX/AIX/SOLARIS? Guess these do for Server OS but what about Client OS? is it only Windows?
• How easy is it to rollback an installation/upgrade?
• Is Sol-Man mandatory? Is it at additional cost?
• Web-based Authoring possible?

Please help me understand regarding these.. Do not have any BASIS contact and hence would need this so that can update to client

[Former Member · Accepted solution]

Hi,

In addition to the excellent answer by Ashutosh I'd add the following:

1. Solution Manager is mandatory and is included in your SAP license - i.e. no additional charge

2. Roll back of an installation is to delete it and start again.

3. Roll back of an upgrade is return to backup

4. BW can run on a number of backends see: http://service.sap.com/pam for the available environments and frontends supported.

5. Performance monitoring comes through a variety of sources - MMC displays some OS files, within SAP are many transactions for monitoring this, or you can integrate the systems into solman and use Solution Manager Diagnostics to analyse issues - this too is included in your SAP license already.

6. Peformance can be improved by adding cpus/memory but the first approach is to tune the system buffers and database buffers.  Your Basis administrator is the person for that.

Hope this helps,

Graham

[former_member197527]

Please close this