All about.... SAP BW / BI Data Load Performance Analysis and Tuning
Posted by Sharath Labels: aggregates, BI, BW, cache, End Routine, global, infoset, load performance, multiprovider, performance, Start Routine, statisticsUseful ABAP Programs and Function Modules in SAP BI
Posted by Sharath Labels: End Routine, Expert Routine, SAP BI ABAP, SAP BI INTERVIEW QUESTIONSProgram 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. |
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
Posted by Sharath Labels: BI, End Routine, Expert Routine, Extraction, Start Routine, Supporting IssuesBy: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
Posted by Sharath Labels: BI, End Routine, Expert Routine, Extraction, Routines, Start RoutineBy: 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