8 Core Beliefs of extraordinary bosses

What’s the fundamentally different understanding of workplace, company and team dynamics according to the best managers?
Enclosed an overview of the “8 simple rules of being an extraordinary boss”:

1. Business is an ecosystem, not a battlefield.
2. A company is a community, not a machine.
3. Management is service, not control.
4. My employees are my peers, not my children.
5. Motivation comes from vision, not from fear.
6. Change equals growth, not pain.
7. Technology offers empowerment, not automation.
8. Work should be fun, not mere toil.

The entire article, written by Geoffrey James, can be read, following this link

Ten reasons customers choose SAP HANA to help transform their business

Enclosed a PDF, pointed out to me by a colleague, explaining (convincing?) customers why they should acquire SAP HANA. It’s all about SPEED, AGILITY, ANY DATA, INSIGHT, APPLICATIONS, CLOUD, INNOVATION, SIMPLICITY, VALUE and CHOICE.
Enjoy the reading….

 

Cibers klantencarrousel: SAP BI – the road ahead

Afgelopen donderdag, 15 maart 2012, vond de 5e editie van Cibers klanten carrousel in de Efteling plaats. Op deze geslaagde carrousel hebben Roel van Bommel en ondergetekende het plezier gehad een presentatie over de verander(en)de toekomst van SAP BI, vandaar de subtitle “who moved my cheese”,  te mogen geven aan ongeveer 60 belangstellenden.

Bijgevoegd de presentatie, helaas zonder de ‘embedded’ filmpjes:

Federated-, Decentralized – and Centralized DataWarehouse

When I was browsing the net, looking for more information regarding federated-, decentralized – and centralized datawarehouses, I came across a great article by dr. Berg. Herewith a brief summary of his article.

 

Federated Data Warehouses are best in very large organization where development is separated by geography, organizational boundaries, or where multiple data warehouses exists due to mergers & acquisitions.

Federated Data Warehouses

Federated Data Warehouses

To make FDWs successful, there needs to be a rapid convergence to standardized technologies. This include:
  • Same type of databases and support pack levels (costs and compatibility)
  • Same technical platforms Hardware, Backups and Archiving (costs)
  • Shared Portal and user interface strategy (reduced training and support)
  • Shared security design and centralized administration (risk management)

If the data is federated you gain faster response time to business needs, can execute multiple projects in parallel, and work 24/7 across the globe. But without any standardization, it can also be very costly.

 

Centralized Data Warehouses are great for small and mid-size data warehouses (less than 15-40Tb). There are great benefits in terms of the ease to mange upgrades, support packs, enforcing development standards, transport control, master data management and the overall total cost of ownership. To make CDWs successful, there needs to be:

Centralized Data Warehouses
Centralized Data Warehouses
  • Adequate funding of hardware, application servers, database servers
  • Serious consideration should be made to move BI and reporting to BWA
  • Focus on using the database capacity on storage and data loads– not queries
  • No direct reporting from DSOs (takes too much system resources)
  • Broadcasting , caching and performance tuning is a dedicated support effort
  • A plan for data partitioning and archiving needs to be in-place as soon as the system exceeds 5-8 TB.

If the data is centralized it is faster to develop new solutions for the business and merging from different data sources are easier.

 

A Decentralized Data Warehouses makes sense if there are logical division between business units, geographies and little shared reporting. I.e. in a conglomerate organization with diverse business units. The benefits of DDWs include the flexibility of the FDW with the technology standardization and lower cost of ownership of the CDW. To make DDWs successful, there needs to be:

Decentralized Data Warehouses
Decentralized Data Warehouses
  • A formal Masterdata Management (MDM) strategy with clearly defined standards
  • A rule based data cleaning and data integration plan for centralized reporting
  • A shared hardware location to keep costs lower
  • Tight integration with upgrades, support packs and interface standards

With DDWs there is a risk of creating stove-pipe data marts that cannot be integrated at the corporate level without very high costs.

High Definition Business Intelligence

Bijgevoegd een artikel van Gertjan Harberink omtrent High Definition Business Intelligence, een samenvatting van de keynote van Timo Elliott gehouden tijdens het Heliview BI & Datawarehousing congres 2012:

 

High Definition Business Intelligence: Wat is het verband tussen fotografie en de nieuwe generatie Business Intelligence tools die profiteren van In-Memory Computing? Tijdens een boeiende presentatie op het Heliview BI & Datawarehousing congres in ’s-Hertogenbosch gaf BI-visionair Timo Elliott het antwoord.

De tijden veranderen razendsnel. Nog niet zo heel lang geleden had iedereen nog gewoon een analoge camera met een filmrolletje. Je maakt voorzichtig je foto’s en als je ze wilde laten ontwikkelen, bracht je ze naar een expert. Na een tijdje haalde je de foto’s weer op. En als je ze eenmaal in je hand had, waren ze eigenlijk toch net wat minder mooi dan je verwachtte. Volgens BI-visionair Timo Elliott geldt voor de eerdere generaties BI-tools iets vergelijkbaars. “Je was afhankelijk van experts die je rapportages bouwden. Je moest er lang op wachten. En het eindresultaat was nooit precies zoals je het zou willen.” Die tijd is voorgoed voorbij, stelde Elliott tijdens zijn presentatie. “De nieuwe tools voor analytics maken dat je nu de informatie kunt bekijken die je wilt hebben. Zoals je met een digitale camera nu de foto’s maakt die je wilt maken. Doe je het niet goed, dan probeer je het opnieuw. Door de opkomst van digitale fotografie zijn we allemaal betere fotografen geworden. En dankzij Analytics kan ik nu écht dingen veranderen en bijsturen voordat ze me raken.” Elliott maakt nog een andere vergelijking. “Net als digitale fotografie kan ik met BI makkelijker inzoomen tot op detailniveau. De resolutie is groter. Dit is High Resolution Business Intelligence.”

Cray supercomputer
Timo Elliott weet waar hij het over heeft. Visionair en BI-evangelist Timo Elliott is al meer dan 20 jaar werkzaam in de wereld van Business Intelligence. Tegenwoordig is hij Senior Director of Strategic Marketing van SAP BusinessObjects. Tijdens het BI-event van Heliview sprak Elliott over de gouden combinatie van Analytics en In-Memory Computing. Elliott was de eerste om te bekennen dat In-Memory computing waar nu zo hoog over opgegeven wordt, al jaren beschikbaar is. Met dat verschil dat de stand van de techniek nu ver genoeg is om ze ook daadwerkelijk in te zetten voor alledaags gebruik in een kantooromgeving. Bovendien is de prijs van geheugen nu heel laag. Pure rekenkracht ligt nu voor iedereen binnen handbereik. Nog niet zo lang geleden was de Cray supercomputer het summum van rekenkracht. Nu heeft een gewone iPad evenveel in huis als die vele miljoenen kostende machine.

Elliott voorziet een mooie toekomst voor BI. Tijdens zijn sessie presenteerde hij een staatje van Gartner waaruit bleek dat Analytics en Business Intelligence in 2012 op nummer 1 van het prioriteitenlijstje van CIO’s staat, gevolgd door mobiele technologie. Ook het geld dat vrijgemaakt wordt voor BI groeit elk jaar gestaag.

Hadoop
De mogelijkheden die BI op dit moment biedt, zijn dan ook enorm spannend en gaan bovendien razendsnel. Hadoop bijvoorbeeld, een methode om enorme hoeveelheden ongestructureerde data gedistribueerd te verwerken en te analyseren, biedt geweldige mogelijkheden op het gebied van Big Data. Een andere bijzondere ontwikkeling is de inzet van sensors, bijvoorbeeld om de kwaliteit van versproducten continu te meten en real-time inzichtelijk te maken. Een andere niet mis te verstane ontwikkeling, is de opkomst van Mobility. “Er zijn op dit moment meer mobiele telefoons op de wereld dan tandenborstels”, aldus Elliott. Door deze massale aanwezigheid van mobiele apparaten, voorziet Elliott een belangrijke rol voor point-analytics; heldere, persoonlijke apps voor je iPad of smartphone die een hele specifieke, rolgebaseerde dataset weergeven. Precies wat je nodig hebt om je werk te doen.

Elliott geeft verschillende voorbeelden van bedrijven die al op bijzondere manieren gebruikmaken van analytische tools en In-Memory computing. Diervoedergigant Provimi bijvoorbeeld, bespaarde vele tienduizenden euro’s nadat het bedrijf haar hele ERP-systeem in het werkgeheugen stopte. Tegenwoordig krijgt het Provimi steeds meer zicht op afzonderlijke SKU’s. Een ander succesverhaal is dat van Fresh Direct. Dit bedrijf verhoogde het aantal tijdige leveringen van 91% naar 99%.

Toch steekt er één ding bij Elliott. “Hoe komt het dat iedereen het eens is over het belang BI, maar dat nog maar 20% van de markt het gebruikt. Het antwoord? We praten met z’n allen véél te veel over de techniek en luisteren veel te weinig naar de klant. Want BI gaat niet alleen over techniek, het gaat ook over gebruiksgemak.”

Meer informatie
Voor diepgaande technische informatie, boeiende experiences die de kracht van SAP HANA in combinatie Analytics laten zien, verwijst Elliott tot slot naar de site www.experiencesaphana.com, kijk ook op www.sap.nl/hana voor meer informatie.

Everything you always wanted to know about Big Data, but were affraid to ask :-)

When I was investigating and reading about “Big Data”, I stumbled across the article below (written by Tom Breur of XLNT computing) which I’d like to share with you all:

“Big Data”

Our society is overflowing with data, and these data volumes keep growing at an unprecedented pace. Global growth in data volume is estimated at a staggering 60% per year, or about 10-fold in five years. Nothing seems to stop this tsunami coming in. Relational, SQL-based architectures don’t scale sufficiently to deal with this growth of -in particular- unstructured data. McKinsey’s Global Institute has labeled this trend “the next frontier for innovation, competition and productivity.”

1. “What Is “Big Data”, Really?

Nobody seems to agree on what “Big Data” really stands for. It is clear, though, that there’s a “big” hype involved. There is no agreement on a common definition, or even order of magnitude (for data) or appearance. Volume and diversity of data types seem common denominators. Since storage providers have been most eager to jump on this bandwagon, one would assume that disk space must be a differentiator. We would argue that “Big Data” signifies a sea change away from traditional relational formats. End-user needs that are driven by unprecedented low latency and scalability demands, are driving a search for alternative solutions to common data challenges. This originated largely with corporate powerhouses like Google, eBay, Facebook and Twitter that have led the way in leveraging gargantuan data volumes.

Unless you have (very) large volumes of unstructured or semi-structures data, and you need to analyze these in (near) real-time, then most likely the problem can be solved with “traditional” (RDBMS) means. Why would you resort to relatively new, quirky solutions like Hadoop, and a bewildering array of NoSQL solutions? Development is largely a step back in time when you submit your needs to nerdy so-called “data scientists” (see also tip# 6), relying on not-yet-widely-used technology. Unless there is a business case for going massively parallel (see also tip# 4), traditional (familiar) relational database management systems will usually be a lot more comfortable and easier to manage.

2. “Big Data” Involves A Change In BI Architecture(s)

Traditionally, BI was a downstream process from business operations. A source system created some data that were extracted and warehoused, and subsequently made available to the business.

When the pressure on BI is to deliver data faster, physically moving data interferes with the need to make these data available more quickly. Because of redundancy in storage, such architectures are less feasible for Petabyte scale data volumes. As a result, “Big Data” business intelligence solutions tend to be much more enmeshed in operational solutions, living alongside rather than downstream from primary systems that create data.

3. “Big Data” Has ‘Big’ Scalability Needs

For decades, the SQL relational model has dominated business intelligence and database technology. Traditional RDBMS are all based on SQL, for which an alternative has now come available: NoSQL, for Not only SQL. This doesn’t mean SQL databases will disappear any time soon, but the introduction of NoSQL platforms has played a pivotal role in enabling “Big Data” solutions like the Apache Hadoop solution eco-system.

The reason NoSQL solutions (see also tip# 5) are dominating “Big Data” projects is both because relational, SQL solutions are (largely) restricted to “vertical” upscaling, as well as the (abundant) possibilities for selecting low-cost commodity hardware in a “horizontally” scalable infrastructure. “Vertical” scaling means getting a faster server, more RAM, faster I/O, etc. By “horizontal” scaling we refer to expanding the size of a cluster or grid by adding more hardware. A cluster consists of identical pieces of hardware; a grid is composed of divergent types of servers. Horizontal scaling leads to a more or less linear rise in cost, vertical scaling typically leads to exponential rise in costs after some “natural” capacity ceiling has been reached.

4. Scalable, Massively Parallel Architectures Will Boldly Take You Where No Man Has Ever Gone Before

One of the ‘big’ things with Hadoop and similar “Big Data” solutions is that they provide the means to scale out in near linear fashion. With (Apache) Hadoop, you may launch your services on a cluster with only a few nodes, and then later gradually and smoothly expand this solution to multi-Terabyte scale. Without ever structurally revising your architecture.

The ability to scale out a solution, running on low-cost commodity hardware has brought heretofore-unimaginable data volumes within reach of medium to large enterprises. As the business grows, the hardware can “simply” grow along, without any serious need for architecture revision. The dramatic price drops in MPP (Massively Parallel Processing) technology, and commoditization of storage (racks of multi Terabyte disks serving every node in a cluster) have opened up business cases for leveraging data that previously only lived in the realm of mega corporations (with very deep pockets). This technology trend has significant impact for shifts in business competition!

5. NoSQL Solutions Come In Many Shapes And Sizes

In the “Big Data” space, more particularly for BI, (Apache) Hadoop seems to have acquired a rather dominant position. Hadoop should be considered an eco-system, though, rather than a solution per se. It has drawn many developers, hence it encompasses quite a wide variety of solution like Hive for data warehousing, MapReduce for distributed processing, ZooKeeper to coordinate distributed applications, Avro data serialization, the HDFS distributed file system, HBase database, and several others.

However, NoSQL extends way beyond Hadoop. It provides highly diverse solutions, geared to optimize a bewildering array of technical challenges. What these solutions share is that they deviate from the “traditional” (BI), or “classical” relational needs. NoSQL solutions revolve around unstructured or semi-structured data like storing images, video or audio, (mathematical) graph databases like the ones that provide connection recommendations in Facebook or LinkedIn, high-dimensional relations (as opposed to typical 2-dimensional relations in an RDBMS), text, GPS, etc. In short: all the areas where “Big Data” have been expanding into.

6. “Data Scientists” Are The Information ‘High Priests’ of “Big Data”

Jeff Hammerbacher (Cloudera) and DJ Patil (Greylock Partners) coined the term “data scientists” (in 2007) to describe a hybrid between “data analysts” and “research scientists.” Working with “Big Data” requires a specialized skill set. It helps to have affinity with programming. You need a solid understanding of experimental methodology, at least working knowledge of statistics, and experience in data management. This intersection of expertise is pretty rare, which explains why “data scientists” are in such high demand, at the moment.

“Big Data” structures are elusive, and since so few professionals know how to make sense of these oceans of data, nor (would) know how to cross-validate findings, business stakeholders ‘just’ need to rely on this new generation of data scientists to leverage their data assets in the best possible way. Even seemingly “simple” cross-checks on frequency count and correlations can be so challenging in “Big Data” environments that business stakeholders often feel at the mercy of their information “high priests” (=data scientists).

7. “Big Data” Leverages The “Long Tail”

One of the cornerstones of “Big Data” is that you can ‘outsmart’ your competitors if you have more and better data than them. “Better” data refers to richer customer profiles which you can accrue by consolidating information from a wide array of sources. “More” data refers to a bigger customer base, access to a larger share of the market. That is where the “Long Tail” comes in.

“Long Tail” marketing (Anderson, 2006) refers to tapping into ever smaller niches of the market, and (still) serving these niches with an offer that is as personalized and timely as it can be. Because of the nature of Gaussian (Normal) distributions, growing your base by a factor of two implies you will have (far) more than twice the volume in these long tail niches. This is where size truly matters! “Long Tail” marketing is all about “selling less of more”, or finding more profitable niches, yet serving these accurately, thus leveraging the data you have for this niche.

8. “Big Data” Is Here To Stay (And Grow Even More!)

Given the current growth rates in data volumes, nothing seems to stop further adoption of “Big Data” architectures. If anything, they are bound to gain (much) wider acceptance. As the technology matures, further innovations will continue to drive down TCO (Total Cost of Ownership).

Hardware cost is going down at a fairly “predictable” rate, and considerable drops in exploitation and maintenance (software) costs can be expected from stepwise innovations. Hadoop and most other “Big Data” applications are developed under the Open Source licensing model. The Open Source developer community has proven remarkably adept at finding effective solutions for the most time-consuming maintenance activities. Those seem to ‘automatically’ get resolved first. Developers “know” what kind of architectures lead to poorly maintainable solutions. As driven by some “invisible hand”, the Open Source model consistently leads to high quality solutions. This trend will foster more widespread, and more easily adoptable “Big Data” frameworks.

9. NoSQL Won’t Replace But Instead Will Live Alongside “Traditional” RDBMS

NoSQL environments, and in particular the Hadoop eco-system, play a central role in “Big Data” solutions. Their dominance will only increase as data volumes continue to grow. However, we’re unlikely to say goodbye to traditional (RDBMS) solutions any time soon. Relational models provide enormous flexibility, and the ACID principle (Atomicity, Consistency, Isolation, Durability) for database transaction processing still, and probably will have important advantages for the overwhelming majority of applications. It’s important enough that no replacement seems in sight.

For most applications, “Big Data” stores will serve as “just” another source for a relational data warehouse. It’s only the persistent, carefully modeled data that pass this “durability” test. Exporting them to a persistent store where historical analysis can be performed is likely to play an important function in driving corporations for many, many years to come. So both architectures can in fact live side-by-side quite elegantly.

10. Analytics Leverages The Deep Potential Of “Big Data”

“Big Data” by itself, regardless of the form, shape, size, or type it comes in, is worthless unless business users actually do something with it that delivers value to their organization. That’s where business analytics comes in.

Business intelligence has always been on the edge of data repositories that were bigger than could be comfortably handled by the technology available at the time. In that sense, “Big Data” is not all that new. When you attempt to compile a comprehensive history of the organization, and integrate this across business lines (as is customary in an EDW), this perforce will grow beyond what is being handled elsewhere in the company. Leveraging analytics in a “Big Data” environment is challenging, yet, the royal road to success.

Further reading

Some excellent books on “Big Data”:

Super Crunchers: Why Thinking-by-Numbers Is the New Way to Be Smart.
Ian Ayres (2006)
ISBN# 0935716025

Too Big to Know: Rethinking Knowledge Now That the Facts Aren’t the Facts, Experts Are Everywhere, and the Smartest Person in the Room Is the Room.
David Weinberger (2012)
ISBN# 0465021425

Reinventing Discovery: The New Era of Networked Science.
Michael Nielsen (2011)
ISBN# 0691148902

The Long Tail: Why the Future of Business is Selling Less of More.
Chris Anderson (2006)
ISBN# 1401302378

How to Restore (7.x) Query into Older (3.x) Version

Once older version (3.x) queries are migrated into latest version (7.0) queries, they can be restored (set back) to the 3.x version. The backup for any query created in 3.x will be taken when first opened for editing in 7.0 Query Designer.
This backup contains the last change done to the query using 3.x editor. Any changes done in 7.0 Query Designer will be lost on restore. When the query is originally created in 7.0, it can’t be restored to older versions as there is no 3.x backup available.

Queries can be restored to 3.x version using program COMPONENT_RESTORE.

For more information and the how-to-restore, please visit the SCN blog entry created by Mahesh Kumar and Brian Keenan. You can find their SCN entry here

Semantically partitioned object (SPO) wizard

A semantically partitioned object is an InfoProvider that consists of several InfoCubes or DataStore objects with the same structure. Semantic partitioning divides the InfoProvider into several small, equally sized units (partitions).
SAP often uses the picture below the explain the SPO principle.

SPO based model

SPO based model

As of BW 7.3, creating SPO based InfoProviders has become much easier due to the SPO wizard. Unfortunately this wizard is one of the best kept secrets as it hasn’t received it’s own transaction code….yet
For creating an SPO based DSO, the checkbox ‘semantically partitioned’ needs to be checked. (The same applies for SPO based InfoCubes)

Checkbox semantically partitioned

Checkbox semantically partitioned

After having checked ‘semantically partitioned’, the following ‘wizard screen’ appears which assists you in creating, in this case, an SPO based DSO

Maintain partitions

Maintain partitions

Click on maintain partitions to define the partition criteria. The first step is to choose the infoObject(s) on which the partition criteria is to be defined.

Select partitioning criteria

Select partitioning criteria

For more information regarding the SPO wizard I’d advise you to read to whitepaper about it. You can access this by clicking here

Business content vs active version

Recently I had to install (some) business content for SAP BusinessObjects Sustainability Performance Management 1.0.
As it has been a while since I last activated business content, my knowledge about it became ‘rusty’ and therefore it triggered me to write this small blog entry.

There are several ways to activate business content:
- via transaction RSA1 and then click on ‘BI content’
- via transaction RSORBCT (BI Business Content Transfer) you’re automatically (re)directed to business content
- via program RSO_BC_INSTALL_ALL (Install all business content). Be aware to enter one or more Packages…otherwise ALL business content will be (re)activated!

As some business content to be activated was already active within the system, I wanted to compare the active version with the business content version. In the example below I’m interested in the possible differences for infoobject 0MATERIAL. Via transaction RSD1 infoobject 0MATERIAL was chosen.

Version comparison

Version comparison

As to be seen in the picture above, comparison is possible by clicking ‘version comparison’ -> ‘display differences only’ -> ‘Active / Content version’. The following list of differences between the active version of 0MATERIAL and the business content version is shown:

Version comparison: changes

Version comparison: changes

It’s recommendable to perform the above check for every object which is already active within the system. This prevents you from overwriting objects you don’t want to be overwritten/set back to business content version.

Overview of (commonly used) BW programs

Today, during my last day of co-hosting a SAP BW training with Roger Pijpers, he handed over another usefull list. This one contains a list of commonly used BW programs.
This overview might come in handy if you’re looking for a particular program/report to run:

SAP (BW) programs

SAP (BW) programs

RSCDS_NULLELIM – Delete fact table rows where all Key Figure values are zero. See Note 619826.
RSDG_CUBE_ACTIVATE – Activation of InfoCubes
RSDG_CUBE_COPY – Make InfoCube Copies
RSDG_CUBE_DELETE – Delete InfoCubes
RSDG_DODS_REPAIR – Activation of all ODS Objects with Navigation Attributes
RSDG_ODSO_ACTIVATE – Activation of all ODS Objects
RSDG_IOBJ_ACTIVATE – Activation of all InfoObjects
RSDG_IOBJ_DELETE – Deletion of InfoObjects
RSDG_IOBJ_REORG – Repair InfoObjects
RSDG_IOBJ_REORG_TEXTS – Reorganization of Texts for InfoObjects
RSDG_MPRO_ACTIVATE – Activating MultiProviders
RSDG_MPRO_COPY – Make Multiprovider Copies
RSDG_MPRO_DELETE – Deleting MultiProviders
RS_COMSTRU_ACTIVATE_ALL – Activate all inactive Communication Structures
RS_TRANSTRU_ACTIVATE_ALL – Activate Transfer Structure
RSAU_UPDR_REACTIVATE_ALL – Activate Update Rules
RRHI_HIERARCHY_ACTIVATE – Activate Hierarchies
SAP_AGGREGATES_ACTIVATE_FILL – Activating and Filling the Aggregates of an InfoCube
SAP_AGGREGATES_DEACTIVATE – Deactivating the Aggregates of an InfoCube
RS_PERS_ACTIVATE – Activating Personalization in Bex(Inactive are highlighted)
RSSM_SET_REPAIR_FULL_FLAG – Convert Full Requests to Repair Full Requests
SAP_INFOCUBE_DESIGNS – Print a List of Cubes in The System and Their Layouts
SAP_ANALYZE_ALL_INFOCUBES – Create DB Statistics for all InfoCubes
SAP_CREATE_E_FACTTABLES – Create Missing E-Fact Tables for InfoCubes and Aggregates
SAP_DROP_EMPTY_FPARTITIONS – Locate/Remove Unused or Empty partitions of F-Fact Table

Go to Top