Check this out a good presentation from SAP on what's New in SAP BW 7.2
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0ea8b43-26af-2c10-f1b5-bbb69060de87?QuickLink=index&overridelayout=true
Enjoy !!!
Dec 30, 2009
Dec 18, 2009
Using If-Then-Else in Bex
Conditional Calculations (IF-THEN-ELSE)
You can make conditional calculations using Boolean operators An expression in the form
IF
Example: IF Actual Costs > Plan Costs THEN Plan Costs + Plan Deviation ELSE Actual Costs
can be written as the following formula:
(Actual Costs > Plan Costs)* (Plan Costs + Plan Deviation) + (NOT (Actual Costs > Plan Costs)) * Actual Costs
or
(Actual Costs > Plan Costs)* (Plan Costs + Plan Deviation) + (Actual Costs <= Plan Costs) * Actual Costs
Dec 2, 2009
SAP Notes that are helpful....for BI
SAP Notes
# 79483 - MM-IM: Creating the moving average price.
# 185961 - Moving Average Price Calculation
Will be added once in a while...
Will be added once in a while...
Nov 7, 2009
Important BI Related Links.
1. The 60 Character Restriction for BW Data Models - Blog :
2. BEX Query Designer - SAP Library :
3. Attribute change run - Blog :
4. SAP Standard Reports in R/3 - Wiki :
5. BI Content for Inventory Management - SAP Library :
6. BI Content for GL Accounting - SAP Library :
7. BI Content for New GL Accounting - SAP Library :
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
@ http://rapidshare.com/files/241712338/How_to_Integrate_Custom_Formulas_into_the_Formula_Builder.pdf
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
@ http://rapidshare.com/files/241710763/Periodical_Jobs_and_Tasks_-_Oracle.ppt
Realtime Data Acquisition
Realtime Data Acquisition
@ http://rapidshare.com/files/241708811/Realtime_Data_Acquisition.ppt
Reporting Performance in BI 7.0
Reporting Performance in BI 7.0
SAP SEM BPS Interview questions
@ http://rapidshare.com/files/241717161/SAP_SEM_BPS_Interview_Quest.pdf
About Event ID Downloads
@ http://rapidshare.com/files/241715948/What_You_Should_Know_About_Event_IDs_download.doc
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.
- 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
• 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…
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.
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.
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.
· 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.
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.
Sep 8, 2009
BI Tip # 2
To check whether your query is migrated to SAP BI7 version already
Check the Table RSZCOMPDIR: Enter your Query Technical Name as input to the field COMPID and execute.
If Field VERSION in the Table RSZCOMPDIR has the value less than 100 that means Query is in 3.x version. If it is more than 100 means, it is already migrated.
Raj
Check the Table RSZCOMPDIR: Enter your Query Technical Name as input to the field COMPID and execute.
If Field VERSION in the Table RSZCOMPDIR has the value less than 100 that means Query is in 3.x version. If it is more than 100 means, it is already migrated.
Raj
Process Chains
Hi,
Here i am providing you some links which best explain how to create process chain step by step
Step by step procedure to create process chain by Jeurgen
https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/8280
For Creating Process chain Step by step:
http://help.sap.com/saphelp_nw70/helpdata/en/67/13843b74f7be0fe10000000a114084/content.htm
For maintianing Pc:
http://help.sap.com/saphelp_nw70/helpdata/en/d3/53e03b8235953ee10000000a114084/content.htm
For all other info abt PC:
http://help.sap.com/saphelp_nw70/helpdata/en/8f/c08b3baaa59649e10000000a11402f/content.htm
Excellent Article on Process Chain Tips (with screenshots)
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/00a1f389-ec7c-2c10-04bc-9d81b3084171
Hope It Helps,
Sep 7, 2009
Free and Formal SAP Learning
Source : https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/15407
I don’t know about you, but sometimes I need to know the immediate answer to an immediate problem. Sometimes I turn to the SAP Community Network, to find the answer; at other times I look to Google. It depends on the problem and the context. Of course, the results that you find on Google are not necessarily verified – you take your chances with every keystroke.
Here on SCN, thanks to the generosity of the community, there is all manner of free learning. For example:
· In this blog, Arun Varadarajan shows us how to use SQL to access SAP BW data
· In this wiki, I can quickly access Business Intelligence best practices, articles, blogs and forums as well as SAP Help
The good thing about this content is that others from the community have the opportunity to review it. While this is not necessarily a guarantee, it does give you the opportunity to check whether a particular approach has been commented on, verified, adjusted or even discredited.
At other times, our learning needs may be more formal. We may need to take a class for a deep dive into a particular topic. For example, I may be needing to understand the new enterprise data warehousing functions in SAP NetWeaver 7.0 BW and decide to enrol in this Delta course. Alternatively, this five hour SAP eLearning course may just give me enough of a BW overview to get on with my job. And while I am doing the course, I might just keep my boss busy by downloading a few of the free business intelligence papers available in the Free Content section of Leaning on Demand by SAP.
Whatever your learning needs, there are plenty of free and formal options. The challenge is not finding content that satisfies your learning or skilling needs, but integrating these into your personal career development plan.
In upcoming blog posts, I will be sharing with you some tips for doing this by creating your own personal learning environment (PLE). Using a PLE you can begin to take control of your learning and career development by integrating all these different types of learning content in a way that supports your own career aspirations.
Gavin Heaton is a Business Development Manager working on Learning on Demand by SAP.
Sep 5, 2009
SAP Certification... Does it Matter ?
Hi,
There is lot of fuss about SAP Certification… does it really matter ?
Read along…
http://it.toolbox.com/blogs/saptraining/sap-certification-does-it-matter-32968
Sep 4, 2009
LO Extraction - Steps
Step by step procedure in below thread:
https://www.sdn.sap.com/irj/sdn/thread?threadID=395477
Also go through this link to know the procedure step by step
http://www.sap-img.com/business/lo-cockpit-step-by-step.htm
To understand LO extraction go through these weblogs by Roberto
https://weblogs.sdn.sap.com/pub/wlg/1096
https://weblogs.sdn.sap.com/pub/wlg/1106
https://weblogs.sdn.sap.com/pub/wlg/1183
https://weblogs.sdn.sap.com/pub/wlg/1262
https://weblogs.sdn.sap.com/pub/wlg/1522
For advantage of LO over LIS, go through this thread
https://www.sdn.sap.com/irj/sdn/thread?forumID=132&threadID=61546&messageID=650080
BI content installation:
http://help.sap.com/saphelp_nw2004s/helpdata/en/c1/ea683cc5e8ca68e10000000a114084/frameset.htm
Check below thread for more info:
https://www.sdn.sap.com/irj/sdn/thread?threadID=741682
To Install a BC:
Go to the Business content Tab in RSA1 or directly to the T-code RSORBCT.
Select the object you want to install(infocube/DSO/Cube etc). Bring this object in the right hand side of the screen and click on install button.It will be installed and you can see this object in RSA1 now
Welcome
Hi,
Welcome to the SAP BW world ... of Rajesh Salecha.
This blog is intended for some special purpose of collecting Knowledge of SAP BW from various sources...
If someone is intereseted in posting do let me know and i'll add you as author.
Regards
Rajesh Salecha
rsalecha@Gmail.com
Welcome to the SAP BW world ... of Rajesh Salecha.
This blog is intended for some special purpose of collecting Knowledge of SAP BW from various sources...
If someone is intereseted in posting do let me know and i'll add you as author.
Regards
Rajesh Salecha
rsalecha@Gmail.com
Subscribe to:
Posts (Atom)