Formulas In Excel for Various BO Dashboard / Webi / Crystal Reports Formulas.

MS Excel Formulas for formatting of data as input to Xcelsius 2008.

1.Maximum =MAX(A2:A9)
2.Minimum =MIN(A2:A9)
3.Rank =RANK(C2,$C$2:$C$12)
4.Match =MATCH(F3,$A$2:$A$16,0)
5.Index =INDEX($B$2:$B$16, F12)
6.=IF($B$2=1,C5,IF($B$2=2,C6,IF($B$2=3,C7,IF($B$2=4,C8,"")))) : If you have 4 Records according to index.

Excel Format Cells:
Number
Currency...
1.Custom - >Type

Eg: #,##0.00

#,##0.00;[Red]#,##0.00

To show different Colors for Positive & Negative values
[Blue]#,##0.00;[Red]#,##0.00

all the numbers until first first semicolon will be positive and Blue in color rest of the numbers will be in Red

i.e., Eg: I

1543
-543

Eg: II 500 Blue #,##0.00; 500#,##0.00

---------------------------------------------------------------------
Crystal Reports Formulas:

INT((CurrentDate - tblemployees.DOB)/365.25)

[tblemployees.Surname]&" "&[tblemployees.First Name]

Comments

srinivasyadav said…
Hi friends can any one help me in integrating the Business objects with
SAP/BI What are the steps can any one
help me in sending the step-by-step process document which helps me to integrate the sap/bi and bo I will be
waiting for your reply this is my id
srinivasyadav.mba@gmail.com plzzzz send me the stepssss and how to set the passwords do we need to install
oracle also what are the services do we need to start after integration can you send me screen shots of integration so that it will be helpfull to me
April 1, 2011 at 7:54 AM
srinivasyadav said…
can any one send me extraction steps for MM,HR,SCR,FISL,COPA AND IN WHICH SCENARIO DO WE GO FOR THIS MODULES AND WHY WE EXACTLY GO TO THESE MODULES CAN ANY ONE HELP ME IN SENDING SOME SCENARIOS WITH STEP-BY-STEP AND HOW TO SCHEDULE THEN IN PROCESS CHAINS THIS IS MY ID G.SRINIVAS63@GMAIL.COM , SRINIVASYADAV.MBA@GMAIL.COM
April 1, 2011 at 8:10 AM
Quran Transliteration said…
Hi Srinivas,

I am glad to hear you, as you are asking the very basic questions.

I am giving suggestions, if you have come across several modules in sap ERP & Its lifecycles if User/Customer wants to see well formatted/Interactive reports for Decision support using sap bi / BO we can develop reports based on several modules data by extracting to sap bw.

Find some info@: http://expertisesapbi.blogspot.com/2010/12/sap-r3-or-ecc-reporting-limitations.html

http://expertisesapbi.blogspot.com/2010/06/fi-extraction-fi-module-deals-with.html
http://expertisesapbi.blogspot.com/2010/06/one-stage-stop-to-know-all-about-bw.html

Truely i wouldn't maintain any screenshots of integration / Installation of BO. Could not help you.

Thank you,
Subani Shaik.
April 22, 2011 at 12:38 PM
Post a Comment

Popular posts from this blog

One stage stop to know all about BW Extractors-Part1

Image
Types of Extractors:               Application specific BW content extractors: Lo Extraction: Logistics refers to the process of getting a product or service to its desired location upon request which involves transportation, purchasing, warehousing etc. Main areas in logistics are: Sales and Distribution (SD) : application 11, 13, 08 (in LBWE T-code) Materials Management (MM) : application 03, 02 Logistics Execution (LE) : application 12 Quality Management : application 05 Plant Maintenance (PM) : application 04, 17 Customer Service (CS) : application 18 Project System (PS) : application 20 SAP Retail : application 40,43,44,45 How the data extraction happens? Extraction can be done using either Full update/delta update. Full load: Incase of logistic application, Full/Initiali
Read more

COPA Extraction Step By Step in SAP BW

Image
COPA Extraction Step by Step: SAP R/3 or SAP ECC: 1. SAP R/3 or ECC goto T.Code KEB0 , In Function: Select Create  Control Parameters: Provide a New CO-PA DataSource Name:1_CO_PA%CL%ERK 2. Select your O perating C oncern, e.g.,IDES. 3. Select radio button Costing-based or Account-based as OC . 4.Select field names for partitioning.e.g. BUKRS (Company Code), Check 5.Click on Info Catalog (F7) 6. Select the Characteristics & Value fields & Keyfigures 7. Select the Package/Development Class for Workbench request 8. Edit your DataSource to select/Hide fields, Save. Datasource created successfully. 9. Extractor Checker or RSA3, extraction. SAP BW:   1. Replicate DataSource 2. Assign InfoSource 3. Transfer all the datasource elements to an InfoSource 4. Activate InfoSource 5. Create a InfoCube (Copy Str from InfoSource) 6. Create Dimension & Define and Assign it. 7. Check & Activate. 8. Create Transformation (Insert or Modify KF
Read more

How does a datasource communicates "DELTA" with BW?

Image
SAP R/3 or ECC DataSource Delta mechanism for SAP BW/BI What is Delta? It is a feature of the extractor which refers to the changes(new/modified entries)occured in the source system. How to identify? In ROOSOURCE table, key in the data source name and check the field "DELTA". If the field is left blank,it implies that the datasource is not delta capable. The field 0RECORDMODE in BW determines how a record is updated in the delta process. Now the question is how this delta will be brought to BW? Using one of the following ways: ABR: After before and Reverse image AIE: After image ADD: Additive image ABR: After before and Reverse image Example: Logistics What is it? Once a new entry was posted or an exiting posting was changed at R/3 side, an after image shows the status after the change, a before image shows the status before the change with a negative sign and the reverse image also shows the negative sign next to the record while indic
Read more