Demo of SAP BusinessObjects Data Services and SAP NetWeaver BW
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?
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..
How to check the setting of flat file in BW
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
Treasury system business Content Cubes
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..
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..
Basic ABAP key words..
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.
Transport Tips in BW
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
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 :
ABAP Basic Tips
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.
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.
How to and what to check in your BW system before GO-Live
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.
