Oct 22, 2009

BI Tip - Load Monitoring Table..

Did you explore table RSSTATMANPART? –

Do you struggle every day while doing data load status monitoring and reporting? Did you ever thought of checking table RSSTATMANPART?

Check the “Manage” tabs of multiple Targets or InfoProviders together ? Use the table RSSTATMANPART to obtain the same. This data will tell you whether the load to the target was successful or not & also will let you know whether the target is reportable or not.

I happen to come across couple of interesting content covering it on SDN, sharing for your reference –

This one is ABAP code for status monitoring

Other one is the link of one of the forum thread –

Needless to say try it on Sandbox / IDES system before going forward.

Happy Learning.

Oct 8, 2009

BI E-files

SAP BW related E-Files at your service.... you can add more in comments


CRM


Process Chain Architecture


Process Chains Error Handling


CRM Middleware Overview


CRM Communication


Data EXchange


Data EXchange with BI


BI JObs Monitoring & Admin


CRM Middleware


CRM Service


CRM Service


CRM


CRM


CRM Periodic Jobs


BI Data Modeling


SAPPIRE - 2008 - BO


SAPPIRE - 2008 - BO


SAPPIRE - 2008 - BO


ABAP Certification


BI 7.0 Admin Cockpit


BI 7.0 Intro


FLat File Loading Process with screen shots


BI 7.0 Admin Cockpit


BI Roadmap


BO INterview Questions


BW Traning


BW Traning


BW Traning


BW Traning


BW Traning


BW Traning


BW Interview Questions


BW Security


Analysis Authorization


BW System COPY


BI Basis Configuration - Must Download


CRM - BDOC


Business Planning


Crystal Report Interview Questions


Xcelsisus Presentation


Crystal Reports Training PPT


DTP Process - Must Download


DTP Process II - Must Download


DSO(ODS)- Must Download


SAPTIPS Issue


Workload Trace -Must Download


BPS-SEM


BI 7.0 Extraction I- Must Download


BI 7.0 Extraction I- Must Download


BI 7.0 Data Source- Must Download


GLOBAL 24/7 By BW


Customes Formula in Formula Builder


Variable Value


Design Netweaver Landscape


BI Reload from DSO to Cubes - BW Basics


Business Planning and Consolidation – Architecture, Functionality, and Roadmap


SAP Business Planning and Consolidation 7.0 – Hands-On Exercises for Business Planning


SAP Business Planning and Consolidation 7.0 – Hands-On Exercises for Business Planning-Excerise


WEB INTELLIGENCE - Must Download


ABC 101 With Business Objects Profitability and Cost Management


Integrating Business Planning and Consolidation with SAP ERP and SAP NetWeaver


Native Microsoft Excel 2007 Integration with SAP NetWeaver Business Intelligence 7.0


SAP Business Planning and Consolidation 7.0 and SAP NetWeaver – Enhancements and Features


IM210 SAP NetWeaver BI Scenarios with Xcelsius & Visual Composer

IP Modelling Samples

KPI Monitoring

Migration from 3.1 / 3.5 to 7.0

Modelling of SEM-BPS Cubes

Monitoring the Hierarchy ACR

Performance Management Analysis Tool


Periodic Jobs in BW - Must Download


Periodic Jobs in Oracle - Must Download


BIA

ABAP program in Process Chain

Add Attributes from COPA Derivation Table

Background Job monitoring with SAP

Configuring RFC in BI7 for connecting to ECC6 server

Creating Partitions in SAP BW

Crystal Report Interview Ques & Ans

Custom Formula Builder

Using Demo content available on SDN

EP & BI Integration

How-to Setup  Generic Delta

Enhancing GL Extractor & Performance Issue

How-to Compress Infocubes

How-to Debug COPA Extractions

How to Find BW Related Tables

How-to Guide on Transformation

How-to: Research and use of SAP Variable Exits

How-to: Transfer Hierarchies between BW Systems

Transporting TR in BW

Variables offsets in BEX

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enjoy !!!

Sep 23, 2009

BI Tip : Replicate Single DataSource

Replicate Single DataSource

- Use RSAOS_METADATA_UPLOAD function module to replicate single datasource. Logical system - put in field I_LOGSYS OLTP datasource name - put in field I_SOURC. and execute.

Trust you shall check this in Sandbox / Development System first.

Sep 18, 2009

List of the frequently used Function Module in SAP BW.

List of the frequently used Function Module in SAP BW.

1.RRMX_WORKBOOK_DELETE: Delete BW Workbooks permanently from Roles & Favorites

2.RRMX_WORKBOOK_LIST_GET: Get list of all Workbooks

3.RRMX_WORKBOOK_QUERIES_GET: Get list of queries in a workbook

4.RRMX_QUERY_WHERE_USED_GET: Lists where a query has been used

5.RRMX_JUMP_TARGET_GET: Get list of all Jump Targets

6.RRMX_JUMP_TARGET_DELETE: Delete Jump Targets

7.MONI_TIME_CONVERT: Used for Time Conversions.

8.CONVERT_TO_LOCAL_CURRENCY: Convert Foreign Currency to Local Currecny.

9.CONVERT_TO_FOREIGN_CURRENCY: Convert Local Currency to Foreign Currency.

10.TERM_TRANSLATE_TO_UPPER_CASE: Used to convert all texts to UPPERCASE

11.UNIT_CONVERSION_SIMPLE: Used to convert any unit to another unit. (Ref. table: T006)

12.TZ_GLOBAL_TO_LOCAL: Used to convert timestamp to local time

13.FISCPER_FROM_CALMONTH_CALC: Convert 0CALMONTH or 0CALDAY to Financial Year or Period

14.RSAX_BIW_GET_DATA_SIMPLE: Generic Extraction via Function Module

15.RSAU_READ_MASTER_DATA: Used in Data Transformations to read master data InfoObjects

16.RSDRI_INFOPROV_READ

17.RSDRI_INFOPROV_READ_DEMO

18.RSDRI_INFOPROV_READ_RFC: Used to read Infocube or ODS data through RFC

19.DATE_COMPUTE_DAY

20.DATE_TO_DAY: Returns a number what day of the week the date falls on.

21.DATE_GET_WEEK: Will return a week that the day is in.

22.RP_CALC_DATE_IN_INTERVAL: Add/Subtract Years/Months/Days from a Date.

23.RP_LAST_DAY_OF_THE_MONTHS

24.SLS_MISC_GET_LAST_DAY_OF_MONTH: Determine Last Day of the Month.

25.RSARCH_DATE_CONVERT: Used for Date Converstions. We can use in Info Package routines.

26.RSPC_PROCESS_FINISH: To trigger an event in process chain

27.DATE_CONVERT_TO_FACTORYDATE: Returns factory calendar date for a date

28.CONVERSION_EXIT_PDATE_OUTPUT: Conversion Exit for Domain GBDAT: YYYYMMDD - DD/MM/YYYY

29.CONVERSION_EXIT_ALPHA_INPUT: Conversion exit ALPHA, external->internal

30.CONVERSION_EXIT_ALPHA_OUTPUT: Conversion exit ALPHA, internal->external

31.RSPC_PROCESS_FINISH: Finish a process (of a process chain)

32.RSAOS_METADATA_UPLOAD: Upload of meta data from R/3

33.RSDMD_DEL_MASTER_DATA: Deletion of master data

34.RSPC_CHAIN_ACTIVATE_REMOTE: To activate a process chain after transport

Source: Viral Shah

List of the frequently used ABAP Programs in SAP BI

List of the frequently used ABAP Programs in SAP BI


• 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 InfoCubes 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 Statistics 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 Temporary 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 Flat files, just enter the value in a ALV-Grid or let fill the Cube with random value.

• SAP_CONVERT_NORMAL_TRANS: Convert Basis Cube to Transactional Cube and the opposite way around.

received from : Viral Shah

BI Tip # 6 - RSZDelete

Most of you are aware of RSZDelete tcode, but lot of them face the issue of how to delete enmass queries on one infoprovider or something in multiples. Well the answer is in same tcode.
For E.g.: You need to delete 10 queries out of 20 based on a infocube. Normally , developer tend to delete one by one. But you can delete multiple queries also.
Infocube : ZSD_C03
Total Queries : 25
To Delete : 15

In RSZDelete,
Type = REP
Infocube = ZSD_C03

Execute….
You get list of all queries….. select the one that requires to be deleted.

PS: This is an extremely DANGEROUS Transaction… Please use responsibly…

Sep 15, 2009

BI Tip # 5

RSICCONT is a table used to delete the request of a data target including DSO or Cube. Facing any problem in deleting the request from a DSO or a cube while loading the data. Try this.

Needless to say try it on Sandbox, development system before attempting on production environment.

Sep 14, 2009

BI Tip # 4

Worried about Data Loss while changing extract structure, why not try this?

Run the Report RMCSBWCC before doing changes to the LO extract structure or while importing any changes done to the extract structure.

This report checks whether any of the clients in the system contains data in the V3 update (Extraction queue) for that application (specific to extract structure provided as input). If there is data in V3 updates then you need to start the update for that application. Without doing this you will not be able to change the extract structure and if you are importing the changes then you may end up losing data.

BI Tip # 3

Couple of interesting tricks -

· RSDG_MPRO_ACTIVATE is a program to activate the Multi providers in production system directly. If there are any inactive MultiProviders due to some transport or any other reason, this will activate the Multiprovider without affecting reporting.
Needless to say try it on Sandbox, development system before attempting on production environment.

BI Tip # 1

Struggling… as there is no sample data for your newly developed Infocube, why not try this?

Try using ABAP program CUBE_SAMPLE_CREATE. It allows you to enter required sample data directly into your cube without using any flat files, source system configuration etc. Records are added to the cube in one request using the APO interface without monitor log.

Try exploring even further with all the options available there.

Needless to say try it on Sandbox, development system before attempting on production environment.