Showing posts with label Expert Routine. Show all posts
Showing posts with label Expert Routine. Show all posts

Useful ABAP Programs and Function Modules in SAP BI

Program name
RSCDS_NULLELIM Delete fact table rows where all Key Figure values are zero. See Note 619826.
RSDG_CUBE_ACTIVATE Activation of InfoCubes
RSDG_CUBE_COPY Make InfoCube Copies
RSDG_CUBE_DELETE Delete InfoCubes
RSDG_DODS_REPAIR Activation of all ODS Objects with Navigation Attributes
RSDG_ODSO_ACTIVATE Activation of all ODS Objects
RSDG_IOBJ_ACTIVATE Activation of all InfoObjects
RSDG_IOBJ_DELETE Deletion of InfoObjects
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
SAP_RSADMIN_MAINTAIN Add, change, delete RSADMIN table entries
CUBE_SAMPLE_CREATE A fast way to put some "sample" records in a InfoCube. No need to use Flatfiles,
just enter the value in a ALV-Grid or let fill the Cube with random value.
SAP_CONVERT_NORMAL_TRANS Convert BasisCube to Transactional Cube and the opposite way around.
Listed below are some of the frequently used 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
RSDRI_INFOPROV_READ
RSDRI_INFOPROV_READ_DEMO 
RSDRI_INFOPROV_READ_RFC
Used to read Infocube or ODS data through RFC
DATE_COMPUTE_DAY 
DATE_TO_DAY
Returns a number what day of the week the date falls on.
DATE_GET_WEEK Will return a week that the day is in.
RP_CALC_DATE_IN_INTERVAL Add/Subtract Years/Months/Days from a Date.
RP_LAST_DAY_OF_THE_MONTHS 
SLS_MISC_GET_LAST_DAY_OF_MONTH
Determine Last Day of the Month.
RSARCH_DATE_CONVERT Used for Date Converstions. We can use in Info Package routines.
RSPC_PROCESS_FINISH    To trigger an event in process chain
 DATE_CONVERT_TO_FACTORYDATE Returns factory calendar date for a date
 CONVERSION_EXIT_PDATE_OUTPUT Conversion Exit for Domain GBDAT: YYYYMMDD  -> DD/MM/YYYY
 CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal
CONVERSION_EXIT_ALPHA_OUTPUT Conversion exit ALPHA, internal->external
 RSPC_PROCESS_FINISH Finish a process (of a process chain)
RSAOS_METADATA_UPLOAD Upload of meta data from R/3
RSDMD_DEL_MASTER_DATA Deletion of master data
RSPC_CHAIN_ACTIVATE_REMOTE To activate a process chain after transport
                        
USEFUL ABAP-CLASS in NW 7 - BI to fix problems with Transformation
Class CL_RSTRAN_STAT Description
DELETE_VERSION_FROM_DB (Static Method) For deleting the transformation version from database, helpful if the transformation metadata are corrupted.
DELETE_RULE_FROM_DB For deleting a given rule of transformation

MAINTAINING DATA QUALITY IN BW USING ERROR STACK

By:Ramakrishna Gattikoppula (Infosys) Article (PDF 255 KB) 10 August 2010


OVERVIEW
This Article explains the different ways in which the incorrect data records can be moved to error stack when the data record is processed in the routines(Start, End, Characteristic or Expert Routines) of Transformation (In this case a data record is marked as incorrect based on Customer-specific requirements or Conditions).

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ebeb43-9e8a-2d10-b28e-825c0142ad4f?QuickLink=index&overridelayout=true

HOW TO USING EXPERT ROUTINE IN TRANSFORMATION

By: P Renjith Kumar SDN Article (PDF 382 KB) 18 August 2010

OVERVIEW
This document will give you a basic overview of creating an expert routine in transformation.


http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a056f726-59eb-2d10-9db3-eb11f0c1e9e4?QuickLink=index&overridelayout=true