Monday, September 8, 2014

http://scn.sap.com/community/public-sector/blog/2014/09/08/smart-city-sap

USEFUL BI TRANSACTION CODES FOR BPC BACKEND

USEFUL BI TRANSACTION CODES FOR BPC BACKEND

 
Note: please do not try to use these T-codes unless you are familiar with SAP BI Backend system.
 
Backend Administration
Explanation
RSA1
Overview of InfoProviders and InfoObjects
LISTCUBE
To check the InfoCube content
LISTSCHEMA
Schema viewer for InfoCubes
SE80
Object navigator
RSD1
InfoObjects editor
RSH1
InfoObjects Hierarchy
 
 
Log
 
ST22
To find ABAP runtime errors (ABAP dumps)
SLG1
Application error (for BPC NW, look for UJ* as Object)
SM21
System log of the BW server
 
 
Trace
 
ST01
System trace
ST05
Performance analysis
UJSTAT
Performance statistics report
 
 
Users
 
SU01
User Maintenance
PFCG
Role maintenance
SU01DUser Maintanance - Display only
ABAP instance
 
SM51
Overview of the application server ABAP instance
SM50
Overview of the work processes on the instance
SM04
Overview of users logged on the instance
SM37
Overview of jobs running on the instance
SM12
Display the locks that are currently set
 
 
Transport
 
SE01
Overview of transport requests and their logs on the instance
STMS
Transport Management System
 
 
File server
 
UJFS
To access BPC NW web and file folders per environment
 
 
Programs
 
SE38
To run ABAP programs. To find default ABAP programs for BPC NW, look for UJ* (for example UJS_ACTIVATE_CONTENT, UJA_DATA_CHECKER…)
 
 
Database tables
 
SE16
Database tables browser
SE11
ABAP dictionary
 
 
Process chains
 
RSPC
Process chains maintenance
 
 
Backup & Recovery
 
UJBR
Environment backup and recovery

Wednesday, September 3, 2014

Planning for SAP Data Services and SAP Information Steward Installation- attached video demonstrates plan your hardware to Install DS 4.2 and IS

Thursday, August 15, 2013

HANA Cookbook

SAP HANA DB Connect

SAP HANA as Source System for SAP BW through DB Connect:

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/84/0CB892EDFBC34290C1685132006662/content.htm?frameset=/en/4A/1DF9315C171B40E10000000A42189C/frameset.htm

Note 1597627 - SAP HANA connection
Note 1589983 - No DBCON entry possible for SAP In-Memory Database

Note 400818 - Information about the R/3 database library

Friday, June 14, 2013

SAP HANA Single Sign on

SAP  HANA Single Sign on

Single sign-on (SSO) allows a user to login once and gain access to multiple systems without being asked to login again. Depending on how SSO has been setup, this could permit the user login to just a front end application or it can enable SSO all the way down to the database in what’s known as SSO to database (SSO2DB).


https://websmp105.sapag.de/~sapidb/012003146900000774762013E/HowTo_HANA_SSO_Kerberos_v1_2.pdf



SAP Notes:

 Note 1813724 - HANA SSO/Kerberos: create keytab and validate conf

 Note 1837331 - HOWTO HANA DB SSO Kerberos/ Active Directory