Filters in Web Intelligence

Different Types of Filters in Webi. They are as follows

Query Filters: Query Filters: Single and Multi-valued Filters
Single ----- Query Filter Condition ------ Equal To

Multi Valued Filters ----- Query Filter Condition ----- LOV’s

Prompted Filters ------ Dynamic Filters.

This will ask the user for filter subset, every time the data or the report gets refreshed. User can enter the prompt either by selecting the values or by typing. And Prompt can be defined for any object (Dimension, Measure, and Detail)

Multiple or Complex Filters:

This will use more than one filter joined with AND or OR condition or a combination of both.

Report Filters:

Global level filters: Gets applied on the whole report.

Block level filters: Gets applied on particular blocks.

Advanced Filters: Using Ranking

Report Level ----- Analysis ------ Ranking

SAP Business Objects Mobile Server Installation and Deployment

The SAP Business Objects Mobile solution allows users on the move to access and analyze business Intelligence data using a mobile device; to help make analytical decisions. SAP Business Objects Mobile 4.0 Support Package 4

This solution comprises the following three major components:

• SAP Business Objects Mobile Client

• SAP Business Objects Mobile Server

• SAP Business Objects Business Intelligence (BI) platform

Step:  1 Apache Tomcat Web Application Server

The SAP Business Objects Mobile server is supported on the Tomcat Web application server. To install

The Mobile server package on the Tomcat Web application server, perform the following steps:

1. Stop the Tomcat Web application server.

2. Open the Mobile 14 folder and copy the two .war (MobileBIService.war,MOBI Server.war) to the tomcat6/webapps folder

 From path: C:\Program Files (x86)\SAP Business Objects\Mobile 14\Server

Copy the below files

MobileBIService.war

MOBIServer.war

And paste it to C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\webapps

The .war files will be automatically deployed by Tomcat.  

3.  Start Tomcat

Ø  Step 2: Configure the “MOBI.PROPERTIES”

Change bellow path

default.corporateCategory=Mobile,

 default.personalCategory=Mobile,

 To

default.corporateCategory=Mobile,Category 1, Category 2

default.personalCategory=Mobile,Category 1, Category 2

Ø  Step 3: Configuring the SERVER.PROPERTIES

connection3.DisplayName=Mobile

connection3.BOBJ_MOBILE_USER_NAME= kavya.a          

connection3.BOBJ_MOBILE_URL=http://192.168.0.0:8080/BOE/BI

connection3.BOBJ_MOBILE_CMS=lera-1c2a9fa567:6400

connection3.BOBJ_MOBILE_AUTH_METHOD=secEnterprise

Step 4:  To verify that the Mobile Server has been deployed, go to this page to see if it displays the following result status:

http://yourservername:8080/MobileBIService/MessageHandlerServlet?message=GetVersion

SAP BI Mobile Server is now deployed. It will allow you to access reports through a mobile device using the SAP Business Objects Mobile app and the SAP Business Objects Explorer application, once the remaining components are installed and configured as shown here.

Step: 5 to install the Mobile Plug-in

The Mobile Plug-in is required by the CMS.

1) In Windows, click Start > Control Panel > Programs and Features > SAP Business Objects BI Platform 4.0 SP4, and then click Uninstall/Change.
     The "SAP Business Objects BI platform 4.0 SP4 setup" wizard opens.

2) On the "Select Features" page, select the CMS plug-in for Mobile check box.

 Step: 6 to configure Tomcat to enable the Mobile client 

By default, the Mobile will only show reports that are part of the Mobile category.  The Mobile category must be created manually. 

1) In the Central Management Console (CMC), go to Categories > Manage > New > Category, and type Mobile.

We can now add a report into a category by going to the CMC > Folders > All Folders > Web Intelligence Samples. Right click the report and then select Categories. In Categories, select Mobile

Step7: to install SAP Business Objects Mobile Client 

Install the Mobile application in your device and enter the bellow details to connect BI enterprise

NAME: Mobile BI4.0

Server URL: http://192.168.0.0:8080

CMS Name: lera-1c2a9fa567

Authentication: Enterprise or SAP

User Name: kavya.a          

Password: *****************

And connect to Enterprise 

Differences between WebI and Crystal Reports?

	Crystal Reports	Web Intelligence
Data Source	Crystal Reports can use universes or access a database directly.	Web Intelligence can only use universes.
Prompts	Report data not necessarily must be filtered by the prompt value. Prompts’ Lists of Values can be defined in the report. Default value can be calculated.	Prompts within reports must be used for filtration of data (this restriction can be overcome but some tricks must be used). Lists of values are based on the database values. Customized or calculated lists of values require placing prompt into Universe (which means universe customization)
Layout	Many tools are available for work with layout  (rulers, guidelines). It is also very flexible because formulas can be used for determining position of the fields, suppression of rows etc. Especially good for working with single table reports. If report has more than one table, sub reports must be used which might affect performance	Web Intelligence is not flexible and it is difficult (sometimes impossible) to get precise layout, very difficult to get flexibility based on parameters (e.g. showing dynamic number of columns). Not a problem to place more than one table within the report.
Viewing	Reports can be viewed and scheduled in Infoview	Reports can be viewed and scheduled in Infoview
Development Time	It takes longer to develop simple report in Crystal Reports than Web Intelligence, but complex reports development time is more predictable (no need to invent tricks). It is easier to implement complex logic.	Simple reports can be developed on fly if there is an intuitive universe. It takes a lot of time to develop a report based on a complex universe (to overcome restrictions of the tool). For complex reports it is sometimes easier to develop a customized universe especially for the report and put all logic in this universe.
Users	Office employees who have to report in the same form (with some deviations which can be handled by parameters) or management for some standard reports or analytical reports (if manager’s are not technically qualified to build Webi reports or universe is too complex for understanding)	Top management and executives, who use report for decision making (not for daily scheduled standard reports), want to make ad-hoc analysis, dig into data and decide what data they prefer to see in the report when they build it.
Notifications	Crystal Reports can send an e-mail to users based on alerts, when report data meets some condition (e.g. if profit less than 0)	The similar option is not available
Export formats	XLS, PDF, CSV, TTX, RTF, HTML, XML	XLS, PDF, CSV
Upgrade and recovery	If a report is based on database directly (not using universe), upgrade can affect report only if database structure was changed. It is easy to remap fields though, which means that report can be recovered anyway	Universe changes may affect a report if an object used by the report is deleted. Sometimes it can be difficult or impossible to recover reports if the original universe was modified or removed by mistake.
Primary Function	Operational Reporting	Query and Analysis
Report Author	IT, Developer	Business User, Data Analyst
Report Consumer	Information Consumers	Information Analysts
Report Design Tool	Win32 Desktop Client	Web Based, Desktop Rich Client
Formatting	Precise, Pixel perfect formatting	Basic Formatting
Typical Uses	·         Operational Reporting ·         Pre-built report templates ·         High volume publishing ·         Predictable Questions	·         Ad-hoc Query and Analysis ·         Self –service reporting ·         Unpredictable questions

Differences between SAP BI and OBIEE ?

	SAP BI	Oracle BI
Introduction	Ø  Ø  For businesses that require a full, detailed picture of every company process, SAP Net Weaver BI steps in. Ø  Ø  This full-function tool is designed to cater to a diverse set of needs, satisfying the requirements of everyone in your organization – IT professionals, senior management, and end users included. The tool’s robust infrastructure hosts wide-ranging functionality in one integrated platform.	Ø  Ø  For businesses with serious BI needs, OBIEE is an incredibly powerful business intelligence tool. Ø  Ø  The Enterprise Edition integrates many of Oracle’s most useful components, including BI Server, BI Answers, BI Interactive Dashboards, BI Delivers, BI Publisher, the MS Office Plug-in, Hyperion Interactive Reporting, Hyperion SQR Production Reporting, Hyperion Financial Reporting, and Hyperion Web Analysis. In other words, for almost any conceivable data measurement, visualization, reporting, or information manipulation, OBIEE has a solution.
Features	Ø  Ø  A single, integrated platform pulls together   applications and reporting to provide a detailed snapshot of your organization. Ø  Ø  Visualization makes it easy to understand your data. Ø  Ø  Improve your company’s collective IQ by giving all collaborators insights into data and performance indictors Ø  Cost: Free Trial; contact for pricing	Ø  Ø  Comprehensive BI tools inform and inspire better decisions across your organization Ø  Ø  OBIEE allows for full collaboration within an organization Ø  Ø  Interactive dashboards make reporting and data visualization simple Ø  Cost: Contact for pricing
BI	SAP offers Business Objects and SAP AP Net Weaver Business Intelligence.	Oracle Offers DBI (Daily Business Intelligence). OBIEE, BI Apps and Oracle Hyperion.
Data Integration	Business Objects Data Integrator	Warehouse Builder (OWB).
Data Aggregation OLAP  Cube	Aggregate tables or 3rd party (Eg: SSAS) Microsoft SQL Server Analysis, Services Hyperion, Essbase, IBM DB2 OLAP, SAP BW	Essbase, OLAP option in DBMS.
Data Abstraction Modeling	Universe Designer.	BI Server Modeler, Essbase Modeler.
Report Authoring	Crystal , Web Intelligence	BI Publisher, Financial Reporting.
Analysis Tool	Web Intelligence, Voyager	BI Answers, Essbase.
Adhoc Query / Report	Web Intelligence	BI Answers
Dashboard Authoring	Xcelsius, Dashboard Builder	BI Interactive Dashboards
Scorecard Authoring	Xcelsius, Dashboard Builder	BI Interactive Dashboards
Portal	Business Objects Enterprise Portal	BI Portal
Data Mining	Predictive Analysis	No Data Mining
Advantage	High Visualization Customer Friendly	All in One portal implementing BI Concept
Disadvantage	No Cube	Ordinary Visualization many versions (compatibility issues)
Performance	Slow Performance	Need High Machine for Good Performance
Usability	8	7
Product Bundling	Only core modules are offered. Database would be extra.	Oracle 11g database and to some extent on Microsoft SQL
Middle ware	Its middleware is called as Net weaver.	The middleware is called as Fusion Middleware.
Implementation	Major implementation solutions to the discrete Manufacturing Industries	Major implementation done in Services Industries, BFSI (Banking, Financial services and Insurance).
Open / Proprietary standards	SAP is based on ABAP (current version mix of ABAP and Java). It is difficult to Get/ maintain and retain a ABAP resource	Oracle follows open standards Java. There are lot many resources available who know java than ABAP. Hence TCO (Total Cost of Ownership) is lower here.
Product Architecture	There is a architectural changes in R/3. Business One and All in one. The up gradation from either of the above versions is not possible. In case of migration the customer needs to buy new   licenses and reimplement again	There is only one version available to all the customers. I t is Oracle ebusiness Suite.
Product Upgrades	Upgrade from 4.7 to 6.0 is not free. Customer needs pay for the license and implementation. The ATS is 22% of the license amount	Product upgrades are free. They are covered in the 22% ATS fee paid to Oracle Split- 15% Updates and 7% Upgrades. Customer needs to pay only for the upgrades (Consultant fees only).
Future Product	-	Oracle Fusion
Database Support	SAP supports Oracle, DB2, Max-DB, MS SQL and other database versions	Oracle works on Oracle database and to some extent on Microsoft SQL.
Complex Reports	It is difficult to create complex reports.	Excellent and comprehensive to create complex reports (Data mining easy tool).