BI Initial Setup for ABAP

Description

Prerequisites for Configuring BI ABAP:

1.Ensure that the administrator user already exists in your BI (ABAP) system and has been assigned profiles S_BI-WHM_RFC and S_BI-WX_RFC (minimum requirement). 2. Refer Note 1044441( First link ) and Example file ( Second link ) which contains recommendations for Netweaver BI Basis parameters to set BI system optimally.

Note 1044441
Example file

State
Root process finished with skipped steps
(18 steps executed successfully)

Skip by Execution Condition Steps(2)

  • Define Logical System for BW Client
  • Assign Logical System to BW Client

    • Skip by Error Steps(7)

  • Prepare the BI System
  • Setting up remote machine in central
  • Schedule Cache Clean-Up
  • Schedule Monitor Assistant
  • Schedule DTP Clean-Up Job
  • Delete Old Logs
  • Write Application Logs to Database

    • Sub steps

  • Get system profile details
  • Usage Type Information
  • Input for BI Prerequisites
  • Configurations of BI-ABAP

    • Statistic Information

    Type and number of configuration steps
    Configuration TypeNo of Steps
    /content/Netweaver/EP/BI/service/ActivatePersonalizationContent.wsdl1
    /content/Netweaver/EP/BI/service/rsoCtcSetHideDwb3xFunc.wsdl1
    /content/Netweaver/EP/BI/service/rsoCtcCtoDestinations.wsdl1
    /content/common/service/usermanagement/maintainUser.wsdl1
    /content/Netweaver/EP/BI/service/rsoCtcSetActiveComponent.wsdl1
    /content/Netweaver/EP/BI/service/BAPI_RSO_CTC_NWA_GET_INFO_CENTRAL.wsdl1
    /content/common/service/usermanagement/abapAssignProfilesToUser.wsdl1
    /content/Netweaver/EP/BI/service/rsoCtcCheckSysConsistency.wsdl1
    /content/Netweaver/EP/BI/service/RSO_CTC_CHECK_JOB_SCHEDULE.wsdl1
    /content/Netweaver/EP/BI/service/RsMandtUniqueSetRfc.wsdl1
    /content/common/service/usermanagement/abapAssignRolesToUser.wsdl1
    /content/Netweaver/EP/BI/service/rsoCtcDefaultTemplates.wsdl1
    /content/Netweaver/EP/BI/service/rsoCtcMetaDataSearch.wsdl1
    /content/Netweaver/EP/BI/profile/viewMaintenance.xsd1

    Support Information

    Type of Action
    Process
    Debug Events

    Environmental Messages (at start time)

    UMEDestination
    <Destination name="CTCBackendDestination" subtype="message" type="JCOConnection"> <name>CTCBackendDestination</name> <type>JCOConnection</type> <subtype>message</subtype> <jco.destination.pool_capacity>5</jco.destination.pool_capacity> <jco.client.r3name>R3P</jco.client.r3name> <jco.client.group>SB_PRD</jco.client.group> <jco.client.lang>KO</jco.client.lang> <jco.client.cpic_trace>-1</jco.client.cpic_trace> <jco.client.user>CTC_NULL</jco.client.user> <jco.client.auth_type>CONFIGURED_USER</jco.client.auth_type> <jco.destination.peak_limit>10</jco.destination.peak_limit> <jco.destination.expiration_time>300000</jco.destination.expiration_time> <jco.client.passwd>CTC_NULL</jco.client.passwd> <jco.client.type>3</jco.client.type> <jco.destination.max_get_client_time>10000</jco.destination.max_get_client_time> <jco.client.client>100</jco.client.client> <jco.client.mshost>61.81.244.154</jco.client.mshost> </Destination>
    ErrorMsg
    <ErrorCodes/>
    EMPTY_MESSAGE_FOR_XPATH
    <EMPTY_MESSAGE_FOR_XPATH/>
    J2EEAdministrator
    <J2EEAdministrator> <User>J2EE_ADMIN</User> <Password>CTC_NULL</Password> </J2EEAdministrator>
    Wizard
    <root/>
    SLDAdministrator
    <SLDAdministrator> <Host>solman</Host> <Port>50000</Port> <User>CTC_NULL</User> <Password>CTC_NULL</Password> </SLDAdministrator>
    com.sap.tc.lm.ctc.SystemType
    <SystemType> <MegaTenancyFlag>false</MegaTenancyFlag> <MegaTenancyType>CTC_NULL</MegaTenancyType> <SystemRole>CTC_NULL</SystemRole> <SystemLocation>CUSTOMERSITE</SystemLocation> <BCDesignTimeFlag>false</BCDesignTimeFlag> <AppRuntimeFlag>true</AppRuntimeFlag> </SystemType>
    CTCImportParameters
    <CTCImportParameters/>
    SystemInfo
    <Profiles> <SystemProfile> <SYS_GLOBAL_DIR>/usr/sap/EPP/SYS/global</SYS_GLOBAL_DIR> <AMOUNT_MEMORY>18022</AMOUNT_MEMORY> <INSTANCE_NUMBER>00</INSTANCE_NUMBER> <VM_VENDOR>sap</VM_VENDOR> <ENQSRV_HOST>epprd</ENQSRV_HOST> <JAVA_HOME>/usr/sap/EPP/J00/exe/sapjvm_6</JAVA_HOME> <MSGSRV_PORT>3901</MSGSRV_PORT> <INSTANCE_NAME>J00</INSTANCE_NAME> <com.sap.datasource.default>SAPEPPDB</com.sap.datasource.default> <CPU_COUNT>8</CPU_COUNT> <OS_BITLENGTH>64</OS_BITLENGTH> <com.sap.engine.installdir>/usr/sap/EPP/J00/j2ee</com.sap.engine.installdir> <SYS_DATASOURCE_NAME>SAPEPPDB</SYS_DATASOURCE_NAME> <MSGSRV_HOST>epprd</MSGSRV_HOST> <NODE_INDEX>00</NODE_INDEX> <INSTANCE_ID>32690</INSTANCE_ID> <START_TIME>1364364318836</START_TIME> <OS_UNICODE>uc</OS_UNICODE> <com.sap.InstanceNumber>32690</com.sap.InstanceNumber> <com.sap.systemdir>/usr/sap/EPP/SYS/global</com.sap.systemdir> <SYSTEM_INFO>cluster_config/system/instances/current_instance/cfg/SystemInfo</SYSTEM_INFO> <com.sap.SID>EPP</com.sap.SID> <FULL_INSTANCE_NAME>EPP_J00_epprd</FULL_INSTANCE_NAME> <INSTANCE_HOST>epprd</INSTANCE_HOST> <SYSTEM_NAME>EPP</SYSTEM_NAME> <INSTANCE_DIR>/usr/sap/EPP/J00</INSTANCE_DIR> <com.sap.instancedir>/usr/sap/EPP/J00</com.sap.instancedir> <DB_DRIVER_LOCATION>/oracle/client/11x_64/instantclient/ojdbc6.jar</DB_DRIVER_LOCATION> <ENQSRV_PORT>3201</ENQSRV_PORT> <OS_NAME>rs6000_64</OS_NAME> <DB_HOST>epprd</DB_HOST> <HTTP_PORT>50000</HTTP_PORT> <HTTPS_PORT/> <P4_PORT>50004</P4_PORT> <INSTANCE_HOST_FULL>epprd.sgnsis.com</INSTANCE_HOST_FULL> <SAPLOCALHOSTFULL>epprd.sgnsis.com</SAPLOCALHOSTFULL> <property> <name>EXE_DIR</name> <value>/usr/sap/EPP/J00/exe</value> </property> <property> <name>SHM_MONITORING_ENABLED</name> <value>true</value> </property> <property> <name>com.sap.instdir.unixpath</name> <value>/usr/sap/EPP/J00</value> </property> <property> <name>PROFILE</name> <value>/usr/sap/EPP/SYS/profile/EPP_J00_epprd</value> </property> </SystemProfile> </Profiles>
    UsageTypeProfile
    <Profiles> <UsageTypesProfile> <isDoubleStack>false</isDoubleStack> <product code="NetWeaver" description="SAP EHP1 FOR SAP NETWEAVER 7.3" name="SAP NETWEAVER"> <usagetype isActive="false" name="ALV-EXPORT" productCode="NetWeaver"/> <usagetype isActive="false" name="AAS" productCode="NetWeaver"/> <usagetype isActive="true" name="AS" productCode="NetWeaver"/> <usagetype isActive="false" name="BASIC-RA" productCode="NetWeaver"/> <usagetype isActive="false" name="PI" productCode="NetWeaver"/> <usagetype isActive="true" name="BPM" productCode="NetWeaver"/> <usagetype isActive="true" name="DI" productCode="NetWeaver"/> <usagetype isActive="true" name="EP" productCode="NetWeaver"/> <usagetype isActive="true" name="BI" productCode="NetWeaver"/> <usagetype isActive="true" name="EPC" productCode="NetWeaver"/> <usagetype isActive="false" name="CE-PROCESS" productCode="NetWeaver"/> <usagetype isActive="true" name="CE-APPS" productCode="NetWeaver"/> <usagetype isActive="false" name="JOB-SCHED" productCode="NetWeaver"/> <usagetype isActive="false" name="PI-AF" productCode="NetWeaver"/> <usagetype isActive="true" name="COMP-ENV" productCode="NetWeaver"/> <usagetype isActive="true" name="BASIC" productCode="NetWeaver"/> <usagetype isActive="false" name="ADOBE" productCode="NetWeaver"/> <usagetype isActive="false" name="CE-VOICE" productCode="NetWeaver"/> <usagetype isActive="true" name="NW-MODEL" productCode="NetWeaver"/> <usagetype isActive="false" name="IDE-Update-Site" productCode="NetWeaver"/> <usagetype isActive="false" name="PI-AE-SE" productCode="NetWeaver"/> <usagetype isActive="false" name="PI-AEX" productCode="NetWeaver"/> <usagetype isActive="true" name="ESR" productCode="NetWeaver"/> </product> </UsageTypesProfile> </Profiles>
    ProcessRequest
    <request> <requestorType/> <requestorId/> <externalId/> <internalId>387c9aaa-616b-4e8a-9def-2b492a3c61e2</internalId> </request>
    URLParameters
    <URLparameters> <numOfParameters>5</numOfParameters> <serverHost>ep.sgnsis.com</serverHost> <serverPort>80</serverPort> <httpProtocol>http</httpProtocol> <sap-wd-secure-id>v_GwjcIoJhUzlSZEK5M0qg==</sap-wd-secure-id> <sap-wd-norefresh>X</sap-wd-norefresh> <sap-wd-cltwndid>6158df5e96a611e2c9f500000031e1ba</sap-wd-cltwndid> <sap-wd-appwndid>6158df5f96a611e2c6f700000031e1ba</sap-wd-appwndid> </URLparameters>
    Runtime
    <Runtime> <Type>J2EE</Type> <Version/> <UserName>J2EE_ADMIN</UserName> <UserDir/> </Runtime>
    ProcessMessage
    <Process> <Session>2b6f56d2-e756-462f-a3f8-6691a1d35ff0</Session> <Mode>GUI</Mode> <Component>sap.com/tc~lm~config~content</Component> <Path>content/Netweaver/EP/BI/processes/BIforNWAProcess.cproc</Path> <StartDate>Wed Mar 27 15:20:44 KST 2013</StartDate> </Process>
    session start: 2013/03/27 at 15:20:44
    session finish: 2013/03/27 at 15:51:27