9/9/2014 12 facts you should know before upgrading to BI 4.0 | SAP BO,BI,Database & Data warehouse FAQ

http://bobi.blog.com/2014/02/15/12-facts-you-should-know-before-upgrading-to-bi-4-0/ 1/4

SAP BO,BI,Database & Data warehouse FAQ | Why We Followthe Way if We can Lead the Way

Dear Techie!!

Welcome to the my blog bobi.blog.com - a techno world of Business Intelligence. Through this blog, I have tried to initiate and share my technial skill in area of SAP Business Intelligence, SAP Visual

Intelligence,Business analystics, Datawarehouse concepts,Reporting and database analysis .

I would invite and encourage you to read the posts and share your comment and experties on the topics mentioned in the blogs so that

this blog could came true to help the beginner and the advance level practitionaer and Professional of SAP BO/BI.

Thanks in advance for your valuable contribution!!

12 facts you should know before upgrading to BI 4.0

Filed under BO/BI Administration by Deepak Chaubey on 15-02-2014

Refernce:http://wiki.scn.sap.com/wiki/display/BOBJ/All+you+need+to+know+before+upgrading+to+BI4.0

Contents

1) Link to KHNC (Webinar) and Upgrade presentations (PDF)

2) Main issues (with workaround) and questions asked by Ramp-Up customers :

3) Conversion from Desktop Intelligence to WebIntelligence

4) How Security Rights are migrated between Xi3.x and BI 4.0.3 (new !!!)

5) Universes and Audit reports

6) Understanding 32 bit and 64 bit connectivities deployment

7) Sizing and Performance

Integration into the Netweaver Enterprise Portal

9) Integrating and Launching Existing BEx Web Applications in BI 4.x10) BI4 – Introscope & Solution Manager integration

11) Understanding Side by side

12) Link on Document which explain how to move from BO5/6 to XIR2 platform.

1) Link to KHNC (Webinar) and Upgrade presentations (PDF)

Topic Link

KHNC (Webinar)

Presentation (PDF)

BI 4.0 Did you think about your upgrade? (Last update)

http://www.sdn.sap.com/irj/scn/events?rid=/library/uuid/40137cd2-92d4-2d10-ef8a-8467e504f69e David F

Gonzalez, Technology RIG, SAP

Presentation (PDF)

http://www.sdn.sap.com/irj/scn/events?rid=/library/uuid/a07f2ecb-c9e9-2d10-c99c-f5895177acff

SAP BW Customers

SAP Integration Update 9 – Should you start with SAP BusinessObjects 4.0 or wait for 4.1? (24 March

2011)

Subscribe to RSS Feed

Select Topics Category

Select Category

Author Introduction

I am keen enough to learn

stuff as much possible. I use my leisuretime to post and share my knowledge

in area of SAP business object,Business

Inteligence,Datawarehouse and Database

concepts including few databses(SQL server2005,SQL server 2008,SQL server

2012,Oracle 9i,Oracle 10g,Oracle 11g

R2,Sybase ASE,Sybase IQ,Mysql 5.5) by its

programming language SQL,PL/SQL,Sybase.

My purpose to create this blog is to create asuper BO/BI/Database blog which contains

almost all the respective questions related to BO

Interviews in area of administration,development

and analysis from basic to advance level.this blog

can save enough time for beginner as well asexperienced one. If you have any query

regarding any of the post in this blog.you can

write me on : sapbobiinfo@gmail.com

below link to know more about me:

http://about.me/deepakchaubey

My Recent Posts

BusinessObjects-Backup your BI system

Hacking BOBI 4.0 administrator account-

reset Admin Password

BusinessObjects-Repository Scan and

Repair using Repository Diagnostic Tool

(reposcan)

Top 30 tips of BO XI R2 Query Builders

How to Upgrade to BI4.0

BusinessObjects 4.0 Single Sign On

(SSO) with WIN ADSAP Administration:How to setup SSO

against SAP BW with SAP BO BI4.0

Common Semantic Layer (UNX) or

BICS

Optimize query with Query Stripping in

Web Intelligence

SAP BO: Webi thin client vs Webi rich

client

Multitenancy Management tool setup, new

features in BI 4.1Configuring trace Logs in BusinessObjects

4.0

BusinessObjects Administration – Audit

reporting vs Metadata reporting

Process to create Batch Script to

START/ STOP ‘Server Intelligence

Agent’ (SIA) on Windows 2008 Server

9/9/2014 12 facts you should know before upgrading to BI 4.0 | SAP BO,BI,Database & Data warehouse FAQ

http://bobi.blog.com/2014/02/15/12-facts-you-should-know-before-upgrading-to-bi-4-0/ 2/4

SAP BW Customers

- Considerations

2011)

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23995 Ingo Hilgefort, Customer Insight andActions, SAP AG)

E-learning BI4.0 http://www.sdn.sap.com/irj/scn/bi-platform-elearning?refer=main

How to Upgrade to BI4.0This an article that covers steps to upgrade

http://wiki.sdn.sap.com/wiki/display/BOBJ/How+to+Upgrade+to+BI4.0

2) Main issues (with workaround) and questions asked by Ramp-Up customers :

This article will list the main questions or issues found by our Ramp-Up customers.

Of course we will explain you the workaround found.

Issues or questions

Minimum Software Level: BI 4.0 SP02 Patch 2.4 or later as @ 2011/08/31. For new deployments, first install BI 4.0 SP02 “full” build

downloaded from “Installations and Upgrades” at Service Market Place. For pre-SP02 deployments, apply the SP02 patch (“add-on”)

build from “Support Packages and Patches”. Service Market Place downloads: https://websmp109.sap-ag.de/~form/handler?

_APP=00200682500000001943&_EVENT=SWDC_ALIAS&TMPL=INTRO_SWDC_SBOP&V=INST&SWDCQL=sbop-

downloads&SELAREA=501100035870000018155&SUBLEVEL=A_1_1

The way of importing AD users has changed. Need to create the AD mapping as we did in XI3 but now you have to create manualy all

AD groups before doing the upgrade.

We will create a KB and provide you with the link.

This an article that covers steps to upgrade and issues found by Ramp Up customers :http://wiki.sdn.sap.com/wiki/display/BOBJ/How+to+Upgrade+to+BI4.0

3) Conversion from Desktop Intelligence to WebIntelligence

These articles are going to describe which features are / or NOT availble in BI4.0 and how to find workaround to move DesktopIntelligence reports to WebIntelligence.

We will provide some report with these features.

SDN wiki : http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence.

4) How Security Rights are migrated between Xi3.x and BI 4.0.3 (new !!!)

SDN PDF : http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f0543a8d-9155-2f10-c5a7-8d15688a5faa

5) Universes and Audit reports

In SAP BusinessObjects 4.0 auditing database schema was changed, improved. The attached sample auditing universe and reports mayhelp you started in the process of developing custom auditing reports for SAP Business Objects 4.0.There are 38 sample Crystal Reports.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/40711187-04e8-2d10-d190-851e20c7665a

————————————————- —————————————————————————-

6) Understanding 32 bit and 64 bit connectivities deployment

This article will explain you as we have got these questions by many customers

Wiki on SDN : Target H1 2013.

7) Sizing and Performance

The previous “T-Shirt sizing” guide is now superceded by the BI 4.0 Quick Sizer online tool for ‘initial’ or standard sizing scenarios.

The Quick Sizer tool has an associated BI 4.0 Sizing Companion Guide which should also be referenced. The Companion Guide isdownloadable from the location described below.

Step-by-Step

SAP BI Plattform 4.1 Performance

TuningIN, ForEach & ForAll

in BO

New feature of BI 4.1:

Intelligence Compatibility Pack (DCP):

(FAQs)

Installing SAP BI 4.1 SP01 on Red Hat

Enterprise Linux 6.x Step-by-step

BI Upgrade Q&A

How to Upgrade to BI4.0

12 facts you should know before

upgrading to BI 4.0Configuring the File Repository Server

(FRS) in BI 4

Setting up SAP BusinessObjects Mobile

BI Platform 4.0 Cluster configuration

How to count Number of

reports/subreports in a WebI documentVVI Fact of Outer Join in UniverseDesign in SAP BO

Clustering and Load Balancing in Tomcat

5, Part 2Tomcat clustering Part 1

How-to create an SAP BusinessObjectsXI 3.1 cluster (on Windows)Derived tables in SQL and in SAP

Business ObjectBig data: The next frontier for innovation,

competition, and productivityConfigure the SAP Business Object/ BI

4.0 Services through command lineHow to Change Login Banner or LOGO

in Business Objects Info viewTrick:Disable the Desktop Intelligenceoption under the New Document button.

Type of ConnectionDifference between Break and Section in

Webi reportWhat is BI4 Hot Backup

Configure auditing level and auto-deleteinterval

SAP Business Object ArchitectureOverview and comparative analysis

Business Objects Program ObjectBusiness Intelligence Resources LinkBrowse CMS repository and its Secret

Useful query using SAP BO QueryBuilder

Query with Query BuilderDecode Function in Oracle

BO Linked UniverseDifferences between BOXI R2 and R3

and BI 4.0Top nth SalaryDifference between the having clause and

the group by statementNew methods of authentication options in

the CMC of SAP BO BI 4.xWebi report: Drill down ,Drill across

functionalityHow to Resolve Ambiguous Relationships

Handling Fan Trap and Chasm Trap inSAP BO

BusinessObjects Content recovery andDisaster recovery – BO XI 3.xDatabase Delegated Measures or Smart

Measures in Web IntelligenceDynamic Measures in Webi

Cascading Prompts using CustomHierarchies

BI4.0 LCM:Create BIAR fileusing(Promotional management in CMC)

Concept of Calculation context in SAPBO webi reports

Changing the name of a CMS clusterQaaWS vs Live Office-Which one is the

9/9/2014 12 facts you should know before upgrading to BI 4.0 | SAP BO,BI,Database & Data warehouse FAQ

http://bobi.blog.com/2014/02/15/12-facts-you-should-know-before-upgrading-to-bi-4-0/ 3/4

downloadable from the location described below.

There are also guides for manual sizing for

SAP BusinessObjects Explorer 4.0

SAP BusinessObjects Web Intelligence 4.0 SP2. This guide also contains sizing guidlines for WebI reporting with BICS BWconnectivity.

When sizing requirements are larger than the standard scenarios or a more custom sizing is required, contact your SAP representative to

arrange a BI 4.0 expert sizing service.

The sizing guides apply to BI 4.0 SP2 or later

http://www.service.sap.com/sizing under sizing guidelines->solutions and platform

Integration into the Netweaver Enterprise Portal

BI4 Integration into the SAP Entreprise Portal 7.0.x

———————————————– ————————————————

9) Integrating and Launching Existing BEx Web Applications in BI 4.x

Webinar and article series describes the use case; integrating BEx Web Apps with BI Launch Pad (BI 4.0 web front end); and

configuring the BI 4.0 BEx Java stack service with a BW ABAP server.

SDN wiki : http://wiki.sdn.sap.com/wiki/display/BOBJ/How+to+integrate+BEx+Web+Applications+into+BI+4.x

10) BI4 – Introscope & Solution Manager integration

Article series describes the use case; integrating Introscope and Solution Manager .

SDN wiki : BI4 – Introscope & SolutionManager integration

11) Understanding Side by side

ToolClient XI 3.1 to Server BI

4.0Client BI 4.0 to Server XI 3.1

Side by side client install (client XI 3.1 and BI 4.0 onsame machine)

CrystalNot supported, CR2008

cannot connect to BI 4.0

Not supported, neither CR4E nor

CR2011 can connect to XI 3.1

Yes. CR2008, CR2011 and CR4E can co-exist on the

same machine

Dashboard

(Xcelsius)

Not supported, XC2008

cannot connect to BI 4.0

Not supported, DDT 4.0 cannot

connect to XI 3.1

Supported as of BI 4.0 SP01. Dashboard Design Tool

4.0 SP01 and later can co-exist with Xcelsius 2008.

UDT Not supported Not supported Supported

IDT Not Applicable. Not supported Not Applicable.

QaaWS vs Live Office-Which one is theRight Choice

Cheat Book of Webi ReportMultiple queries, combined queries and

synchronized queries compared in WEBIreports

Live Office vs Qaaws vs BI ServicesStep By Step Method to do Clustering In

Business ObjectUsing hyperlinks in Desktop Intelligencereports

Hack/Reset BO Administrator PasswordCMS DB and Audit DB in SAP BO

Data Modeling:Basic ConceptsData Mining:The Fundamental Concept

ETL:Maintaining the Data WarehouseDesktop Intelligence and concept

Differences between Stored Proceduresand Functions

Handling IndexesDataProvider functionDataProviderSQL function

DaysBetween functionContext operators in Business Object

NumberOfPages functionDrillFilters function

DayNumberOfWeek functionDayNumberOfYear function

MonthNumberOfYear functionLastDayOfWeek function

LastDayOfMonth functionMonthNumberOfYear functionMonthsBetween function

Month functionMatch function

Length functionLeft function

LeftPad functionLeft function

Fill functionInitCap functionHyperlink function

WordCap functionUserResponse function

Upper functionVarP

RunningSum function

Authors

Deepak Chaubey

Media

Subscribe

Get the latest posts on your e-mail!

Leave your e-mail address

9/9/2014 12 facts you should know before upgrading to BI 4.0 | SAP BO,BI,Database & Data warehouse FAQ

http://bobi.blog.com/2014/02/15/12-facts-you-should-know-before-upgrading-to-bi-4-0/ 4/4

0Like Tweet 0 0

Choose how to leave your comment

Transalation

ManagerNot supported Not supported Not supported

WebIntelligence

Rich ClientNot supported Yes, only in ZABO mode Not supported

12) Link on Document which explain how to move from BO5/6 to XIR2 platform.

Topic Link Owner

How to migrate from BOV5/V6to X2R2

http://www.youtube.com/watch?v=SqA2wkMcKNIVideo onYoutube

http://www.youtube.com/watch?

v=NVxz71tnPQU&playnext=1&list=PL2A3FD17A372C0021&index=1

http://www.youtube.com/watch?v=Gp8NJqtviwE&feature=related

http://www.youtube.com/watch?v=bYrkzi9q76Q&playnext=1&list=PL2A3FD17A372C0021&index=3

http://www.youtube.com/watch?

v=aS2yvAmIHqM&playnext=1&list=PL2A3FD17A372C0021&index=4

http://www.youtube.com/watch?v=n-VPeYF91kY&feature=related

Please note: To upgrade to BI4 you need to be on either XI3.1 or XI Release 2 SP2 onwards. If you are on an earlier version, such asBusinessObjects Version 5, 6 or XI release 1, then upgrade to XI3.1, rather than upgrading to XI Release 2.

No CommentsRead More

Leave a Reply

Name

E-mail

To prevent comment spam, you must verify you own your email address using Mozilla Persona (Browserid) by clicking the green Sign In

button.

Comment

Post Comment

Authors

Deepak Chaubey

Search Withkeyword..Like”SQL”

Most Recent Post

BusinessObjects-Backup your BI system

Hacking BOBI 4.0 administrator account-reset Admin Password

BusinessObjects-Repository Scan and

Repair using Repository Diagnostic Tool

(reposcan)Top 30 tips of BO XI R2 Query Builders

How to Upgrade to BI4.0

Monthly Topics

Select Month

Related Topics you may beinterested

70 facts of Universe Designer!!

Creating Cascading Prompts in a UniverseSAP BO XIR3 Universe Designer FAQ

How to reset administrator password if

you forgotten……….???

Blogroll

Blog.comBlog.com Blog

Help & Support

Sap BO XIR3 Universe Designer Book:

Powered by Blog.com

Share