World of SAP BI/BO

Demo of SAP BusinessObjects Data Services and SAP NetWeaver BW

2012-04-22T09:26:00.000-07:00

Step-by-step of how to setup and execute an SAP BusinessObjects Data Services XI 3.1 batch job load from a non-SAP source into SAP NetWeaver BW

How to find out total number of records in Multiprovider?

2011-10-10T02:03:00.001-07:00

In case of cube and DSo , you can go to manage screen and there you will get an idea, how many number of records transfered and how many added but in case of multiprovider , there is no such option to find out the total number of records.To find out the total number of records in a multiprovider , we can follow the below steps...go to the Multiprovider , navigate to display datathen ,select your

How to check the setting of flat file in BW

2011-10-03T01:52:00.000-07:00

To check the settings of your flat file , what format of flat file we can upload in bw side,we need to go for se11 , go to the RSADMINCV1,this a Maint. view with text BW: Settings for Flat Files..Simply execute this , you will get the settings , follow the below screen shotMadhu

World of SAP BI/BO: Treasury system business Content Cubes

2011-10-03T01:19:00.000-07:00

World of SAP BI/BO: Treasury system business Content Cubes

Treasury system business Content Cubes

2011-10-03T00:43:00.001-07:00

Mostly in treasury system is part of Finance like FI and CO.Under Treasury system we have different different sub-modules, those we are using for different requirements .To find the business content cubes , please follow the below navigations. RSA1---Business Content---Expand Financial Management & Controlling(0FMCO) InfoArea ,expand Treasury(0TR) IA, then you will be getting Cash Management(

Basic ABAP key words..

2011-09-21T07:59:00.001-07:00

String operations:v TranslateIt is a keyword used to change the case of the input string to another case.Syntax: translate a to lower casev concatenateIt is a keyword used to concatenate n no of strings.Ex: Parameters: a(10),B(10).Data c(20).Concatenate a b into c separated by space. It is not

Transport Tips in BW

2011-09-21T06:54:00.001-07:00

Transport SAP BW vs. R3 ..What is same….SAP BW allows you to transport your work– Configuration, Objects, Roles, and Business Explorer (BEx)objects– Records your development creation or changes– Moves objects & configuration to downstream systems• SAP BW uses change requests and tasks– Provides a change history log for an object• Transporting program objects – &

To display the alv using 'REUSE_ALV_HIERSEQ_LIST_DISPLAY' FM

2011-09-21T06:50:00.001-07:00

To display the alv in a different manner we have to pass some additional parameters.For the header as in the output maintain a separate internal table it_final_hdr.To get the code click on below link : BEGIN OF t_final_hdr,vkorg TYPE vbak-vkorg,vname TYPE tvkot-vtext(tvkot),kunnr TYPE vbak-kunnr,kname TYPE kna1-name1,expand,END OF t_final_hdr,i_final_hdr TYPE TABLE OF t_final_hdr.I_final is the

ABAP Basic Tips

2011-09-20T11:42:00.001-07:00

What is use of using HASHED TABLE? Hashed table is useful when your have to work with very big internal table and to read it with "READ TABLE WITH KEY ..." The time access is constant ! Definition of a Hashed Table: "Defines the table as one that is managed with an internal hash procedure. You can imagine a hashed table as a set, whose elements you can address using their unique key. Unlike

How to and what to check in your BW system before GO-Live

2011-09-20T10:02:00.001-07:00

How to and what to check in your BW system before GO-LiveBefore going to production your BW system ,please check the below things….StepsTransfer global settings. Goto Administrator Workbench -> Modeling -> Source Systems. Select an R/3 source system -> right-click and choose Transfer global settings. Select Currencies and choose a transfer mode.Simulation - The transfer of Customizing

How to create a Blinking Indicator in Xcelsius

2011-09-04T05:14:00.000-07:00

ABAP : Implicitly Enhancement Point

2011-07-15T23:52:00.000-07:00

Restricting To Update Vendor Number In MIGO for cross company purchase order Requirement We had a requirement that ………..When doing the initial Goods Receipt of a purchased or subcontracted good, the vendor field on the batch master (MCH1-LIFNR) should be populated with the relevant vendor number.If this batch at a later stage is once more part of a Goods Receipt – by a cross company purchase

SAP BI Share Knowledge For All Range of Topics

2011-07-15T23:47:00.000-07:00

If you want to share your SAP knowledge or get help from SAP experts worldwide on any type of topics then visit on the following forum. SAP Forum for all Range of Topics Your comments are valuable inputs for us-

Beginners Guide to Xcelsius: Part 2

2011-07-15T23:20:00.000-07:00

Xcelsius and Web Intelligence using XWIS

2011-07-15T23:19:00.000-07:00

Interview Questions and Answers for SAP BI

2011-06-02T07:47:00.000-07:00

1. How to use Virtual K.F/Char. ? Ans : This “virtual” characteristic is getting a value assigned at query runtime and must not be loaded with data in data target. Therefore, no change to existing update rules. The implementation can be divided into the following areas: 1. Create of InfoObject [Key Figure / Characteristics] and attach the InfoObject to

To populate filds dynamically in query

2011-06-02T06:40:00.000-07:00

Requirement Our requirement was , we were having one Ztable in Ecc and from Ecc we were fetching all the data upto standard dso in BI , and from some other source we are having data up to cube .In our flow we were having 4 ds including the above Ztable. All flow were independent.Like DS-WOP DSO-Std.DSO-CUBE , on top of all 3 cube we were having one Multiprovider, and we were having our query ,

Program to Download all the IOS and Ruletypes for a particular transformation ID

2011-06-02T04:09:00.000-07:00

Requirement: We have developed this program to down load all the info objects fields and rule types into Excel sheet to compare the objects between two server, our aim was everything sd be sync between both the server. This program will be helpful in many area. The program follows below. span { font-family: "Courier New"; font-size: 10pt; color: rgb(0, 0, 0); background: none repeat scroll 0%

How to check whether the query is already migrated to BI

2011-06-02T01:33:00.000-07:00

To check whether the query is already migrated to BI .By the field VERSION in table RSZCOMPDIR table we can identify .go to the table RSZCOMPDIR , there go to field COMPID , give your query name and execute .if in version field if value is <100the query is a 3.X query. If it is more than 100 query has been migrated to 7.X version.

Delta Update Methods in Logistic

2011-05-10T06:41:00.000-07:00

We have three delta update methods in Logistic. Direct Delta: With this update mode, the extraction data is transferred with each document posting directly into the BW delta queue. In doing so, each document posting with delta extraction is posted for exactly one LUW in the respective BW delta queues. Queued Delta: With this update mode, the extraction data is collected for the affected

Info Area

2011-05-02T05:00:00.000-07:00