SAP Central Management Console and Windows AD Authentication

When changing Domain Controllers for a UMS/CMS server you need to modify the krb5.ini file. In our case that file was located in C:\WinNT. Simply adding another kdc line, saving the file and restarting TomCat updates the system.

AD.ourdomain.COM = {
kdc = NewDCName.AD.ourdomain.COM
kdc = OldDCName.AD.ourdomain.COM
default_domain = AD.ourdomain.COM
}

Prior to this update, I was receiving this error:

Account Information Not Recognized: Active Directory Authentication
failed to log you on. Please contact your system administrator to make
sure you are a member of a valid mapped group and try again. If you are
not a member of the default domain, enter your user name as
UserName@DNS_DomainName, and then try again. (FWM 00006)

Viewing Data in a NW AppSet

Often I need to know where data is when testing after an upgrade or install. For the NW version do the following:

1. Login to SAP GUI
2. Start transaction RSA1
3. If prompted, decide whether to view or not view the documentation
4. In the Modeling pane, click InfoProvider
5. In the large pane on the right, expand Business Planning and Consolidation
6. Expand your AppSet
7. Right click on your Application, then select Display Data
8. If an information dialog appears about too many characteristics, click the green check

At this point a dialog appears with all the dimensions and their properties. So for example, the P_Activity dimension shows 4 rows:

1. [ ] [ ] CALC[P_ACTIVITY]
2. [ ] [x] CALC[P_ACTIVITY]
3. [ ] [ ] P_ACTIVITY
4. [ ] [x] P_ACTIVITY

Notice there are white check boxes and greyed out check boxes. The grey boxes that are checked indicate the ID for the member, the non checked contain the name. So check the white check box like this to get ID and Name:

1. [ ] [ ] CALC[P_ACTIVITY]
2. [ ] [x] CALC[P_ACTIVITY]
3. [x] [ ] P_ACTIVITY
4. [x] [x] P_ACTIVITY

Do this for every dimension you want to view with your results. Notice the SignedData row at the end, this is the actual value column. Then:

1. Click the green check.
2. Clicking the Fld Selectn for Output button
3. Click the Select All button
4. Click the Clock with a green check button
5. You return to the previous screen
6. Click the Clock with a green check button again
7. Your data displays

Once I know where data is located I can run reports in the Excel client.

Changing R/3 SAP GUI Permissions

Recently I needed to apply an SAP Note to our BPC NW environment. To do this, I had to create a new 'admin' user and run the Notes Assistant under that new account. Before I could run the Notes Assistant, I need to grant access to the snote transaction in SAP GUI. This is how I did it:

1. Login with DDIC
2. Go to su01
3. Specify user ID
4. Change
5. Go to Profiles tab
6. enter SAP_ALL or whatever objects
7. Save
8. Exit
   

Some BPC NW Commands

In SAP GUI using se80 will show tables.

These table prefixes mean the following:

• uj - BPC related
• uja - AppSet
• ujj - Journal
• uje - Security

rsa1 - Data Warehousing Workbench: Modeling (view AppSet, dimension attributes and raw data here)
su01 - Create Users
snote - Run Note Assistant

"The ABAP server specified in the server configurtion file is not reachable

Problem

When trying to log into the launch page on BPC NW 7.5 I receive either a timeout error or this:

• The ABAP server specified in the server configurtion file is not reachable

Investigating further I find I cannot login to SAP Login

When trying to login to SAP Logon 710 I get:

partner '192.168.1.40:sapdp00' not reached.
WSAECONNREFUSED: Connection refused

SAP Support suggested:

Connection refused errors are normally triggered in two situations:

- There is a firewall in the way of the connection rejecting the
communication
- The service is not running on the server

It seems that the problem here is that you are not being able to reach
the server. If you try to do a telnet test like:

telnet 192.168.1.40 3200

Are you able to open the port or you receive an error too?

I in fact cannot telnet to port 3200

Solution

• Open SAP Management Console
• SAP Systems > SPC > dublin 0 (our ABAP / NW server)
• Right click on dublin 0
• Click Start...