Today i would like to share few of the differences that are generally asked during interviews and apart from that it is also good to know them as it could make your concept more clear in this domain when you are working.
Differences between SAP and BO| SNO | SAP | BO |
| 1. | Characteristic, Key Figure, Display attribute | Dimension, Measure, Detail |
| 2. | Characteristic Catalogue | Dimension Class |
| 3. | Key Figure Catalogue | Key Figure Class |
| 4. | Restrictions or Filters | Global Static Condition |
| 5. | Variables | Dynamic Prompt |
| 6. | Calculated Key Figure | Measures with Calculations |
| 7. | Restricted Key Figure | Measure with Dimension Restriction |
| 8. | Attribute Level Hierarchies | Default Hierarchy |
| 9. | Node Level Hierarchies | Custom Hierarchy |
| 10. | Exceptions | Alerts |
| 11. | Conditions | Report Level Restrictions |
| SNO | WEBI(Info View) | DESKI |
| 1. | It is a thin client/ half client | It is a thick client/full client |
| 2. | Info View supports only for the universes which are exported to the server( does not support for offline mode) | DeskI supports for the universes which are in the Local as well as which are present in the server. |
| 3. | Webi supports personal data files | DeskI also supports personal data files. |
| 4. | Extension for Webi is (.WID) | Extension for DeskI is (.REP) |
| 5. | The report created in the Webi cannot be saved in the Local system | The report created in the DeskI can be saved in the Local system |
| 6. | We cannot hide the column in the report created in Webi | We can hide the column in the report |
| 7. | Partially supports for Scope of Analysis | Fully supports for Scope of Analysis |
| 8. | Slice and Dice is not possible is WebI | Slice and Dice is possible in DeskI |
| 9. | Creation, modification, distribution, scheduling through web is possible. | Creation and modification from DeskI tool. Distribution and scheduling from Info view. |
| 10. | Drill across is not possible in Webi | Drill across is possible in DeskI |
Difference between WEBI and Crystal Reports.
| SNO | WEBI | CRYSTAL REPORTS |
| 1. | No need for any software installation in the Developer system | Software installation of client version of Crystal reports is a must in the Developer system |
| 2. | Need not install to install any integration kit to publish reports into the BO server. | Integration kit is mandatory to publish reports into the BO server. |
| 3. | Webi supports only for Universe and personal files. | Supports all the data sources. |
| 4. | Webi supports for ADHOC features | Crystal does not support ADHOC features |
| 5. | Webi supports for dynamic aggregation | Does not support dynamic aggregation |
| 6. | Dynamic drilling is possible | Dynamic drilling is not possible |
| 7. | Creation, modification, scheduling, and distribution from web portal (i.e Info view) is possible. | Distribution, scheduling is possible from web portal. But creation and modification in Crystal reports client. |
| 8. | Reports can be exported in PDF and Excel formats | Reports can be exported in Excel, PDF, Word, .CSV, Text, XML, Etc. |
| 9. | Supports up to 90,000 records in the report | There is no specific limit for the number of records in the report |
| SNO | WEBI | XCELCIUS |
| 1. | Supports only for Universe and personal data files | Supports for Universe, Webi, Crystal, XML, BEx |
| 2. | Developer need not install any software | Mandatory installation of client version in the Local system |
| 3. | Does not support for interaction features | Supports for interaction features |
| 4. | Supports for very few charts | Has many charts and components |
| 5. | Supports for up to 90,000 detailed records | Supports only 512 summarized records |
| 6. | Supports for ADHOC features and allows us to modify through web | Does not support for any ADHOC features |
| 7. | Creation, modification, scheduling, distribution from web portal (i.e. Info view) is possible | Creation and modification from Xcelcius. Distribution from Info view |
No comments:
Post a Comment