bw portal implementation

]BI Portal Federated Portal Network ImplementationMangesh Mahadik

Meda Pharmaceuticals

Aravinda Boyapati

Intelligroup Inc

Real Experience. Real Advantage.

[

22

Agenda

Introduction About MEDA, US System Landscape & User Base Project Scope Business Intelligence (BI) Portal Implementation

BI 7 Architecture Need of BI JAVA and BI Portal in BI 7 BI Portal Installation Options (Pros & Cons between different options) Hardware Sizing BEx Configuration & Security

Federated Portal Network (FPN) Different Portal Landscape Scenarios Implementation Steps Different Content Sharing Options BI Portal Publishing Accelerator BI Portal Content Management & Information Broadcasting

Key Learning


[

3

Terminology

FPN : Federated Portal Network

EP in entire presentation refers to BI Portal.

Ex:

BI Portal is a slim version of SAP Enterprise Portal which is installed along with BI JAVA


[

4

Abstract Key Functionalities

Learn about BI portal implementation and security

Learn about need for BI Portal in BI Implementation

Learn about federated portal network implementation

Learn about web reporting in business intelligence and content management in BI Portal

4


[

55

Return on Investment

Significant reduction in TCO by providing real-time and historical data in Business Intelligence (BI)

Information broadcasting saves time and money (Go Green)

BI Portal provides a familiar and intuitive environment which reduces the learning curve and accelerates the implementation process.

BI Portal enriches user experience and encourages use of BI applications.

Reusability of content and applications throughout the network can be achieved using FPN.


[

6

About MEDA Pharma

MEDA Pharmaceuticals Inc. is the U.S. subsidiary of MEDA AB. MEDA Pharmaceuticals specializes in respiratory, allergy, central nervous system, and cough-cold products.

MEDA AB is an international specialty pharma company that concentrates on marketing and market-adapted product development.

MEDA is represented with organizations in 26 countries, with more than 1,500 employees within marketing and sales.

MEDAs products are sold in approximately 120 countries world-wide.

6


[

7

MEDA ERP Journey


[

8

MEDA System Landscape

8


[

9

Partnering with Intelligroup

9

Intelligroup is preferred System Integrator for MEDA in area of ERP systems

and they helped with all stages of roadmap.

Stage-1 MEDA Selected Intelligroup as an Implementation Partner to implement Materials Management, Product Costing, Logistics, Flexible Planning, Sales& Distribution, FI & CO processes in SAP 4.6C to manage their operations.

Stage-2 In 2003, MEDA implemented SAP-HR including Personnel Administration, Org Management, Benefits, Payroll Interface to ADP and Travel Management for their entire Corporate and Sales Force staff. This included ITS based expenses entry and approval functionalities.

Stage-3 In August 2006, OS Migration from Unix to Windows NT and patches applied to existing 4.6C system

Stage-4 July 2007, ECC 6.0 and BI 7.0 Upgrade including Oracle Upgrade, 64-bit conversion and Unicode.

Stage-5 June 2008, EP 7 Upgrade, BI Portal & Federated Portal Network Implementation, ESS/MSS Implementation

Current Projects in Pipeline: CRM 2007, MDM,PI 7.1, AII 5.1 and Offline Travel Mgmt


[

10

Project Scope

Project Scope The scope of the project is to enable BI Portal for Web Reporting

Enable BEx Web Analyzer, Reports Broadcasting , PDF Print

Implement Federated Portal Network between BI Portal & Enterprise

Portal

Technical Activities BEx Configuration

Deploy & Configure BI Administration Cockpit 1.0 Business Package

Security / Remote Role Assignment

Federated Portal Network

Functional Activities BI Reports Publishing using BI Portal Content Accelerator Tool

BI Portal Content Governance

10


[

11

Project Highlights

MEDA BI Portal / FPN Implementation Project started with onsite assessment session with Business Process Owners

Team Size

Business Process Team: 2

Technical Team: 4 (one onsite and three offshore)

Project Locations:

Somerset, New Jersey

Remote location in Hyderabad, India

Global team in different time zones working seamlessly using web conferencing to conduct virtual meetings for periodic status review

Project Time Line: 3 months

11


[

12

BI Portal Implementation Details

Business Intelligence (BI) Portal Implementation

BI 7 Architecture Details

Need of BI Java and BI Portal in BI 7 environment

BI Portal Installation Options

Hardware Sizing

BEx Configuration & Security

Template Based Configuration / RSPOR_SETUP

Install & Run Diagnosis Tool

Sample Errors

Setup KM Document Repository In BI Portal

12


[

13

BI 7 Architecture Details

13

What is Usage Type: Usage types are the installable software components which can be installed independently based on the IT practice. IT practice is again based on IT scenario (what the business required).

What is BI Portal (EP) and BI JAVA ?BI JAVA usage type available from NW 2004S. BI Java usage type requires AS JAVA and BI Portal (EP) as prerequisites.( BI portal is a slim version of Enterprise Portal)


[

14

Need of BI JAVA & BI Portal in BI 7

14

Why we need BI JAVA and BI PortalSAP BI 7 comes with new features such as Web Application Designer, BI

Accelerator, BEx Broadcaster, BEx Query Designer, BEx Report Designer, PDF

print, BEx Web Analyzer and Visual Composer Modeling. All these new

functionality requires the usage types AS JAVA, BI JAVA and BI Portals along

with BI and AS ABAP

Which features of BEx Web in SAP NetWeaver BI 7.0 are

requiring Portal runtime? (*) New BEx Web Application Designer

Exporting to PDF and Printing

Integrated Planning, Drag & Drop (Analysis Web Item)

Web Items (Container Layout, Menu Bar, Tab Pages, Button Group etc)

Formatted Reporting with BEx Report Designer

Document Integration with storage in Knowledge Management

BEx Web Analyzer


[

15


15

Installation dilemma:You can either install all these usage types in single server which is called add-in

installation or you can separate BI Portal from actual BI-AS ABAP which is called

stand alone installation.

Add-in Installation Add-In Installation on one server as one system (Double Stack Installation). Medium scalability because server itself must scale. Split is possible but requires rebuild of Java-Stack. All Dialog Instances must to be also Add-In installation (combined AS-ABAP/AS-Java-Stack). Combined Start/Stop (system downtime)


[

16


16

Standalone Installation: Comes up with two options

One Server with Two Sys Ids

Two Servers with Two Sys Ids

Highly scalability, Server itselfcan scale (or) possibly be splitout to two servers

Dialog instances could be mixed(or) separate

AS-ABAP and AS-Java could bescaled independently

Recommended basic system landscape

Highly scalability, AS-ABAP and AS-Java could be

scaled independently Dialog instances could be mixed

(or) separate


[

17

Pros & Cons between Add-In, Stand Alone installation

Add-In Installation Stand Alone Installation

Both BI & BI Portal Server down time required for system maintenance, patch updates

No server down time required for J2ee maintenance

Installation and configuration could be easy Maintenance could be little more difficult compared with standalone installation

Less hardware requirements compare to standalone installation with two servers

More hardware required compared with add-in installation

Higher number of users can cause performance issues.

Best suitable solution for high number of users.

SAP Best Practice: One server with two different SIDs is the best SAP suggestedapproach, which may require MCOD in database. This is useful because:

It is Rationale: best combination of lowest hardware requirements and highest flexibilityin terms of Scalability (dialog instances could be scaled independently).

Start/Stop (combined using SAPMMC) , Downtime (independent between AS-ABAP &AS-Java),.


[

18

Hardware Sizing

The BEx Web runtime in SAP NW 2004s BI 7.0 has been reimplemented in Java, shifting a considerable amount of load from AS ABAP to AS JAVA

BI users generate more load on Portal than normal Portal users Usage Types AS-Java and EP require additional CPU and memory Minimum requirement for AS-Java and EP is 2 CPUs and 4 GB memory See Note 927530 for more infoRecommendation: Plan a memory requirement of 1 GB RAM for every 300 SAPS. If you use additional virtual machine (VM) nodes, you need to enlarge the

Java heap (Please see Note 723909 )Formula for calculating memory capacity for individual report:

mem = # result cells * 0.8 KB + # rendered cells * 5 KBwhere:# result cells are the number of cells (rows * columns) of the result that isReturned by the query# rendered cells are the number of cells (rows * columns) that are displayedon one page in the Web template


[

19

BEx Design Time & Run Time

19

Source: SAP


[

20

BEx Configuration & Security

1. Communication

Java ABAP Communication (HTTP(S))

ABAP Java Communication (RFC/JCO)

2. Single Sign On (with SAP Logon Tickets)

Java is trusting ABAP

ABAP is trusting Java

3. User Management Configuration ( ABAP system as central user administration, With Add-in installation this step automatically performed)

Configuration Options:

Template Based Configuration: Template Installer to perform the automatic configuration. In most cases, this template-based automatic configuration is enough to enable BEx Web in SAP NW 2004s. (Recommended)

Note: Use Diagnostics & Support (Java based) tool to verify the missing configuration

Run RSPOR_SETUP Report: Used to perform a manual/semi-automatic configuration.


[

21

Template Based Configuration

Run template installer: Login to http://hostname:port/NWA with user J2ee_admin

Click on Deploy and Change tab, Select the BI_SYSID_This wizard will execute

Post install steps of technical configuration of BI-Java from table list and click on start.


[

22

Template Based Configuration

After successful installation, you will see the success messages as shown below


[

2323

Install Diagnosis & Support Tool

Diagnosis & Support Tools is a java based tool provided by SAP for checking the missing configuration performed with template installer

Download the tool from SAP Note: 937697

Login to below BI Portal URL

< http|https> ://:/irj/servlet/prt/portal/prtroot/com.sap.portal.runtime.system.console.default

Click on browse button, select com.sap.ip.bi.supportdesk.par file from and click on

upload button.


[

2424

Run Diagnosis & Support Tool

Login to below BI Portal URL

http://hostname:port:/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.supportdesk.default

Diagnosis & Support tool will run automatically and display the configuration status.

Diagnostics tool will show all theconfiguration checks with statusRed or Green . If any Redentries exist, you can find the resolution below.


[

2525

Run Diagnosis & Support Tool Sample Errors

Below is a example of errors that you may encounter after you run diagnostics tool:

Error Status:

Error Details:

Fix:


[

26

Run RSPOR_SETUP

Setting up ABAP JAVA Communication

Setting up ABAP JAVA communication is very important step in BEx Configuration. When user login to any BEx tool (BWA, Query Designer, Report Designer) it will authenticate with ABAP engine, for publishing / Broadcasting , ABAP engine communicate with J2EE engine.

Note: Template Installer verifies only the JAVA ABAP communication & SSO.

RSPOR_SETUP report is used to check the communication & SSO from AS

ABAP to AS JAVA (Please refer notes : 916571, 928332 before running

Report)

You can run RSPORT_SETUP in two different ways

Login SAP GUI SE 38 Enter RSPOR_SETUP Execute

Login SAP GUI SPRO IMGSAP Netweaver Business Intelligence Settings for Reporting and Analasys BEx Web Overview Integration in to Portal


[

27

Run RSPOR_SETUP

Next screen appears with three different options, if you already ran

template installer, select Check Configuration option to verify settings.

After execute, report will be displayed with status details


[

28

Run RSPOR_SETUP Sample Error (1)

Status which are in red color needs to be configured manually

Example:

Resolution: The RFC destination in the J2EE Engine is an RFC server that is

called by the BI system as the RFC client. The connection is required in order to

display content from the portal in the BI system. The RFC destination is used for

the portal in RFC destinations.

Fix: Login to BI Portal Visual Administrator

(\admin\go.bat ) Sid/Server/Services/Jco RFC Provider Maintain RFC Destination

Create RFC Destination in BI System with same Program Id


[

29

Run RSPOR_SETUP Sample Error (2)

Status which are in red color needs to be configured manually

Example:

Resolution:

Export BI Portal Certificate (J2EE Certificate) in BI (ABAP). This will ensure all requests which are coming from BI portal will accepted by BI (ABAP) System

Export BI (ABAP) certification in BI Portal (J2EE). This will ensure all requests which are coming from BI (ABAP) will accepted by BI Portal (J2EE) System


[

30

Run RSPOR_SETUP Sample Error (2)..

Export BI Portal Certificate (J2EE Certificate) in BI (ABAP):

Download the

Certificate from

BI Portal

Upload BI Portal

Certificate in to

BI System using

TCode STRUSTSSO2


[

31

Run RSPOR_SETUP Sample Error (2)..

Export BI Certificate (ABAP Certificate) in BI Portal(J2EE):

Download Certificate from

BI System using

TCode STRUSTSSO2

Upload BI (ABAP)

Certificate in to

BI Portal

Visual Admin Server Services

Security Provider


[

32

How To Identify Communication Errors

BI Portal

AS ABAP AS JAVA

BEx (WAD)

RS_TEMPLATE

_MAINTAIN_70

Note : 989525

RSPOR_SETUP


[

33

Possible Errors , If set up not done properly

Below Errors may Occurs while publishing query in to BI portal if the Certificates are

not configured properly between BI (ABAP) and BI Portal (J2EE)


[

34


KM Document Repository configuration in BI Portal enables to save the queries, reports and BI Applications as KM documents

Use KM Services for: Subscription, Feedback, Discussion, Collaboration, Rating, TREX search, Notes, Download


[

35


Log on to the portal System Administration -> System Configuration -> Knowledge

Management -> Content Management Repository Managers Classes BI

Document Repository Create new repository


[

36

BI Portal Demo


[

37

Federated Portal Network (FPN)

A federated portal network (FPN) allows organizations with

multiple portals, SAP and non-SAP, to share content between the

independent portals.

New Terminology:

Consumer Portal

Producer Portal


[

38

Different Portal Landscape Scenarios

One Central PortalPros Less Hardware Requirement Serves for all back end Apps

(ECC/BI/CRM/SRM etc..)Cons May cause performance issues Complex maintenance

Non - FPNPros Load Sharing

Easy maintenanceCons Require multiple logins Not a best practice


[

39

Different Portal Landscape Scenarios

Federated Portal NetworkPros One central consumer portal serving as

the entry point for all end users. Seemlessly accesses content residing on

multiple producer portals (SAP as well as Non- SAP portals).

Load Sharing Different producer portal can upgrade to

provide enhanced functionality without effecting the main portal server which all employees use.

Business units use different portal(Producer) servers to create andmaintain their required functionalities

Cons: Consumer portal becomes only source

of accessing all business functions in an organization

Note : SAP NetWeaver 7.0 (2004s) SPS 10

and above FPN is available Consumer Portal and Producer portal

should be at same patch level


[

40

FPN Implementation Steps

System Administration

Proxy Setting

Trust between Consumer and Producer

Cache

Define and Configure Producers in Consumer

User Administration

Make sure users in consumer and producer should be same

Content Sharing

RRA (Remote Role Assignment)

Remote Content Copy

WSRP Content Sharing (mostly for Non-SAP Portals)


[

41

FPN System Administration Settings

Proxy Setting (If you are using proxy server) Need to be configured on both

producer and consumer

Login to Portal (Consumer & Producer) System Administration System Configuration Service Configuration Applications com.sap.portal.ivs.httpservice

Cache Setting Improve performance while

accessing content between consumerand producer(s)

Login to Portal (Consumer & Producer) System Administration System Configuration Service Configuration Applications com.sap.portal.ivs.global.gpcache


[

42


Cache Settings

Login to Portal (Consumer & Producer) System Administration Federated Portal My Self As Content Consumer Cache Management com.sap.portal.ivs.httpservice


[

43


Trust Settings : Enables the user authentication between consumer and producer while sharing content

Download the verify.der file on theconsumer portal

System Administration SystemConfiguration Key Store Administration

Import the verify.der file on the producer portal

System Administration SystemConfiguration Key Store Administration Import Trust certificate


[

44


Trust Settings Login to Producer Portal Visual Administrator (Go.bat), Enter the consumer portal certificate details as follows

Visual Administrator SID Server XYZ Services Security Provider Run time Policy Configuration

Restart J2EE Server


[

45


Define and Configure Producer(s) in Consumer

Create a Producer in Consumer

System AdministrationFederated PortalMy Self As

Content ConsumerManage my ProducersNetweaver Content Producers

Register Consumer With Producer To use the content shared by

producer, consumer must register with producer


[

46

How to Verify Producer Content & Roles in Consumer

To Verify Producer (BI Portal)

Content in Consumer Portal.

Content Administration Portal Content Netweaver Content Producers

To Verify Producer (BI Portal) Roles in Consumer Portal.User Administration Identity Management


[

47

Different Content Sharing Options


[

48

BI Portal Publishing Accelerator

BI Portal Publishing Accelerator tool is developed by Intelligroup for streamline the BW/BI content publishing process in BI Portal, It is used to Publish BEx Query/Report/Template as an Iview

Assign Iview properties

Assign iview

To page/workset/role

To KM Folder as link

Assign page to workset or role

Assign workset to role

Assign roles to user/User groups

Search for roles

Search for users

Generate Transport file for the assignment


[

49


Publish BEx Query / Report / Web Application Designer Template as an Iview


[

50



[

51

BI Portal Content Management

Use WorkSet Map IView to display the iview links as pictogram


[

52

BI Portal Content Management

Use KM Document Explorer Iview to display all report iViews (as a KM links) for easy report navigation

KM Folder Structure


[

53

Information Broadcasting in BI Portal

Information Broadcasting in BI Portal allows the distribution of BI

Information

via different channels E-Mail

Enterprise Portal

in different formats ...

HTML, MHTML

BEx Analyzer Workbooks

ZIP Files

of different sources

Queries

BI QAD - Dashboards,

BEx Analyzer Workbooks

in different modes

Online & pre-calculated


[

54

Information Broadcasting in BI Portal

1

2

3


[

55

Access Producer(BI Portal) Roles to Consumer using RRA

BI Portal(Producer)

Assign producer portal roles to consumer portal (login to consumer portal User Administration Identity Management Search producer role , Assign to user)

RRA

Enterprise Portal(Consumer)


[

56

Federated Portal Network Demo


[

57

Key Learning

Think of BI Portal as an add-on to your existing BI environment

Portal that incorporate BI are much more powerful

BI Portal gives you new tools and options for information governance

Understand the different BI portal installation options & Hardware Sizing

Federated Portal Network gives much control and performance while accessing enterprise applications

KM gives powerful content management options

Think of Information Broadcasting for timely report delivery


[

5858

[

] Thank you for participating.SESSION CODE:3003

LOCATION: S310H

Please remember to complete and return your

evaluation form following this session.

For ongoing education on this area of focus, visit the Year-Round

Community page at www.asug.com/yrc

bw portal implementation

Documents