bi platform scn15

22
6/3/2014 BI Platform | SCN http://scn.sap.com/community/bi-platform/blog?start=210 1/22 Getting Started Newsletters Store Products Services & Support About SCN Downloads Industries Training & Education Partnership Developer Center Lines of Business University Alliances Events & Webinars Innovation Log On Join Us Hi, Guest Search the Community Activity Communications Actions Brow se BI Platform 255 Posts 1 13 14 15 16 17 By default when a HANA user is created, the password lifetime is set to 182 days (6 months). This can be modified via the configuration options as seen below. In HANA Studio go to Administration Configuration tab Expand indexserver.ini Expand password policy Confirm the value for maximum_password_lifetime In the event that a user's password does expire, how does a user using one of the frontend BI4 tools know? Find out below. To show what happens when a user’s password has expired, we force the user to change their password with the following SQL statement Client Tools HANA Studio Explorer Web Intelligence Expiring User Passwords with HANA and BI4 Feature Pack 3 Posted by Vishal Dhir May 30, 2012 01. ALTER USER <MYUSER> FORCE PASSWORD CHANGE

Upload: yaswanth-reddy

Post on 01-Nov-2014

132 views

Category:

Software


2 download

DESCRIPTION

sap bo

TRANSCRIPT

Page 1: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 1/22

Getting Started Newsletters Store

Products Services & Support About SCN Downloads

Industries Training & Education Partnership Developer Center

Lines of Business University Alliances Events & Webinars Innovation

Log On Join UsHi, Guest Search the Community

Activity Communications Actions

Brow se

BI Platform 255 Posts 1 … 13 14 15 16 17

PreviousNext

By default when a HANA user is created, the password lifetime is set to 182 days (6 months). This can be modified

via the configuration options as seen below.

In HANA Studio go to

Administration

Configuration tab

Expand indexserver.ini

Expand password policy

Confirm the value for maximum_password_lifetime

In the event that a user's password does expire, how does a user using one of the frontend BI4 tools know? Find out

below.

To show what happens when a user’s password has expired, we force the user to change their password with the

following SQL statement

Client Tools

HANA Studio

Explorer

Web Intelligence

Expiring User Passwords with HANA and BI4 FeaturePack 3

Posted by Vishal Dhir May 30, 2012

01. ALTER USER <MYUSER> FORCE PASSWORD CHANGE

Page 2: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 2/22

Crystal Reports for Enterprise

Crystal Reports 2011

Dashboards (Xcelsius)

Analysis Edition for OLAP

Page 3: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 3/22

Analysis Edition for Microsoft

The client tools show a different error message depending on which one is used. Only the Analysis Edition for

Microsoft, lets a user change thier password within the tool itself.

1053 View s 2 Comments Tags: bi, bi4, hana, bi4.0, reporting, business_intelligence

Here's a demo video of the latest BI innovations with SAP BusinessObjects 4.0 Feature Pack 3, including Explorer,

StreamWork integration, mobile BI. There are also a few clips included in this video for SAP BusinessObjects

Predictive Analysis and Social Analytics with NetBase. This video highlights the five pillars of BI innovations: Core BI,

Mobile, Social, Extreme, and Creative.

Stay connected with the latest BI innovation news by following #TrackingTimo on Twitter

@nicfish

1140 View s 0 Comments

0:00 / 1:55

Demo of SAP BusinessObjects 4 - May 2012

SAP BusinessObjects 4.0 Feature Pack 3 Demo

Posted by Nic Smith May 25, 2012

Page 4: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 4/22

Tags: bi, bi4, hana, business_intelligence_(businessobjects), mobile, in-memory_business_data_management, bi4.0, explorer,

mobi, dashboards, crystal_reports, sap_businessobjects_mobile, analysis, bi4_upgrade, business_intelligence, eview s, mobilebi,

sap_businessobjects_business_intelligence_platform_4.0

Don't miss BI 2012, the most important event of the year for professionals that use and support

SAP solutions for reporting, business intelligence, and data management. More than 175 in-depth

sessions and labs, a packed agenda of networking events, and hundreds of demos showcasing

the latest updates and best practices for SAP business intelligence solutions. This event will take

place from June 6th to 8th, 2012.

Join the conversation on Twitter #BI2012

Learn more at http://www.sapbi2012.com/EUROPE

337 View s 0 Comments Tags: bi, sap, management, 2012, solutions, data, reporting, event, milan, europe

SAP BI 2012 - Milan

Posted by Eamon Ida May 23, 2012

Web Intelligence doesn’t support ‘free hand SQL’ and for some that use Desktop Intelligence in XI3, this is a problem

to migrate to BI4 and Web Intelligence. Yet, if the semantic layer was used, this problem wouldn’t be so much of a

problem . So why are some report developers still not using the semantic layer?

Well the answer, I believe, is that they don’t fully appreciate the benefits the semantic layer has over ‘free hand SQL’.

This blog talks about the benefits of the semantic layer over the problems of ‘free hand SQL’.

When documents (Desktop Intelligence or even Crystal Reports) are built on ‘free hand SQL’, columns that are not

used in the report have the following problems:

Document sizes are much larger bigger than they need to be. This is because it’s not easy to remove columns

from the SQL as you might have to change, within the SQL, ‘joins’ and ‘group by’ clauses etc.

Instead of aggregation occurring in the database, it’s occurring in the report at a cost of the infrastructure. SAP

holds the patent for ‘semantically dynamic’ and this technology ensures that as much of the aggregation that

could occur, does occur in the database. Free hand SQL isn’t semantically dynamic, so the load on the BI

Platform is greater than it needs to be and the underlying database isn’t used for used for all its ‘power’. The

free hand SQL isn’t enabling the right tiers of technology to be used in the right way.

The agility of the report to be manipulated is reduced, simple because of its unnecessary size. User’s need to

wait longer to open and display a document than is necessary.

There is no guarantee the SQL or the results are really accurate. (If the ‘semantic layer’ has been built correctly,

the SQL and the results are always correct)

Removing a ‘column’ (an object) from a document built of the semantic layer is trivial and has none of the problems

above.

Besides these problems, there are many benefits of using the semantic layer:

The SQL generated by the product can be far superior to most experts SQL! SQL manually generated tends to

be ‘easier to read’ than ‘more performing’. The SQL generated by the toolset is quite spectacular and will often

outperform free hand SQL simple because it has so many performance optimisation capabilities. With most or

all these capabilities enabled, the SQL generated can be very complex and actually quite tricky to read, as

‘power’ is the priority compared to readability.

Ease of creating and changing the query to ask the database different questions is almost impossible with free

hand SQL unless you are an expert in SQL and you know the underlying database exhaustively. Compare this to

using a semantic layer that any business user can consume and no technical knowledge is required. The

business user is completely shielded from the technical complexity and the users are guaranteed the right

results every time. Indeed with free hand SQL it’s not easy to build, understand or maintain the SQL, yet with the

semantic layer the opposite is true and additional analytical capabilities are easier to implement such as

Ranking

Sampling

Query merging

Complex sub queries to meet complex business questions

The semantic layer does more than just generate SQL; it informs the product how ‘BusinessObjects’ (objects)

should behave within the report itself. For example the semantic layer defines the drill path and how aggregation

should be performed within the report. These features ease the building and interaction with the report, so

Use of Semantic Layer over ‘free hand SQL’.

Posted by Matthew Shaw May 8, 2012

Page 5: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 5/22

improving the overall engagement and adoption levels and reducing technical complexity. This isn’t possible

with free hand SQL.

There is no central control over the SQL with free hand SQL. Should the database change, corrections needs to

be made, or improvements made, then each and every document containing that free hand SQL needs to be

inspected and manually updated. Compare this to the semantic layer where one change is made and that

change is automatically propagated to all related documents.

There is no meta-data associated with free hand SQL unlike the semantic layer that provide users with

information such as a description. This provides the user with essential information to what a column (object)

means. The value of a ‘description’ should never be underestimated! Additional meta-data such as lineage

information can also be provided and directly accessible from the report. Lineage information can be provided

automatically if the Metadata Manager tool (for XI3) or the Information Steward tool (for BI4) is used within the

platform for Web Intelligence documents. These tools provide lineage information (where did this information

come from) and impact analysis (what and who will be affected if I change this source system)

The semantic layer is the underpinning of the platform. So it’s easier to adopt other tools on the BI Platform.

These tools provide greater accessibility to Business Intelligence and these tools are likely to be new users to

the BI Platform; thus more of your business will have access to Business Intelligence to make more informed

decisions. Examples of these tools are: Live Office, BI Mobile, Explorer and Xcelsius (Dashboards).

All these points above add to the cost of ownership of the free hand SQL compared to the semantic layer. So if you’re

using ‘free hand SQL’, think again! Think ‘semantic layer’!

1972 View s 2 Comments

Tags: bi, bi4, business_intelligence_(businessobjects), bobj, bi4_upgrade, business_intelligence, universe, semantic_layer

Last week SAP's Derek Wang provided an ASUG webcast on the BI Platform Roadmap, which covered today's

offerings in BI4, BI4 Feature Pack 3 and future direction. Derek recommends checking the SAP Service Marketplace

Roadmap link for official information (SMP logon required).

See steps to navigate the BI Roadmaps on SMP here by JC Raveneau.

Derek Wang is the product manager of SAP BI Platform. His team handles the infrastructure elements of the BI suite.

Note for this blog, the legal disclaimer applies, contains future looking statements, and is subject to change

Derek said they are in the process of updating the Roadmap. This is a preview.

Figure 1, Source: SAP

By BI Platform they mean the underlying support to support the BI tools, repository management, admin tools,

auditing, publishing

This roadmap does not include Infoview, Launchpad – ASUG has another webcast coming.

BI4 Platform Roadmap, an ASUG Webcast

Posted by Tammy Powlas May 6, 2012

Page 6: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 6/22

Figure 2, Source: SAP

Figure 2 shows the roadmap in the official roadmap on Service Marketplace. Left is what is in BI4 GA. Middle column

shows planned innovations for Feature Pack 3. Right is the longer term future direction.

End users see enhanced search, including faceted navigation

New alerting framework allows you to manage by exception

Feature Pack 3:

Figure 3, Source: SAP, in BI 4 Feature Pack 3

You can use SAP Hana as a CMS and therefore manage only 1 database

SSO is empowered by Active Directory and Kerberos

Figure 4, SAP

Derek’s favorite feature for Feature Pack 3 is Insight to Action. A dashboard may have a specific purpose, and you

have a report with a specific purpose, start a transaction – they introduced a way to jump from Analytics to another

Page 7: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 7/22

system. It is empowered by Report to Report Interface (RRI) already used in BW

In past embed a hyperlink in a report but this new RRI is dynamic

Figure 5, Source: SAP

Figure 5 shows OEM enablement and also not if you are an OEM partner . First one is about OEM packaging –

change logo, brand, and selectively include feature you want.

Multitenancy speaks to need to have a single BI system to support multiple tenants and business units. Feature pack

3 has a new tool called Tenant Management by provisioning a new tenant or partner – adding users, folders, etc. It is

a routine process that can be automated.

CMC offers dedicated administration – only see users and folder tab but not licensing keys or authentication. User

Attributes – in the past only import user name and e-mail address – now you can choose other attributes such as

geography, role, or cost center. Use new semantic layer that can use those attributes dynamically such as a where

clause, will help you simplify dynamic filtering at run time.

Figure 6, Source: SAP

Figure 6 shows how it helps system administrations

Hot backup – back up CMS database while the system is running

Monitoring improvements include workflow enhancements

Future Direction

Page 8: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 8/22

Figure 7, Source: SAP

The main goal of next release is deployment process simplification. The goal is to implement system smoothly and

quickly. They want to make the installer more user friendly and quicker – won’t be asked as many questions. They

are looking at enhancing the robustness of the installer, with the ability retry without re-installing the whole thing again

– retry from the point of failure.

You will be able to change to Sybase SQL Anywhere as the default repository database - it is not the only database

you can use – you can use your database of choice.

Server management includes new server configuration tool. Today if you want to split a server in two, it takes a

number of steps. In the future want to automate where possible or guided best practice. It will be a centralized tool.

Software version management – how manage versions – standardize how name software and how to

discover in the About area.

Figure 8, Source: SAP

Figure 8 shows a mock-up. On the left, shows what you do today, if you want to create a server instance to host Web

Intelligence . On the right side, there will be high level choices and the system will do the steps for the product you

want and set up server. Additionally it will conclude firewall and single sign on. They will apply similar design

thinking to similar areas as well.

Page 9: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 9/22

Figure 9, Source: SAP

SAP is continuing to enhance in this area from Feature Pack 3. They will support of new universe in tenant

management tool. As an example, you may have a single universe, logical structure is applicable to multiple tenants

but some tenants may call them differently. SAP is looking at a tool to automate this process.

Resource management in a multitenant environment – give the administrator to proactively manage the service level

They are looking how to do this by weight – this single department can only use resource by 20%. They want to avoid

situation where one single tenant manages all resources. Looking at different services where you may want to have

a VIP class to let them have more resources. They are looking at enhancing server groups - dedicate servers to a

group of users; in current product it is difficult to do. The server can be set up to be exclusive to a particular tenant

Concurrent licenses in a multitenant – how to control this limit per tenant.

CMC will introduce concept of tenant and how to manage. Audit database who has access to what – user group

is in audit database but not easiest way to group for tenancy – looking at tenant audit ID.

Figure 10, Source: SAP

Figure 10 shows the proposed screen with Resource Weight and Concurrent Users and how you can manage via

Properties, using the familiar paradigm in CMC.

Page 10: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 10/22

Figure 11 shows single sign-on to SAP Hana to allow it to be more cross-platform. NetWeaver identity management

integration for multiple SAP systems – as an example, you have a new employee and need to create in multiple

systems.

Today BI tool is not integrated with identity management in SAP NetWeaver. Future process will have more

consistency.

AD/SAP authentication enhancements can be done this today but want to simplify it. Today you do this in CMC but the

process is not always simple.

Question & Answer:

Q: Previously on 3.1 , we have SP , fix pack , LA fix pack. What is feature pack 3 . How does it fit itself

in the total patch lifecycle of BOBJ

A: Feature Pack 3 as I understand it is an "enhancement package" - with new features and some

fixes.

Starting with 4.0 align support model with the rest of SAP

Minor releases and have support packs (every 3 months) and patches

Patches are shipped every 2 weeks

________________________________________________________________

Q: Derek spoke of multilingual support, we found that after the initial install of BOE 4, the only way to

add languages is to do a total re-install. Will FP3 allow to add new languages to our BOE 4 SP2.11

version?

A: Process limitation in 4.0 install to add new language

Multi lingual feature discussed had to do with user content languages

________________________________________________________________

Q: We are planning on installing Data Services 4.0 SP2 or Information Steward 4.0 SP2, can we still

use any SAP BusinessObjects FeaturePack 3 version?

A: There is a version that corresponds to FP3 and Derek will check

________________________________________________________________

Q: Does Insight to Action only support "drill" into SAP and web links? Is it possible to create a "drill"

into SQL server data? Is this functional for people without BW?

A: In Feature Pack 3 this is only available against BW; looking at supporting non-BW sources in

future

________________________________________________________________

Q: You said in the beginning there is Webcast on Mon 5/7 for Server Configuration, I cannot find in

on ASUG Events Calendar

A: The 5/7 webcast is on multi-tenancy under BI4 FP3. The signup link is here:

http://www.asug.com/EventsCalendar/EventDetails/tabid/150/EventID/2930/Default.aspx

________________________________________________________________

Q: When will FP3 be GA

A: No exact date; they are in ramp-up and when criteria is met they will be GA and will only GA when

ready

________________________________________________________________

Page 11: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 11/22

Q: Is the RRI functionality available in all BI4 tools (i.e., WEBI, Analysis OLAP, Dashboards...) as of

FP3?

A: Only Crystal Reports and Dashboards in FP3

Look to expand to other tools in the future

________________________________________________________________

Q: When we apply FP or patch level, it overwrites custom config files. is it fixed in fp3 ?

A: Short answer: no

If follow process to custom config in special place it should not be overwritten

________________________________________________________________

Q: Is Feature Pack 3 compatible with IE9 on Windows 7?

A: Windows 7 – yes, IE9 – not yet

See the PAM – SAP is working on it and will likely come in a service pack

________________________________________________________________

Q: Currently on SP2 Patch 5 - If would like to upgrade to patch 15 - Will it include the FP 3 features?

A: No

________________________________________________________________

Q: How long does it take to install FP 3 ?

A: Depends on many factors

Ranges from 2 hours to a half day

Depends on if it is a clean system

Explorer is an add-on and a separate install

________________________________________________________________

Q: Will FP3 be a full install or will you need to install it over a base install of SP2?

A: You can do either one

________________________________________________________________

Q: When will RRI be available in the other BI tools?

A: No date but on the roadmap

________________________________________________________________

Q: We are on SP2 patch 14...if we move to FP03 now will we lose the fixes introduced in patch 14?

A: Cutoff line was 11; but they are forward fitting into the 3.x patches the best way to find out is to

contact support team

________________________________________________________________

4054 View s 0 Comments Tags: sapmentor, roadmap, bi_platform, feature_pack3

The ASUG Influence Council sessions are planned to be interactive and discussion-oriented, and some will include

presentations from SAP about future product and roadmap direction. This is a unique opportunity for you to give

feedback to SAP about current product development and help SAP set a strategy for the future. SAP welcomes input

from all experienced users at these sessions, so make your voice heard at ASUG Annual Conference May 14-16 in

Orlando.

Session

ID

Title

3801 ASUG Enterprise Information Management Influence Council and SAP BusinessObjects EIM

Roadmap Update

3901 SAP BusinessObjects Semantic Layer (Universe) Influence Council

3802 Influence Update Plus What’s New for SAP BusinessObjects Dashboards 4.0 in Feature Pack

3

3805 Influence Council Update and Working Meeting: SAP BusinessObjects Explorer & Casual

Business Intelligence, BusinessObjects, BusinessWarehouse, SAP Hana and EIM customers, SAPInvites your Input at ASUG Annual Conference

Posted by Tammy Powlas May 5, 2012

Page 12: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 12/22

User

3806 Influence Council: SAP Crystal Reports

3907 Enterprise Data Warehouse (EDW) Influence Council

3810 ASUG SAP BusinessObjects Analysis Influence Council Update

3911 SAP BusinessObjects BI Integration with SAP NetWeaver Business Warehouse and SAP

ERP Influence Council

3807 The Power of Operational Datamarts in the Cloud: Invitation to Co-Innovate

with SAP

ASUG Enterprise Information Management Influence Council and SAP BusinessObjects EIM

Roadmap Update

This active EIM Influence Council focuses on how you can build a data strategy, finding and assessing your

existing data sources, finding relationships and overlaps within your data, creating a "golden record", and

ensuring that the information is actionable for your business across various initiatives. Enabling technologies

and solutions include SAP BusinessObjects Data Services, SAP BusinessObjects Information Steward, SAP

Data Migration services, SAP BusinessObjects Data Quality Management, SAP BusinessObjects Data

Integrator, SAP BusinessObjects Metadata Management, and SAP BusinessObjects RapidMarts solutions. In

this working session, the council will gather upcoming product priorities and use scenarios.

Join the great Ina Felsheim at this session.

SAP BusinessObjects Semantic Layer (Universe) Influence Council

Influence is one of the key tenets of ASUG. The ASUG Semantic Layer/Universe Influence Council will provide

an update on its progress and upcoming plans. But the important part of this meeting is you! This is a chance

for those who build and use a 'universe' to bring their ideas and comments directly to the Influence Council and

SAP. Come and bring your ideas, comments, and concerns about the universe designer. This is your chance

to have your voice heard on product features and direction.

Join ASUG Volunteer and SAP Mentor Derek Loranca and SAP's Pierpaolo Vezzosi

Listen to ASUG News Thomas Wailgum interview Derek about ASUG Influence, a unique benefit to ASUG members.

Influence Update Plus What’s New for SAP BusinessObjects Dashboards 4.0 in Feature Pack 3

Learn about SAP BusinessObjects Dashboards' new dedicated back-end data connectivity, and support for

SAP NetWeaver Business Warehouse and third-party OLAP hierarchies. Understand how Dashboards' new

capabilities will enable you to address more business needs and extend the reach of BI to more users in your

organization. Find out about performance best practices that will help you to deliver an experience that users

will love. This session will include demonstrations of new features introduced in SAP BusinessObjects BI 4.0

Feature Pack 3.

Also come hear about the newly relaunched Dashboards and Visualization ASUG Influence Council.

Join ASUG Volunteer and SAP Mentor Derek Loranca and SAP's Francois Imberton

Influence Council Update and Working Meeting: SAP BusinessObjects Explorer & Casual User

This ASUG Influence Council is for SAP BusinessObjects customers who want to extend the reach of

business intelligence (BI) to all information workers. While most BI tools serve the needs of power users, these

users only represent a small percentage of the information workers, usually less than 10%. The vast majority of

users, those we call casual users, require different tools. The goal of this business council is to have an open

dialog about the best ways to allow more and more casual users to quickly access relevant information and

make fact-based business decisions. We will have an open dialog about current and future developments of

SAP BusinessObjects Explorer. We will also discuss the evolution of this software (exploration views) and

validate the usability and mobility aspect with the team.

0:00 / 10:35

ASUG in Action: Update on Semantic Layer and En...

Page 13: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 13/22

Join Cathy Kennedy and SAP's Mani Srinivasan for this session

Influence Council: SAP Crystal Reports

The ASUG Crystal Reports and Enterprise Reporting Influence Council is intended to represent the collective

customer voice regarding the future solution enhancement direction of the SAP Crystal Reports software

product lines, and also to provide input and direction to the overall solution set for enterprise reporting. The

group will review proposed enhancements for the next release with the intent of helping to shape those

enhancements. The group will also review contribute to the overall vision driving the next generation of the SAP

Crystal Reports product line.

Speaker promises to provide an update on Crystal Mobile solutions.

Join SAP's Mike Seblani for this council.

Enterprise Data Warehouse (EDW) Influence Council

This session delivers the latest updates for the Enterprise Data Warehouse (EDW) Customer Influence

Council. The Influence Council meets monthly and works directly with SAP on EDW initiatives including SAP

NetWeaver Business Warehouse (SAP NetWeaver BW), SAP NetWeaver Business Warehouse Accelerator

(SAP NetWeaver BW Accelerator), and SAP HANA. At this meeting, we will review the findings from the past

year's initiatives, hear from SAP on development updates important to the council members, and solicit new

ideas and members for the EDW Influence Council.

Join ASUG Council Customer Chair Eric Leicht of Kimberly Clark and SAP's Brian Wood for this session.

ASUG SAP BusinessObjects Analysis Influence Council Update

Come and learn about the happenings of the ASUG SAP BusinessObjects Analysis Influence Council,

covering SAP BusinessObjects Analysis, MS Edition for Office; SAP BusinessObjects Analysis, MS Edition

for OLAP; and SAP BusinessObjects Analysis, Edition for Application Design “ZEN”. These are the premium

successors to Business Explorer Analyzer and Web Application Designer. Learn about the SAP

BusinessObjects Analysis Roadmap.

Join SAP's Alexander Peter and ASUG Volunteer Joyce Butler of Cameron International for this session.

SAP BusinessObjects BI Integration with SAP NetWeaver Business Warehouse and SAP ERP

Influence Council

This ASUG Influence Council represents the collective customer voice regarding the direction of future

enhancements for integrating the SAP BusinessObjects BI platform and BI clients with SAP NetWeaver

Business Warehouse (SAP NetWeaver BW) and SAP ERP Central Component (SAP ECC). Focus topics

include data connectivity, metadata leverage, user authentication and authorization, and selected service pack

enhancements.

Join the great Ingo Hilgefort, SAP Mentor, for this session.

The Power of Operational Datamarts in the Cloud: Invitation to Co-Innovate with SAP

This is the launch for a possible customer engagement initiative. Come and find out more at this session.

1635 View s 3 Comments Tags: bi, sapmentor, asug, eim, business_intelligence, saphana

Business intelligence has been a top CIO investment priority for four years running. The return from BI can exceed

the cost of the entire IT budget—for example, a dashboard worth more than $200 million. Yet many companies do not

realize the return and some experience total failure of the BI initiative. Interactively experience how to build a sound BI

strategy that ensures success.

What is the BI Strategy Assessment?

Understand the importance of a clear, well articulated BI strategy. Find out how an effective BI approach benefits IT

and line of business teams alike, from aligning business partners and formalizing business needs, to removing

limits of a departmental focus. Explore critical success factors for developing and delivering a comprehensive BI

strategy that identifies a shared set of goals and delivers planned results. Learn best practice approaches to

executing this plan enterprise-wide, including guidelines to define and run a successful BI competency center. Hear

key recommendations to achieve high-level executive sponsorship that can help mandate change and organize

cross- functionally for an enterprise-wide approach and outcome. Come away with a repeatable framework that

engages and brings together the priorities of both CIOs and business executives to address organizational

challenges that a BI strategy can resolve.

Try the BI Strategy Assessment today

BI Strategy Assessment Online

Posted by Nic Smith May 5, 2012

Page 14: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 14/22

3274 View s 0 Comments

Tags: businessobjects, xcelsius, reports, bi, hana, crystalreport, business_intelligence_(businessobjects), mobile, in-

memory_business_data_management, strategy, explorer, reporting, dashboards, crystal_reports, assessment, tool, online

***** Newsflash - if you are interested in "Elite" training for BI4 - check-out our BI4 Elite enablement event in

Vancouver, Nov 5-9, 2012 ****

Whether it's hot topics like "mobile", "big data", "social media" or concrete project needs such as tighter integration

with BW, connectivity to HANA or improved ways to extend Crystal reports with JavaScript, the BI4 Feature Pack 3 has

a lot to offer.

The individual product roadmap can be found at http://service.sap.com/roadmap so you can expore in more detail

what is new in BI platform, Webi, Analysis for Office and OLAP, Crytal, Dashboards, mobile etc (direct links below).

But if you are part of the Ramp-Up program (be that as an implementer, partner or customer) you can not only read

about BI4 FP3 - you can get hands-on in the system and experience BI4 FP3 for yourself.

We have various hands-on workshops coming up - in Walldorf, Philadelphia and Syndey - and virtual workshops on

top of that.

You can find workshop info at this link or below (S-user required):

Classroom

RBI405: SAP BusinessObjects Business Intelligence 4.0 Feature Pack 3

May 07-11, 2012: Walldorf (Germany)

Participants accepted by approval only: Course fee € 1250,--

Enrollment Request

May 21-25, 2012: Philadelphia (US)

Participants accepted by approval only: Course fee: $ 2000,--

Enrollment Request

June 19-12, 2012: Sydney (Australia)

Participants accepted by approval only: Course fee: AUD 1250,--

Enrollment Request

Virtual Labs

RVI405: SAP BusinessObjects Business Intelligence 4.0 Feature Pack 3

Apr. 30 - May 04, 2012: Starts 09.00 AM EST (US)

Participants accepted by approval only: Course fee $ 2000,--

Enrollment Request

May 21-25, 2012: Starts 09.00 AM CET (EMEA)

Participants accepted by approval only: Course fee € 1250,--

Enrollment Request

Be one of the first to get hands-on with the new BI4Feature Pack 3

Posted by Jens Koerner May 2, 2012

Page 15: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 15/22

As mentioned above you can find product roadmaps at http://service.sap.com/roadmap for most SAP Products. The

direct links for the BI roadmaps with more details on the new features can be found here:

Product Road Maps

SAP BusinessObjects Analysis, edition for application design Edition 2012

SAP BusinessObjects Analysis, edition for OLAP Edition 2012

SAP BusinessObjects Analysis, edition for Microsoft Office Edition 2012

SAP BusinessObjects BI platform Edition 2012

Self-service access to SAP BusinessObjects BI Edition 2012

SAP BusinessObjects BI Suite Mobile solutions Edition 2012

SAP Crystal Reports for Enterprise Edition 2012

SAP Crystal Reports 2011 Edition 2012

SAP Crystal Reports - Developer Resources Edition 2012

SAP BusinessObjects Dashboards Edition 2012

SAP BuisnessObjects Explorer Edition 2012

SAP BusinessObjects Live Office Edition 2012

SAP BusinessObjects Web Intelligence Edition 2012

For general questions concerning SAP BusinessObjects Business Intelligence 4.0 Feature Pack 3 Ramp-Up classes

please contact [email protected].

2184 View s 0 Comments

Tags: bi, bi4, hana, crystalreport, business_intelligence_(businessobjects), mobile, bw , bi4.0, dashboards,

sap_businessobjects_mobile, analysis, bobj, analysis_edition_for_microsoft_off ice, bi4_upgrade, business_intelligence,

sap_businessobjects_business_intelligence_platform_4.0, sap_businessobjects_explorer_4.0

Thank you everyone for your submissions to the "I" in B"I" contest. This challenge was designed to encourage the

community to share their stories and best practices in the world of business intelligence. Although we were

constrained by some legal rules and could only keep it to North America, I'm happy to see the community was willing

to share their interesting stories. And even though the contest is now officially over, please continue to share your

stories in the use of BI.

And now for the winners....

I’m proud to announce the winners of the “I” in B”I” contest are:

1. Krishna Tangudu with a tale of his beginning journey through the world of BI. Read his perspective and offer

your advice and guidance as pros and compadres along the same journey. I wish Krishna the best of luck in his

planned use of HANA on his humanitarian project.

2. Bala Prabahar who took us down the database memory lane as he told his tale going from Informix to In-

Memory. Read his blog and get his take on how BI has evolved over the years.

3. Ken Hartman who has lived multiple lives as a BI consumer, evangelist, purveyor and also became an SAP

Mentor for the BusinessObjects products. Read his journey and learn how much BI usage has increased

over the years.

And a special thanks to Tammy Powlas who not only told her B"I" story but continually shares her knowledge of BW

and the use of BusinessObjects technology and was especially helpful in offering guidance in the development and

promotion of this challenge. It is humbling to learn and hear from all of you who are out there pioneering the use of BI

everyday!

Krishna, Bala and Ken, please contact me at [email protected] for prize details.

1789 View s 2 Comments

Tags: xcelsius, crystal, reports, crystalreport, report, business_intelligence_(businessobjects), analytics, mobile, bi4.0,

explorer, reporting, dashboards, crystal_reports, analysis, analysis_edition_for_microsoft_off ice, analysis_edition_for_olap,

business_intelligence, sap_businessobjects_business_intelligence_platform_4.0

And the winners of the "I" in B"I" Contest are...

Posted by Emily Mui Apr 30, 2012

My "I" in "BI" Story

Posted by Tammy Powlas Apr 28, 2012

Page 16: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 16/22

In a galaxy far far away...well, maybe not too far away for some

My journey began as a Budget Analyst in Kansas City for a quasi-federal government agency. I learned how to do SAS

programming on the mainframe. I was able to quickly combine 5 field offices' data into regional data for the

Washington DC headquarters office. That made me such a valuable commodity that I received an offer to relocate to

Washington, DC. Because I was interested in obtaining my master's degree outside of the Kansas City area, I made

the move.

I still remember the SAS commands PROC MEANS NOPRINT; Once in DC, I was able to create detailed asset

balance reports, key performance indicators, etc. all in SAS, and yes, all on the mainframe. At the time, attending

class was a luxury so I only attended one SAS class. Because of my experience in SAS, and my government term

was ending, I moved on to work for a telecom company. There, I did SAS financial reporting on depreciation, and

reconciled subsidiary systems, yes, all via SAS.

My SAS skills were so valuable I was asked to join the SAP team. I lead our projects & assets team. I learned the

SAP Query tool, Report Painter, Report Writer. For years I was a functional finance consultant. Then I left for another

company, where I learned SAP Funds Management module. We decided to upgrade to SAP 4.6c, however, SAP told

us they would no longer support hierarchical reporting - a big must for Funds Management. They recommended we

use BW. Hence, I wrote functional specifications for BW. Soon, the BW team left, I applied for the position with no

experience in BW! What an adventure...

I learned BW 3.5, 7.0, but with my functional skills I was in a position to reconcile extracts and loads. I optimized BW

process chains; learned BI Content; learned the BEx Web Application Designer and the BEx tools. Along the way, I

earned my SAP BW certification. Not for job prospects, but I learned way more about BW that way. Suddenly, I could

answer our Security team's questions about Analysis authorizations.

I made another job change, this time for an easier commute, learning BusinessObjects with SAP along the way. I've

had great SAP help, through ASUG, to always learn more about BI, with great thanks to SAP's Ingo Hilgefort,

Alexander Peter, and Katie Beavers, formerly of SAP. I've also learned so much more by giving back to the

community, via ASUG and the SAP Community Network, and I encourage others to do the same.

406 View s 5 Comments Tags: sapteched, sapphirenow , i_in_bi

“I Wanna Go Fast” – Ricky Bobby Some of you may remember that line from Will Farrell’s ‘Talladega Nights’. As a NASCAR driver, I’m sure that it is part

of your job description that you have to have an inclination for wanting to drive at high speeds. I’ll admit that given

the chance I’d want to take a few laps around a NASCAR track.

So what does this have to do with Business Intelligence (BI), well, pretty much everything these days. Can’t you

hear it? If you can’t then you haven’t been listening to your users. In every hallway, cubicle, executive office there

is the chattering of “I want to analyze my data, and I want to be able to get to it Fast!” No one wants to wait for

the results to come up on the screen, I don’t care if it is a report, data dump, or a dashboard (and by that I mean a

true dashboard – you know, the kind Mico Yuk would be proud of – not a report posing as one) our users are

looking for results that appear in under a few seconds. To make matters more complicated, users want to be able

to sift through their data, lots of data, without having the burden of knowing how to formulate a query. Did I

mention that they also want to be able to change data filters, analyze the data the way they think and changing

their analytical quests on the fly? All of this, and don’t forget their mantra “I wanna go fast!!”

Queue the arrival of in-memory analytics. Is this the panacea to the BI conundrum, served up on a silver appliance?

This concept is not necessary new, we all know that accessing information via memory rather than searching on a

physical disk is much faster, and in the world of BI this is where the money is at – figuratively and literally.

So why is it taking so long for us to get there? One problem is older systems, and by that I mean 32-bit operating

systems, can only provide up to 4 gigabytes (GB) of addressable memory, a pittance in the analytical world. Now,

here we are over a full decade into the 21st century and 64-bit OS’s are making their way into our data centers,

replacing old 32-bit servers. With the ability to provide up to 1 terabyte (TB) of addressable memory it is now

possible to cache large volumes of data into RAM. Can I get an “AMEN”? What’s that? Oh, right, many of us still do

not have 64-bit OS’s on our desktops; we will take a look at how that affects this solution later.

But I digress, it is a fact that incredibly fast query times will bring back the data faster, hence reducing the time a

user has to wait for their report or dashboard. As the cost of RAM drops, the idea of in-memory analytics becomes

more of a reality for even the most frugal of businesses. It has been touted by BI and Data pundits that the use of

in-memory analytics can reduce or eliminate the need for data indexing and pre-aggregating your data in cubes or

'In-Memory' of Traditional Analytics - Part 1

Posted by Ken Hartman Apr 27, 2012

Page 17: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 17/22

tables (tell that to a DBA).

Sounds great, right? I mean if using in-memory solutions reduce IT costs and allows for faster implementations of BI

and analytic applications, all while providing users the speed they desire then it should be a no brainer. After all, we

hear the users (and ourselves) saying that getting results faster by shortening the query times supports faster

business decisions. That’s the theory anyway and I will delve more into this in the next part of this blog when we

take a look at the in-memory solutions and take a peak behind the curtain – now where is that wizard…?

268 View s 0 Comments

Tags: bi, sapmentor, hana, business_intelligence_(businessobjects), analytics, in-memory_business_data_management, bobj,

business_intelligence

As with most of us, ‘B’efore I’ was a BI evangelist, BI consumer, BI purveyor of all things Business Intelligence, I had a

typical – or maybe not so typical – start in the IT industry, one that goes back 26 years.

I started my journey working as a procurement agent for a computer manufacturing company that specialized in

“Tempest” systems for the DOD and NATO. From there I wound up as an application developer and DBA for a

defense contractor, then a systems analyst for an insurance company, an SQA manger for a consulting

company…..whew, I need to take a breath. Then if that wasn’t enough I got to spend a lot of time in England working

for a company marketing technical remediations for the “turn of the century scare”.

I had yet to venture into the world of BI – at least not in the way that I see it now – but we are getting close to my

indoctrination. After working as a development manager for a major communications company I eventually ended up

at Hughes Network Systems (HNS). It was here that I dipped my toe into the proverbial wellspring of the BI

datastream and became a full-fledged component in the global BI ecosystem.

I was hired to establish and then manage a corporate enterprise business intelligence group, a new an utterly foreign

concept to the organization. I was not hired because I knew what BI was or had years of experience in BI; after all, to

me it was a buzzword, much like “paradigm shift”, or “game changer”. You see, the truth of it all is that my long

meandering career path had one thing in common, one thing that virtually connects all of us in this industry together –

I was working with data, all sorts of data. I was building applications and systems that allowed users to view, analyze,

disseminate information and make strategic (and sometimes not so strategic) business decisions – do you

remember the term Decision Support Systems? I was at the core of BI and didn’t really even get it, sort of the forest

for the trees kind of thing. So here we are my first established BI role; Manager, Business Intelligence Applications at

HNS. I was now empowered to establish a group that could maximize the use of data in a way that the organization

had not experienced before. SAP ERP 4.6 was just being implemented, there were a number of existing Data Marts,

Essbase Cubes, a custom billing database and PeopleSoft CRM system – a bounty of data that was just waiting to

be mashed-up, blended and analyzed and I was tasked with finding a solution that could seamlessly work with all of

these systems – a tool suite that was to become the backbone of HNS’s Enterprise BI solution. I spent ten years at

Hughes nurturing the BI space, educating users on the system and tools (which just happens to be what is now

called the SAP BusinessObjects BI Platform). The analysts at Hughes were now able to perform such analyses as

evaluating the performance of their cost centers, ranking and analyzing what were the most common issues reported

to a call center; performing predictive analysis of failed components on returned equipment and equipment out in the

field to pre-emptively replace equipment that had the potential for early failure; they were able to do data-mash-ups

between their Peoplesoft CRM and SAP Sales and Delivery applications; provide formatted and custom usage and

failure reports to their customers; proactively monitor product builds and procurement buys to ensure that component

deliveries were able to be expedited or delayed based on changes on the manufacturing line saving the company

form additional inventory costs.

I have since moved on from Hughes, but not from BI. Over the last 16 years I have been active in the BI ecospace – I

have presented at SAPPHIRE and BusinessObjects User conferences, am actively involved in the BI community, had

the opportunity to sit as a Steering Committee member on the Global BusinessObjects Network (GBN), became an

SAP BusinessObjects Ambassador and ASUG volunteer, and had the opportunity to become an SAP Mentor for SAP

BusinessObjects. All in all, my BI story has been a great and continually evolving journey. I have worked with,

networked, and befriended some of the most influential and incredible people in the industry. I have had opportunities

to share my ideas and my experiences, to inspire others to push farther that I have gone, and have been be pushed

by my peers to go farther myself. This is my story; “I” am an integral component of the BI ecosystem.

470 View s 0 Comments

Tags: scn, bi, sapmentor, business_intelligence_(businessobjects), business_intelligence, bi_platform, bi_story

I'm Ken and this is my B"I" Story...

Posted by Ken Hartman Apr 27, 2012

Consolidating dimension values under the tag "AllOthers"

Page 18: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 18/22

Hi All,

Recently I had come across a requirement of consolidating a list of values in a dimension by showing only Top 5 and

remaining as "All Others". I am sure many of us would come across such a requirement and the following

methodology helped me with the same.

I will demonstrate the same with e-Fashion as data source.

For my demonstration, I brought in City, Sales($) as a part of the data provider.

Firstly, create a measure which should do a ranking on the Sales ($) Rank variable.

Secondly, create a dimension (be careful, this has to be a dimension) which should use the rank object created to

build the logic as shown below

And the output would like this

Posted by Sanjo T Apr 26, 2012

Page 19: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 19/22

This shows that the values from Rank 6 onwards are conslidated under "All Others". Idea is we have to use some

sort of measure in dimension to apply this logic. It can be a count, rank or whatsoever you can think about. The "if

loop" in the dimension variable acts like a "for loop" in java or elsewhere, wherein it gets rank 1, and puts in the

corresponding [City], then rank 2 and puts in the corresponding [City]. This will continue until [Rank]<=5. But once it's

over this rank, the condition fail and goes to "All Others" until the end of the list and the measure which is Sales ($)

aggregates (this is also important, your measure needs to aggregate) accordingly.

There are more tricks around "All Others" of which one of them I will cover here and the remaining in another blog of

mine which will be a Part 2 to this blog. There are few things that we need to take care in Cross Tab as against

Vertical table and for All Others which will be explained there.

Just in case you wanted to Sort the Sales Revenue in Descending order and always want All Others as the last one in

the table, this is what you should do.

First create a dimension variable with the following logic as shown below:

Insert it into the block and then sort the [var_Sort_AllOthers] column in ascending order

Then sort the Sales Revenue column in Descending order.

You can then hide the unnecessary columns like making width to 4px and other cosmetic works based on your

needs.

Hope this helps in some way.

Thank you.

Best,

Sanjo

183 View s 0 Comments Tags: all_others

My first experience with BI - by 2 SAP Mentors

Posted by Jason Cao Apr 19, 2012

Page 20: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 20/22

Have you seen Emily Mui's blog post yet about " Putting the "I" back into BI?" She's looking for your personal

stories - trials and tribulations using business intelligence. This is a great opportunity to share your experience from

the trenches, so that others can benefit from your expertise (and maybe even have a few chuckles along the way). For

those willing to share their stories, those members in America may even win free passes to SAPPHIRENOW or SAP

TechEd, and be invited to tell their BI stories to conference attendees. (Check out Emily's blog for instructions and

eligibility for these passes.)

Meanwhile, here's a couple of our SAP Mentors ( Greg Myers and Eric Vallo) sharing their stories about "first

experiences" with BI. Enjoy!

903 View s 0 Comments

Tags: bi, teched, contest, sapmentors, bobj, sapphire_now , business_intelligence, greg_myers, eric_vallo

0:00 / 1:49

I in BI with SAP Mentors

One of the greatest statements in 2010, from my side, was a Gartner statement made by Mark P. Donald,

when he stated 'without business in business intelligence, BI is dead’. He condensed four years of my

research brilliantly into a single sentence. By 2006 Gartner started reporting that BI projects were not meeting

business expectations. Then in 2011 Gartner once again reported that the world spent $11.2 billion on BI in a

fuzzy background that less than 50% of these projects would meet business expectations. Then in April 2012

ZDNet reported that there is a reported wastage of $6.2 trillion though it remains largely unverified by reliable

resources. However, one thing is certain that BI projects are consistently failing to meet business expectations

and with HBR publishing that good data alone does not assure good information all the pieces better fall into

place.

Over my 15 years of BI experience I can state with fair confidence that there are few companies that do not feel

their BI is in a deep crisis. Each executive and CIO is wondering whether it is the HW, SW or their

implementation partner that is at fault. If you ask me the answer is both yes and No.

In order to find this solution we need to go back two decades when it took two people four to six weeks to

prepare six reports for the board meeting and there was no questioning whatever the executives got once or

twice a year. Fast forward to 2012 and we have invented hardware that can compute millions of time faster, and

softwares that can perform technical miracles when compared to what it could do in 1987. In 1987 we needed

two resources to provide corporate and executive reports, by 2012 we need a team of twenty to thirty experts

to keep the complex technology humming. We are all specialist now and hold a lot of information about a small

part of the whole solution. We have unfortunately created teams of Technocratic workers who have little idea of

the forest as they continue to clip leaves on a tree. What we need today is business value workers who are

explorers and not technocratic cowboys.

Spend a little to plan and save big time in error fixing later: Our research indicates that the current

technocratic designs mean that more than 50% of BI project live in a state of comatose existence, over 60% of

our data warehouses are designed to strategically fail, and that ovr 65% of technical doctors that go to take

care of sick data warehouses do not end with an improvement to the health of the information delivery

capability. The writing is clear on the wall that we need business value workers for two reasons, the first being

the unmanageable costs of BI projects and the second the low business value being derived from them. In all

this we must not forget that when we go from a world of PC's and two resources working on Lotus 123 for six

weeks to prepare six reports to one were we generate hundreds of reports from tens of terabytes of data the

How to extract both Business & Intelligence from BIprojects

Posted by Hari Guleria Apr 18, 2012

Page 21: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 21/22

costs cannot

possibly remain

the same.

The differences:

In 1987 we used

to deliver reports

on what had

happened last

year, quarter or

month and our

management was

only reactive. By

2002-3 we started

delivering

analytics where

we started

analyzing trends

and moving more

towards

performance

analytics that was

summarized automatically. We efficiently merged planning data with global actual numbers or conducted

spend and vendor performance. By 2009 we commenced on a path to predictive analytics and entered the

world of informatics and bioinformatics. By this time though the technology had matured the systems to design

it had not yet become scientifically driven. We could now summarize global data into daily views for our

executives and came to the new world of predictive analytics. Now we did not wait for events to happen but

could actually predict it in near real-time. For example it was then possible to to visually see the full global

supply chain with connections to supplier systems and see a process weaken and immediately ripple across

the supply chain. Companies were able to now react to the future. By 2011 we entered the world of true-real-

real time. I use the double real-time for we had misused it in the past. Now we can conduct CO-PA analytics

and see the situation of a campaign or trade promotion as it stands right now. We can see shelf space

utilization as it stands right now across thousands of retail outlets across the state, country or planet. But

unfortunately we still continue speeding the technology path where we deploy BI project successfully but they

often do not deliver business expectations or values. This is where BVA, or Business Value Attainment,

principles based on scientific standards and processes comes in.

Our solutions come from something as simple as data, pure empirical data. When we reviewed all the

complexities in the data we suddenly realized that the most expensive BI projects did not result in the best

information and vice versa, i.e. the best BI projects were not the most expensive ones.

What this means is that there is Hope for each and every one of us, because if only the most expensive

projects were most successful then it would indeed be very disheartening for all but the largest corporation -

but thankfully this is not the case.

When we analyzed the positive deviance a little further we found that the ones that were most successful

looked more and more like scientific systems. All the evidence prove that simply having the most expensive

technocratic components is never enough. In fact it turns out to be a big disadvantage as these projects then

gedt driven by technocratic arrogance, based on an unbending faith that ‘technology is king’. These costly

projects end up with a pile of expensive components that do not run like a well-oiled system and each issue

has each group of experts pointing their fingers the other way.

Our research also established that scientific systems have inbuilt checks and measures.

Skill 1: Scientific systems have an ability to identify success and failure. The issue is that specialized

technocrats can only see the small section of their specialization, and super specialists can see even less and

both these workers can never do any form of predictive analytics – i.e. what will the impact of this step be 2 or

3 years from today to the enterprise information capabilities

Skill 2: Scientific systems devise solutions by eliminating defects. Tradition technocratic solution to any

problem is to either buy a bigger HW, a

new SW or send their resources for more specialized training but when we viewed the DW and BI ecosystem

all we found were more and more experts, who actually did not solve but exasperated the problem.

Skill 3: Scientific Systems eliminate defects with Checklists: When we analyzed how critical components

were managed we found an abundance of checklists. Pilots use them, engineers use them and today even

cowboys use them. Checklists do not tell pilots how to fly a plane but it is a reminder of critical things that are

often forgotten or get missed and that can potentially lead to a disaster.

There is no clear recipe for success but there we did manage to build a checklist for eliminating failures. Over

the last 6 years we have implemented these methodologies, that we call BVA or Business Value Attainment in

4 projects and achieved exceptionally high success. Each of our projects scored in the upper 90% project

satisfaction in week 1 and week 30. I state this for one of our research indicated that ’98% of BI projects are

Page 22: Bi platform   scn15

6/3/2014 BI Platform | SCN

http://scn.sap.com/community/bi-platform/blog?start=210 22/22

Follow SCNSite Index Contact Us SAP Help Portal

Privacy Terms of Use Legal Disclosure Copyright

declared successful in week 1, and less than 50% of them remain successful by week 10’ Gartner and BI

Valuenomics research.

The last skill we collectively need is the ability to implement these established scientific methodologies.

Despite its established success we found it surprisingly slow to implement. Read my blog on Moneyball and

BI’ as it explains this dilemma. These new 'scientific principles' (due for publishing in Q3 of 2012 in a book)

challenge the status quo and current value systems. It challenges things the technocrats have been doing for

too many years. It requires us to work with with humility and replace our technical arrogance, it requires us to

work with Business and IT as a single team and replace technocratic isolation, and it requires us to work with

scientific principles and checklists where we though we knew everything and where a 50% failure rate was a

done thing.

Today establishing scientific principles in everything is our greatest path forward in order to enhance quality

and lower costs via a process of defect elimination. Taylor did it in the 1911, Ford carried it to the next level by

1921 and the flame was carried by Demings and then when Drucker coined the knowledge worker. We have

now come to an infliction point where we all need to evolve from 'knowledge workers' to becoming 'Business

Value Workers', i.e. become better Business Value owners and less of technocratic dictators

that march only to our own drum beats. The writings are clear it now only depends on who all are ready to read

it.

944 View s 0 Comments

Tags: business, intelligence, bi, hana, analytics, strategy, data, bobj, w arehouse, scientif ic, principles, businessobject

1 … 13 14 15 16 17

PreviousNext