Difference b/w SAP BusinessObjects Web Intelligence (WEBI) Reports, Crystal Reports and Crystal xcelsius ?

'ALL' IN @Prompt('Enter a value or All', 'A', 'Class/Object', Multi,)

table.column in @prompt('Enter value or All', 'A', 'Class\Object',Multi,)

The Datasource for Xcelsius is not limited to excel, it can fetch data through some data connectivity components like Web service, Live Office connection, SAP connection, many more……

The main difference between teh BusinessObjects Web Intelligence(WEBI), Crystal Reports and Xcelsius is BusinessObjects Web Intelligence(WEBI) and CR are reporting tools and Xcelsius is a Dynamic Dashboard tool where we can provide a What-If scenario to the end-user.

The output of the reports in BusinessObjects Web Intelligence(WEBI) and Crystal Reports are limited to pdf, word etc.. but Xcelsius gives output as all the above mentioned formats and a unique format .swf (a flash file).

In BusinessObjects Web Intelligence(WEBI) and Crystal Reports we can find the page refresh rate where as in Xcelsius we have buffered data. The advantage with this is unecessary hits to the server may be reduced.

Both BusinessObjects Web Intelligence(WEBI) and Crystal Reports cant competate Xcelsius in Look and Feel. Xcelsius has some rich features and some color blends.

BusinessObjects Web Intelligence(WEBI) and Crystal Reports can hold huge data, but Xcelsius cannot hold bulk data. At runtime it shows the performance degrade and sometimes throws action script errors.

There will be no ground work in BusinessObjects Web Intelligence(WEBI) and Crystal Reports in making data for charts but where as in Xcelsius we have to do lots and lots of ground work in the Excel sheet.

BusinessObjects Web Intelligence(WEBI) reports the source file has to be universe, where
in crystal report source file can be anything, like universe, views, excel sheet etc, and for xcelsius the source file has to be only Excel sheet, and it also can take data live by using Live office and query as a web service.

The main point:
Through Xcelsius we can import data fro0m BusinessObjects Web Intelligence(WEBI) and Crystal Reports through Live Office connector.

SAP BusinessObjects Crystal Reports:

1. You need to do highly formatted reports “canned” reports. These are often statements, financial stuff, bills, invoices, mail merge. More often than not these will be piped into infoview or scheduled out to people.

2. You need lots of flexibility in exporting the reports out – Crystal has multiple export formats.

3. You need to connect to non standard datasources, things like java beans, web services, and proxy logs.

4. You need the ability to very complex functions in a report – Crystal formula language is much more powerful than BusinessObjects Web Intelligence( SAP BO WEBI Reports)`s. On the other hand this ability can also be achieved in BusinessObjects Web Intelligence( SAP BO WEBI Reports) in conjunction with Universe.

Comments

Anonymous said…
Thanks for sharing this Information. Got to learn new things from your Blog on SAP HANA

http://thecreatingexperts.com/category/sap-hana-training-in-chennai/

contact 8122241286
August 2, 2017 at 4:49 AM
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

Generic Extraction via Function Module

How does the extraction API work in case you are extracting data using a self defined function module with generic delta? Sometimes, if your application or requirement makes it necessary, you have to create your own function module to extract the data from whatever sap system to bw. Therefore you normally make a copy of the standard fm 'RSAX_BIW_GET_DATA_SIMPLE'. To make this new function work for you, you have to realize the following. 1) The FM gets called by the extraction API for at least 2 times. First time is for initialization and from the 2nd time on it is for data extraction. 2) Right after the last data package (somehow you need to make sure that it is the last one) you have to raise the exception no_more_data. Example with lots of comments FUNCTION RSAX_BIW_GET_DATA_SIMPLE. *"-------------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" VALUE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUN
Read more