Loading

Demo of SAP BusinessObjects Data Services and SAP NetWeaver BW

Posted by SAP BI-BO on Sunday, April 22, 2012


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

No Comments

How to find out total number of records in Multiprovider?

Posted by madhu on Monday, October 10, 2011

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 required selections,then check the check box output number of hits,make maximum number hits blank(all hits)please follow the below screen shot for more clarity..

Read More >>

2 Comments

How to check the setting of flat file in BW

Posted by madhu on Monday, October 3, 2011

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 shot














Madhu

No Comments

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

Posted by madhu

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

No Comments

Treasury system business Content Cubes

Posted by madhu

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(0TRCM) and Liquidity Planning(0TRLP) IA, expand those , you will be getting all Cubes and Mps..please try to install as per your requirements.
The business content Cubes and Multi providers available in BI side are as bellow
Under Cash Management IA , The underlying Cubes are
1:Planned Amounts---------------0TRCM_C01
2:Planned Amounts - Enhanced---0TRCM_C02
3:Current Planned Amounts------0TRCM_RC1
Multiprovider is
1:Planned Amounts - Comparison---0TRCM_MC1.
Under Liquidity Planning IA , underlying Cube is
1:Liquidity Planning: Actual Data----0TRLP_C01.

Please follow the below Screen shot for more details..

Read More >>

No Comments

Basic ABAP key words..

Posted by madhu on Wednesday, September 21, 2011

String operations:
<!--[if !supportLists]-->v <!--[endif]-->Translate
It is a keyword used to change the case of the input string to another case.
Syntax: translate a to lower case
<!--[if !supportLists]-->v <!--[endif]-->concatenate
It 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.

Read More >>

No Comments

Transport Tips in BW

Posted by madhu

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

Read More >>

No Comments

To display the alv using 'REUSE_ALV_HIERSEQ_LIST_DISPLAY' FM

Posted by madhu

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 :

Read More >>

No Comments

ABAP Basic Tips

Posted by madhu on Tuesday, September 20, 2011

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 standard and sorted tables, you cannot access hash tables using an index. All entries in the table must have a unique key.

Read More >>

No Comments

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

Posted by madhu

How to and what to check in your BW system before GO-Live
Before going to production your BW system ,please check the below things….
Steps
Transfer 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 tables/exchange rates is simulated. No data is updated.
Update tables - The Customizing tables/exchange rates are collected from the source system. The new entries are updated on the database.
Rebuild tables - The Customizing tables/exchange rates are collected from the source system. The tables are rebuilt, old data is deleted.
Then Execute.
Repeat these steps for Units of measurement, Fiscal year variants, and Factory calendar for each R/3 source system in BW.

Read More >>

No Comments

How to create a Blinking Indicator in Xcelsius

Posted by SAP BI-BO on Sunday, September 4, 2011

1 Comment

ABAP : Implicitly Enhancement Point

Posted by madhu on Friday, July 15, 2011

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 order, the vendor field should NOT be updated. The initial vendor number should be kept.
Suppose A: Vendor for company ABC and B and C are plant for ABC.
Suppose Plant B of ABC has order one material from A , in that case in MCH1 table , A will be updated as Vendor .

Read More >>

No Comments

SAP BI Share Knowledge For All Range of Topics

Posted by SAP BI-BO

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-

No Comments

Beginners Guide to Xcelsius: Part 2

Posted by SAP BI-BO

No Comments

Xcelsius and Web Intelligence using XWIS

Posted by SAP BI-BO

No Comments

Interview Questions and Answers for SAP BI

Posted by madhu on Thursday, June 2, 2011

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 the InfoProvider.
 2. Implementation of BADI RSR_OLAP_BADI (Set filter on Infoprovider while defining BADI implementation)
   3. Adding the InfoObject into the Query.
2. Query Performance Tips :
   Ans :
   i. Don’t show too much data in initial view of report output
   ii. Limit the level of hierarchies on initial view
   iii. Always use Mandatory variables
   iv. Utilize filters based on InfoProviders 
   v. Suppress Result rows if not needed
   vi. Eliminate or Reduce Not logic in query selection
3. DataStore Objects :
Ans      : Standard DSO – Max. 16 key fields can be created.

Read More >>

No Comments

To populate filds dynamically in query

Posted by madhu

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 , but even though Ztable flow was there in that flow but we dnt add the dso of Ztable flow in our Multiprovider.all the above flow were having profit center and Company code as key field , based on company code user was expecting all the Key figures from the Ztable but their intention was those KF IOs sd not be there in query .In that table around 20 KFS were there (User was not bother about the performance, also ).Company code was Mandatory and Single value in our selection, also currency was constant that is USD.
To achive this what I did , I have created one data source for that Ztable and loaded data upto standard DSO.
den Have created 20 formula variable processing type user exit .
and was achived the requirement .the sample code for one formula variable as follow .

Read More >>

No Comments

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

Posted by madhu

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.

*&---------------------------------------------------------------------*
*& Report ZY_DATA_DOWNLOAD_TRANS
*& Author:Madhusmita Jena
*& Date:17/05/2011
REPORT ZY_DATA_DOWNLOAD_TRANS.
*tables:RSTRANFIELD,
* RSTRANRULE.

Read More >>

No Comments

How to check whether the query is already migrated to BI

Posted by madhu

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 <100
the query is a 3.X query. If it is more than 100 query has been migrated to 7.X version.

No Comments

Delta Update Methods in Logistic

Posted by SAP BI-BO on Tuesday, May 10, 2011

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 application instead of being collected in an extraction queue, and can be transferred as usual with the V3 update by means of an updating collective run into the BW delta queue. In doing so, up to 10000 delta extractions of documents for an LUW are compressed for each DataSource into the BW delta queue, depending on the application.


Un-serialized V3 Update: With this update mode, the extraction data for the application considered is written as before into the update tables with the help of a V3 update module. They are kept there as long as the data is selected through an updating collective run and are processed. However, in contrast to the current default settings (serialized V3 update), the data in the updating collective run are thereby read without regard to sequence from the update tables and are transferred to the BW delta queue.

No Comments