среда, 25 июля 2012 г.

Активация трансформаций и DTP и другое

В идеале хотелось бы программу, которая бы пробегала по цепочке и активировала не активные трансформации и DTP.

Нашел ещё книгу Common SAP R/3 Functions от William Lawlor на google book на похожую тематику.

Но в ручном режиме, может пригодиться следующее...
RSDG_TRFN_ACTIVATE - активация трансформаций (note 1408161). Запрос на перенос не формируется.
RSBKDTPREPAIR - активация DTP, транспорт по желанию клиента.
RSBK* - там вообще целый сборник программ, в основном для работы с DTP

Список ниже, но более цивильно оформлен... 

Useful ABAP Programs and Function Modules in SAP BI


RSDG_CUBE_ACTIVATE     куб
RSDG_ODSO_ACTIVATE     DSO
RSDG_IOBJ_ACTIVATE        инфо-объект
RSDG_MPRO_ACTIVATE     Activating Multiproviders
RS_COMSTRU_ACTIVATE_ALL     Activate all inactive Communication Structures
RS_TRANSTRU_ACTIVATE_ALL     Activate Transfer Structure
RSAU_UPDR_REACTIVATE_ALL     Activate Update Rules
RRHI_HIERARCHY_ACTIVATE     Activate Hierarchies
SAP_AGGREGATES_ACTIVATE_FILL     Activating and Filling the Aggregates of an InfoCube

<неожиданно много вкусного, чуть позже переформатирую
RSDDS_AGGREGATES_MAINTAIN --- attribute change run
RSSM_SET_REPAIR_FULL_REQUEST -- changes full update to repair fulll request
RSTRSNSTRU_ACTIVATE_ALL-- activating transfer structure
RSPC_PROCESS_FINISH --- process chain details
RSDG_IOBJ_REORG Repair InfoObjects
RSDG_IOBJ_REORG_TEXTS Reorganization of Texts for InfoObjects
RSDG_MPRO_ACTIVATE Activating Multiproviders
RSDG_MPRO_COPY Make Multiprovider Copies
RSDG_MPRO_DELETE Deleting Multiproviders
RS_COMSTRU_ACTIVATE_ALL Activate all inactive Communication Structures
RS_TRANSTRU_ACTIVATE_ALL Activate Transfer Structure
RSAU_UPDR_REACTIVATE_ALL Activate Update Rules
RRHI_HIERARCHY_ACTIVATE Activate Hierarchies
SAP_AGGREGATES_ACTIVATE_FILL Activating and Filling the Aggregates of an InfoCube
SAP_AGGREGATES_DEACTIVATE Deactivating the Aggregates of an InfoCube
RS_PERS_ACTIVATE Activating Personalization in Bex(Inactive are highlighted)
RSSM_SET_REPAIR_FULL_FLAG Convert Full Requests to Repair Full Requests
SAP_INFOCUBE_DESIGNS Print a List of Cubes in The System and Their Layouts
SAP_ANALYZE_ALL_INFOCUBES Create DB Statstics for all InfoCubes
SAP_CREATE_E_FACTTABLES Create Missing E-Fact Tables for InfoCubes and Aggregates
SAP_DROP_EMPTY_FPARTITIONS Locate/Remove Unused or Empty partitions of F-Fact Table
SAP_DROP_TMPTABLES Remove Temperory Database Objects

Function Modules within BW.

Function Module Description (Function Group RRMX)
RRMX_WORKBOOK_DELETE Delete BW Workbooks permanently from Roles & Favourites
RRMX_WORKBOOK_LIST_GET Get list of all Workbooks
RRMX_WORKBOOK_QUERIES_GET Get list of queries in a workbook
RRMX_QUERY_WHERE_USED_GET Lists where a query has been used
RRMX_JUMP_TARGET_GET Get list of all Jump Targets
RRMX_JUMP_TARGET_DELETE Delete Jump Targets

Function Module Description
MONI_TIME_CONVERT Used for Time Conversions.
CONVERT_TO_LOCAL_CURRENCY Convert Foreign Currency to Local Currecny.
CONVERT_TO_FOREIGN_CURRENCY Convert Local Currency to Foreign Currency.
TERM_TRANSLATE_TO_UPPER_CASE Used to convert all texts to UPPERCASE
UNIT_CONVERSION_SIMPLE Used to convert any unit to another unit. (Ref. table : T006)
TZ_GLOBAL_TO_LOCAL Used to convert timestamp to local time
FISCPER_FROM_CALMONTH_CALC Convert 0CALMONTH or 0CALDAY to Financial Year or Period
RSAX_BIW_GET_DATA_SIMPLE Generic Extraction via Function Module
RSAU_READ_MASTER_DATA Used in Data Transformations to read master data InfoObjects

 RSPC_CHAIN_ACTIVATE_REMOTE

RSIMPCURR -- To Transfer Exchange Rates
RSIMPCUST -- To Transfer Global Settings from source system
RS_TRANSTRU_ACTIVATE_ALL -- To Activate Transfer Rules
-- Useful whenever we need to activate transfer rules in Quality or Production system after transports. 

RSAU_UPDR_REACTIVATE_ALL -- To Activate Update Rules
SAP_CONVERT_TO_TRANSACTIONAL -- To change Basic Cube to Transactional Cube
RSAR_PSA_CLEANUP_DIRECTORY -- To Clean PSA and Change log
SAP_INFOCUBE_DESIGN -- 
To know statistics(Size) of Cubes
-- 
Useful to know the size of Fact Tables and Dimension Tables
RSSM_SET_REPAIR_FULL_FLAG -- 
To change request status from Full load to repair full
-- Useful to start delta loads, If full loads are already present in data target from same data source
RSDDS_AGGREGATES_MAINTAIN -- For Hierarchy/Attribute Change run
RSDDS_CHANGERUN_MONITOR -- To Check Change run Status

RSDG_ODSO_ACTIVATE -- To Activate ODS in background. very much useful when BEx reporting switched on.
RSDG_IOBJ_ACTIVATE -- To Activate Infoobjects(Mass Activation)
RSDG_MPRO_ACTIVATE -- To Activate MultiProviders
RSDG_CUBE_ACTIVATE -- Activation of InfoCubes
RS_COMSTRU_ACTIVATE_ALL -- Activate all inactive communication structures 
RSCONN07 - SAP Connect Administration(System Status)
RSAOS_METADATA_UPLOAD_BATCH -- To replicate single datasource from Source(R/3) 

RSDRD_DELETE_FACTS -- To delete data selectively from infoprovider(ODS or CUBE)
RSAR_LOGICAL_SYSTEMS_ACTIVATE -- Activate All SAP Source Systems (After BW Upgrade)
RSDS_DATASOURCE_ACTIVATE_ALL -- Activate All DataSources of a Log System
RSTCC_ACTIVATE_ADMIN_COCKPIT -- Perform all steps to activate the content for the BI Admin Cockpit
RSTCC_ACTIVATEADMINCOCKPIT_NEW -- Activate Content for the BI Admin Cockpit

RSDG_CUBE_ACTIVATE (InfoCube)
RSDG_IOBJ_ACTIVATE (InfoObject)
RSDG_MPRO_ACTIVATE (MultiProvider)
RSDG_ODSO_ACTIVATE (DSO)
RSQ_ISET_MASS_OPERATIONS (InfoSet - Requires client to be opened)
RSDS_DATASOURCE_ACTIVATE_ALL (DataSource)

RSDMD_DEL_MASTER_DATA

Удаление данных в кубе
RSSM_DELETE_REQUEST
RSDD_INFO_REQUID_DELETE


CALL FUNCTION 'RSAWB_MAINTAIN_DTA'
  EXPORTING
    i_method                         =  'DELDATA'
    I_DTA                              =  name_of_cube_or_dso
    I_DEL_DIMS                     =  'X' .


Использует таблицу rstran и класс cl_rstran_maintain для трансформация
Таблицы rsbkdtp AS a JOIN rsbkdtpstat и класс cl_rsbk_dtp для DTP

TableDescription
RSBKDTPBW: Data Transfer Process Header Data
RSBKDTPHDTP: Historic Versions
RSBKDTPSTATStatus Information on Data Transfer Process
RSBKDTPTTexts on Data Transfer Processes
RSBKDTPTHTexts on Data Transfer Processes
RSDDSTATDTPTable for WHM Statistics. Details DTP
RSOACUBE_DTPBW: OLTP Direct Access: Directory of Assigned Remote DTPs
RSBKDATAPAKSELDTP: Data Package Selections
RSBKSELECTSelections for DTP Request (Summary)
RSBKREQUESTDTP Request
RSBKREQUEST_VView of DTP Request
RSBKBPBreakpoints
RSBKDATAINFOInformation on DTP Runtime Buffers
RSBKDATAPAKIDDTP: Status Table for Data Packages
RSBKSUBSTEPProperties of Substeps in a DTP



TableDescription
RSTRANTransformation
RSTRANFIELDMapping of Rule Parameters - Structure Fields
RSTRANRULETransformation Rule
RSTRANSTEPROUTRule Type: Routine
RSTRANRULESTEPRule Steps for a Transformation Rule
RSTRANSTEPMAPMapping for Rule Step Within a Rule
RSLDPIO Links datasource to infopackages
RSLDPIOT InfoPackage Text Description
RSLDPRULE ABAP source code for InfoPackages
RSLDPSEL Hardcoded selections in InfoPackages
RSMONICDP Contains the request-id number by data target
RSPAKPOS List of InfoPackage Groups / InfoPackages
RSSELDONE InfoPackage selection and job program
RSREQDONE
RSLDTDONE
RSUICDONE

RSEC_DELETE_AUTHORIZATION - удаление значений из транзакции RSECADMIN. А то тут коллеко  по неопытности нагенерил понимаешь....

1 комментарий:

I комментирует...

Программа RSDG_TRFN_ACTIVATE очень хороша. Удобна для активации в продуктиве, без лишних переносов.

Столкнулся с особенностью, что источник данных, как параметр этой программы, указывается по принципу: "имя источника (много пробелов) исходная система". В этом плане выручила таблица RSTRAN, где имена источника и цели трансформации прописаны правильно, как надо.