SAP BW-BO-SAC Planning

SAP HANA-HWC-AP Intel Processors: Nehalem, Westmere, Ivy. PAM: http://service.sap.com/~sapidb/011000358700000701932011E  SAPS:SAP Application Benchmark Performance Standard (throughput unit for HW sizing)

ODBO:OLE DB for OLAP ODBC:Open Database Connectivity JDBC:Java Database Connectivity BICS: BI Consumer Services.

SAP BW Performance These figures were reported by customers, which already have BW on HANA operating in their IT landscape. 1. Red Bull Red Bull started to run its SAP NetWeaver 7.3. Business Warehouse on HANA in 2011. The migration. Non-disruptive fast migration. Project completed in less than 2 weeks. Database size before migration: 1.5 TB; reduced by 80% after migration. The result: Boost in load performance. Simplified architecture: InfoCubes no longer required as an aggregation layer Data can be read directly out of the DataStore Object (DSO). Replication of data to InfoCubes and Business Warehouse Accelerator (BWA) Indexes no longer necessary. 2. Utilities industry representative This utilities customer also upgraded to and operated its SAP Netweaver 7.3. BW on the latest HANA database release. Data Load Performance For DSO activation of 5.2 million records, performance improved by factor 32x. Before: 21 hours 40 minutes - After: 40 minutes. Data load into ...

1) Platform Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer 2) Enterprise Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer LT Replication Add-on (SLT) LT Replication Server (SLT) SAP BO Data Services 4.0 3) Enterprise Extended Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer LT Replication Add-on (SLT) LT Replication Server (SLT) SAP BO Data Services 4.0 Sybase Adaptive Server Enterprise (ASE) Sybase Replication Server (ECDA) Sybase Replication Server Agent SAP HANA Load Controller (Includes R/3 Load, RepServer De-cluster Add-On) It depends on what licenses you already have and how do you intends to use SAP HANA. Platform Edition = ETL via BO Data Services (If the client already have li...

OLAP Cubes sources (as a DataSource) for SAP BO OLAP, see below • SAP BW InfoCube • MS SQL Server Analysis Services (SSAS) Cube • Hyperion Essbase Cube (Now it is Oracle Essbase) Designer creates universe automatically from a connection to a InfoCube or QueryCube. The cube elements are mapped directly to equivalent structures in the universe. A OLAP flattening driver is used to build a relational view from the cube. The universe is then generated from the view.

Multisource Universes: An administrator can build a universe (the vendor's term for a data model) drawing on multiple relational data sources. This has been a big competitive weakness in SAP BusinessObjects when compared to Oracle, IBM Cognos and MicroStrategy. I've tested this capability in 4.0 and feel that other products still seem to have a more robust approach. Nonetheless, this is still a big improvement for SAP BusinessObjects customers. Direct SAP BICS Connectivity: The 4.0 release lets SAP Business Warehouse (BW) customers access BEx queries directly via the BICS (Business Intelligence Consumer Services) layer, a proprietary communication interface for BW, using either Web Intelligence, Dashboard Designer, or Crystal Reports. Going through the BICS layer provides better performance than the APIs previously used. There had been talk of SAP BW being supported as a data source in the universe, but that does not appear to be the case. Dashboard Improvements: X...

SAP BW Upgrade usually of 2 Types. 1. Technical Upgrade (Service Pack Stack Upgrade) 2. Functional Upgrade In Technical Upgrade Projects, Lead/Senior Consultant (Expertise) will be involve in many Phases. SAP BW SPS Upgrade phases: If it is a global client (MNCs) : Decisions based on Business Needs/Cost/Time/Effective/Thorough. Some times client will not like to upgrade ECC/CRM...Boxes. 1.Client Will decide on which SAP BW versions they are in (From) & To which Level System Should be Upgrade based on requirement and its Compatibility/supportability. As BW becomes a Neccessary SAP Warehouse (Backend) for SAP Business Objects - Business Intelligence, GRC, EPM, 2.Current System Stack versions, Stats of the Systems (Boxes) & Documentation of Business process. 3.Senior Guys will approach The SAP Market Place, will search for Neccessary Patches/SPS (E.g. Upgrade from SAP BW 7.0 SPS 20 to SAP BW 7.1/7.2/7.X EHP 1). Usually Server has ABAP Stack (BW SPS version +2 Levels...

BWA : How BW Accelerator reduces maintenance effort?!   Aggregate Maintenance Automated caching strategies. Building database indexes Improves implementation and administration Reduces TCO Where as the relational aggregate/caching approach is not obsolete with the BW accelerator, and is suitable for some scenarios Smaller data volume Predictable query patterns Relaxed response time constraints Caching reduces potential high load on BW accelarator   Here is the link which shows how to use the BWA https://docs.google.com/View?id=dfdxn336_38hnzg6jf7

Row Level Security limits the rows(data) a user/group can view. This is implemented using Supervisor in previous versions of BO.From XI we can implement Row Level Security in Designer.We can use @Variable('BOUSER') in where condition area of an Object Definition.for eg: Employee.EmployeeId  is the object, Go to object properties in Select--we write Employee.EmployeeId, in Where write  Employee.EmployeeId=@Variable('BOUSER').This gives the values related to Employee who logs in.In this way we can implement Row level Security. We also have another way in which we use "Manage Access Restrictions".In Designer->Tools->Manage Security->Manage Access Restrictions-->Give a name to restriction -->In Row tab(select table & give a condition eg:Country.CountryName=Singapore or CompanyCode=1010) -->Assign this restriction to a Group/User. This restricts a user(eg.Singapore sales Manager) to access values coresponding to Singapore. We can als...