Posts

Showing posts from June, 2010
Report: RSDG_ODSO_ACTIVATE To Activate or Check Consistencies without Transport .

An Issue after The UpGradation of SAP GUI or MS Office 2003/2007

Issue 1# I get an "I18N Initialization" dialog that says "Could not open libsapu16vc71.dll" which appears everytime, this states that the application is terminating. This happens when I try to expand the "SAP Systems" node in MMC, which was previously worked fine. For this Just Search for the file libsapu16vc71.dll in SAP installed drives . Copy this file and Paste in location Drive:\Program Files\SAP\Common Files: librfc32.dll or Drive:\WINDOWS\System 32\libsapu16vc71.dll. Once this Shared file can locate, The SAP MMC Allowed to Start the Server. This way i fixed it..! Issue 2# BI BEx Analyzer Not working after upgrade or Reinstall ( SAP Gui - Office 2003/2007) If the above error resolve, some times BI BEx Anal yzer or Query Designer will not work. For that, you can get an BExAnalyzer.exe file, Delete the file where i got installed on server and replace with BExAnalyzer.exe file from installati

A way to Find out Whether a R/3 field is already transferred to BW/BI

Image
When executing a fit/gap analysis (are all necessary R/3 fields already extracted and transferred to BW), table RSOLTPSOURCEFIE can be used. Within the selection screen you can enter, for example, R/3 field MATNR if you want to know in which datasources MATNR is used. The screenshot below shows the overview of all datasources which use R/3 field MATNR : To see, per datasource/transfer structure, to which infoobject the R/3 field is mapped, table RSTSFIELD can be viewed. In the screengrab below you can see that R/3 field MATNR is mapped to infoobject 0MATERIAL within several transferstructures/datasources.

Re-set a FULL LOAD to FULL REPAIR LOAD mode

When executed a full load to a delta enabled target, the next delta request cannot be activated anymore. (The full load is hampering this) Solving this issue by deleting this full load can be a solution, but it's easier to reset the full load to a full repair load. The latter can be accomplished by executing report RSSM_SET_REPAIR_FULL_FLAG. (Tcode: SA38 -> RSSM_SET_REPAIR_FULL_FLAG)

Analyzing Throughput Times Process Chains

Image
To analyze your process chains in SAP BI (but also other BI elements, SAP provides the program /SSA/BWT . How to use:  Select 1st Radio Button after running the program in SA38. : http://wiki.sdn.sap.com/wiki/display/BI/BW+Tools for more info..! Enter the technical name of the process chain to be analyzed: In the following screen you can see all details of the different process chain runs, but also compare different process chain runs with each other. This program is very useful when you want to analyse why a certain process chain is taking longer.

Types of DSOs in SAP BI and New Terminology

Image
SAP BI Terminology has been changed: With SAP NetWeaver 7.0, the following terminology changes have been made in the area of Warehouse Management: The Administrator Workbench is now called Data Warehousing Workbench . The ODS object is now called DataStore object . The transactional ODS object is now called DataStore object for direct update . The transactional InfoCube is now called real-time InfoCube . The RemoteCube, SAP RemoteCube and virtual InfoCube with services are now referred to as VirtualProviders . VirtualProvider: Based on a data transfer process and a DataSource with 3.x InfoSource: A VirtualProvider that allows the definition of queries with direct access to transaction data in other SAP source systems. Based on a BAPI: A VirtualProvider with data that is processed externally and not in the BW system. The data is read for reporting from an external system, by using a BAPI. Based on a function module: A VirtualProvider without its own physical data store in

How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License

Image
How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License Can we Transfer the Reports/Data from SAP-System to Non-SAP system without additional Cost/License?. Yes, we can transfer using with simple FTP/SFTP. Is it required any additional License or additional Cost? No. Is there any complex Coding or Configuration required?. No, it is very simple. How Can I transfer the Report/Data?. Here I'm considering SAP-BW system running in UNIX operating system and Windows XP as Non-SAP System. Source : SAP-BW System running on UNIX. Destination : SQL-Server running on Windows XP. Scenario: I have data in SAP-BW System, e.g. InfoCube 0SD_C03. And 0SD_C03 is having some reports and want to transfer the reports data to SQL-Server running on Windows XP. Else You may need to transfer ECC Data to SQL-Server running on Windows XP. For this also you can use the same logic. Here are the steps... Set the Variable values using fixed restricti

Generic Extraction via Function Module

How does the extraction API work in case you are extracting data using a self defined function module with generic delta? Sometimes, if your application or requirement makes it necessary, you have to create your own function module to extract the data from whatever sap system to bw. Therefore you normally make a copy of the standard fm 'RSAX_BIW_GET_DATA_SIMPLE'. To make this new function work for you, you have to realize the following. 1) The FM gets called by the extraction API for at least 2 times. First time is for initialization and from the 2nd time on it is for data extraction. 2) Right after the last data package (somehow you need to make sure that it is the last one) you have to raise the exception no_more_data. Example with lots of comments FUNCTION RSAX_BIW_GET_DATA_SIMPLE. *"-------------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" VALUE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUN