3.3    Postinstallation

In this section, we’ll cover the postinstallation activities required before the system becomes operational. Before you begin, verify that your copy of SAP GUI is version 7.40 or higher.

After the installation is completed, refer to the central note for SAP BW/4HANA, SAP Note 234738. This note will be updated with relevant information for setup after an installation to include important notes that need to be implemented after installation or update and postinstallation activities.

Before starting the postinstallation activities, perform a database backup of SAP HANA.

3.3.1    SAP HANA Database Technical User Setup

As covered in SAP Note 2362807, first you need to verify the technical SAP BW/4HANA user (SAP<SID>) in the SAP HANA database to make sure it has the following permissions:

• Object permissions
  • SELECT for schema _SYS_BI
  • SELECT for schema _SYS_BIC
  • SELECT for the BW schema
  • EXECUTE for procedure REPOSITORY_REST (SYS)
• Analytic permissions
  • _SYS_BI_CP_ALL
• Package privileges
  • REPO.MAINTAIN_NATIVE_PACKAGES
  • REPO.READ
  • REPO.EDIT_NATIVE_OBJECTS
  • REPO.ACTIVATE_NATIVE_OBJECTS

You should also verify that the user _SYS_REPO_ has the following object permissions:

• SELECT on BW schema with GRANT option
• SELECT on tables mentioned in table RSOSTABLES

3.3.2    SAP BW/4HANA Setup

Now that the users in the database have been verified, a task list must run. This task list performs the basic system setup to create the background user, configuring the client and installing the necessary technical content, such as InfoObjects and variables.

To run the task list, follow these steps:

1. Login to the system using the user sap* and your master password.
2. Go to Transaction STC01.
3. Enter “SAP_BW4_SETUP_SIMPLE” into the text box.
4. Press (F8) or click Generate Task List Run. Your screen should look like Figure 3.11. You’ll see each phase that will be run and a short description of what it does.
   

   Figure 3.11    SAP BW/4HANA Simple Setup Tasks

5. Under the Parameters column, select Fill for Create Background User in BW.
6. Enter a password and click Continue.
7. Select display parameters for Set/Check BW Client.
8. Enter the client you want to use as the SAP BW client.
9. Select Change Parameters under the Parameters column for Set BW/4HANA Operation Mode. If you’re using SAP BW/4HANA as a data warehouse, set the parameter to the maximum value, 16.
10. Select the Fill Parameters under the Parameters column.
11. Enter the number of days you want messages or parameters to be retained for.
12. Verify that all the information is correct.
13. Press (F8) or click Start/Resume Task list in Dialog.

3.3.3    RFC and Parameter Configuration

Once the task list has completed successfully, the next step is to configure a connection to an SAP router and add parameters to the default profile.

To configure a connection to an SAP router, follow these steps:

1. Login to SAP BW/4HANA from client 000 and go to Transaction OSS1.
2. Click Parameter, then click Technical Settings.
3. Click Change and add the information for your SAP router. Then, click the Save icon.
4. Go to Transaction SM59 and verify that ABAP connection SAPOSS has been created. Double-click SAPOSS and click Connection Test to verify that the connection to SAP router is complete.

To add parameters to the default profile, follow these steps:

1. Go Transaction RZ10, select the DEFAULT profile, click the Extended Maintenance radio button, and click Change.
2. Add the parameters from Table 3.2. (Replace $$ with the instance number of the system.)
3. Click Exit, click Yes to save the changes, save, accept the changes, click Yes to activate the profile, and accept the informational message by clicking Yes.
4. Restart SAP BW/4HANA to apply the parameter changes.

   Parameter Name	Parameter Value
   login/no_automatic_user_sapstar	0
   icm/server_port_0	PROT=HTTP,PORT=80$$, PROCTIMEOUT=600, TIMEOUT=600
   icm/server_port_1	PROT=SAPHTTP,PORT=80$$,PROCTIMEOUT=600, TIMEOUT=600
   icm/server_port_2	PROT=SMTP,PORT=25$$,PROCTIMEOUT=600, TIMEOUT=600
   icm/server_port_3	PROT=HTTPS,PORT=52$$,PROCTIMEOUT=600, TIMEOUT=600

   Table 3.2    Parameter Names and Values

3.3.4    Configuring SAP BW/4HANA Workspaces

Now that your system has restarted, you need to activate and configure the SAP BW/4HANA workspace. From client 000, go to Transaction SICF and activate the following services:

• RSL_UI_MY_WORKSPACE
• RSL_UI_CREATE_COPR
• RSL_UI_CREATE_PROVIDER
• RSL_UI_CHANGE_WORKSPACE
• RSL_UI_CHANGE_QUERIES
• RSL_UI_SUBMIT_DATA
• RSL_UI_CREATE_LCHA
• RSL_UI_CREATE_LCHY
• nwbc_launch

Now, you’ll create the necessary roles and profiles required to meet your business needs. To give business users an environment to use SAP BW Workspace Designer, give them a link to SAP Business Client, or assign the SAP_BW_WORKSPACE_DESIGNER role or the com.sap.ip.i.bi_showcase portal role.

3.3.5    SAP BW/4HANA Table Placement

The next steps ensure that the tables of the system are partitioned correctly with SAP’s recommendations. SAP Note 2334091 covers the table placement and landscape redistribution for SAP BW/4HANA. To complete these tasks, follow these steps:

1. Open a SQL console in SAP HANA Studio and run the following statement with user SAP<SID>: SELECT * FROM TABLE_PLACEMENT;.
2. If the result contains entries for the schema, verify the table placement settings meet current SAP recommendations. If they do, proceed to Step 6. If the result doesn’t contain entries or isn’t current, proceed to the next step.
3. Download TABLE_PLACEMENT_BW4HANA.zip from SAP Note 2334091, extract, select the correct database, select the correct landscape, and open the SQL file in Notepad.

   Note

   SAP Note 2334091 directs you to use TABLE_PLACEMENT_BW4_FILL_PROC.txt. The script will automatically detect your landscape and run the correct SQL statement. We’ve chosen to use the ZIP file to show what the script is doing.

4. In Notepad, in the menu, select Edit • Replace. Enter “<$$PLACEHOLDER>” in Find What and the SAP BW/4HANA schema name in Replace With, then click Replace All. Verify that your schema name has replaced all instances of <$$PLACEHOLDER>. Figure 3.12 shows what the SQL file looks like prior to inserting the schema name.
   

   Figure 3.12    SAP BW/4HANA Table Placement

5. Open a SQL console in SAP HANA Studio with user SAP<SID>, copy and paste the contents of the modified SQL file, and execute. Verify that the entries for the schema have been set by running SELECT * FROM TABLE_PLACEMENT;.
6. Verify that the parameters in the SAP HANA database global.ini file are set in accordance with your landscape from SAP Note 2334091 Step 2.
7. Download REQUIRED_CORRECTION_NOTES_BW4HANA.xlsx from SAP Note 2334091 and apply the notes listed in the spreadsheet.
8. To make sure that all SAP BW tables have been classified correctly, log in to SAP BW/4HANA from client 000 and run report RSDU_TABLE_CONSISTENCY from Transaction SE38. Execute the consistency check CL_SCEN_TAB_CLASSIFICATION and correct any errors.
9. Create a backup of the SAP HANA database.
10. Start the landscape redistribution.

3.3.6    Client Copy

Now that you’ve set the table placement for the system, the next step is to create a new client by performing a local client copy, as follows:

1. Login to client 000 and go to Transaction SCC4.
2. Click the Change button and accept the warning.
3. Enter a three-digit number for the client, the name of the client, the location, a logical system if applicable, the type of currency for the data used, and the type of client it will be.
4. Select the type of security measures for protecting changes and transports.
5. Click Save, then go back and verify that the new client was created.
6. Login to the new client with user <SAP*> and password <PASS>.
7. Go to Transaction SCCL. Select profile SAP_ALL, source client 000, and source client user masters 000.
8. Click Schedule as a Background Job. Client copy logs can be viewed from Transaction SCC3.
9. Once the client copy has completed, you can set the new client as the default client.
10. Go to Transaction RZ10 and select the DEFAULT profile.
11. Click the radio button for Extended Maintenance and click Change.

    Note

    During the client copy, all tables from SAP BW/4HANA will be brought into memory. For development and quality assurance systems, verify there is sufficient memory to complete the client copy.

12. Click Create and add the following parameter:
    • Parameter Name: login/system_client
    • Parameter Value: <Client number>
13. Click Save, go back, save, accept the message, and restart the system for the parameter to be active.

3.3.7    Service Pack Upgrade and SAP License Installation

Before your system is completely operational, you’ll need to upgrade to the latest service pack. Each service pack contains new corrections and optimizations that should be applied prior to going live. Our recommendation is to connect the system to SAP Solution Manager. From there, you can upload the system information to SAP, use maintenance planner to download the service pack media, and use Software Update Manager (SUM) to complete the update. Alternatively, you can download the service packs directly from SAP and use Transaction SPAM to update.

The last remaining step before your system is operational is to install a permanent SAP license for your system; SAP installs a 90-day temporary license from the date of installation. From Transaction SLICENSE, you can view and install your license.