Yearly Archive: 2016

Software Tools for Scripts

51c1pf0fe7l-_sx331_bo1204203200_From time-to-time, I prepare scripts both in my working life and my diversions. It is surprising to me that people often ask what software I use. The flip answer is “a few billion cells between the ears.” As much as you will be told software is needed, your first priority should be storytelling. Knowing what story to tell and how to tell it counts far more than getting things into the right arrangement of 12-point Courier type. People were writing scripts long before specialized software tools came along. I recommend that anyone starting out putting their efforts (and money) into really understanding story construction. To use a quote attributed to Frank Lloyd Wright when he was asked what kind of pencils he used, he said, “It’s not the pencil, it’s the man.” The tool is not the key issue in script preparation. If you’re looking for a place to start, I usually tell people to start with Robert McKee’s Story and work their way from there.

onenote_2013All that said, there are software tools that can make the job easier. For research, I like having a notebook tool that integrates well with clipping from a web browser as well as taking notes, storing files, images, and other digital whatnot. My favorite these days is Microsoft OneNote 2016, which is included with most Office 365 subscriptions. I used to use Evernote, but I found their note editor lacking for my tastes and recent issues around pricing and security became a turn-off. Microsoft OneNote is in many ways a style-wise clone of the excellent but now defunct Circus Ponies Notebook on the Mac. Unlike Evernote, OneNote uses Microsoft Drive to sync or to keep notebooks 100% offline on a USB device. Some people use Literature and Latte’s Scrivener product for this, but the Windows edition is lacking in several departments, not the least of which the user interface fails to work well (out of the box) with high DPI displays like you’d find on notebooks from Microsoft, HP, Dell, and Lenovo. (I personally use a Microsoft Surface Book day-to-day and love it.)

For the actual writing of script or a screenplay, there are number of dedicate tools. Why not just use a regular word processor like Microsoft Word? Primarily to make your life easier when it comes to format. If you’re submitting material for studio filming, Hollywood has a fairly exacting (and somewhat tedious) format, devised to simulate a typewriter circa 1951. This gives a uniform pagination and readability to most scripts that is demanded by Hollywood system. For other applications of scripts (graphic novels, television, radio, marketing, stage plays) the formats are a little less exacting, and primarily exist to enhance communication with the performers and other production professionals. If you plan to submit work to a particular institution, it’s best to read up on their format—most publish their submission guidelines on the web.

Always submit material (especially unsolicited material) in the format that the receiver requests. For Hollywood-oriented material, agents and studios won’t even look at a script that is not in the standard format.

tqufekmeI’m primarily using Fade In Professional by Kent Tessman these days. I’ve used Movie Magic Screenwriter and Final Draft from time-to-time, but development on Screewriter has gone into hibernation (if not completely moribund) and Final Draft, even in their latest version, Final Draft 10, can’t seem to work out how to use a high-DPI display on a Windows machine such as Surface Book.  After an extensive discussion with FD’s VP of support, I concluded that Final Draft was unsure when they would fix the display problem or even to what degree it is a priority to repair. Several of my friends that use Mac’s for screenwriting still swear by Final Draft as the industry standard (at least for Hollywood Screenplays), but other friends depending on relatively current PCs seem to be abandoning it.  Being able to clearly read the type is a pretty basic feature for what amounts to specialty word-processor.

Why Fade In? Short answer: Easy, Reliable, and Inexpensive. Fade In uses the same TAB-ENTER paradigm for typing a screenplay that most screenplay tools use, so when you’re typing Scene headings, actions, dialog, etc. all fall into place naturally. It handles the MORE-CONTINUED pagination that is critical to correctly formatted screenplays for the major studios. It natively uses Open Script Format (an XML standard for exchanging scripts), but can handle reading and writing Final Draft’s proprietary format, and easily imports content from MM Screenwriter (which FD still can’t do well.) Being the new kid on the block, it doesn’t have a lot of celebrity endorsements (although it has picked up a few,) but it produces the clean copy you need to capture a screenplay, graphic novel, or script quickly and efficiently. It generates the same format as the others, and it’s less that a quarter of the price of Final Draft for the professional version—with the advantage that you can actually see the type on a modern laptop.

Almost all for-pay product versions have a trial version, so you can try out the different programs to see what makes the best tool for you.

If you’re looking for a zero-dollar solution, I recommend you look at Celtx. It is free for screenwriting, but if you want the bells and whistles, you’re going to be shelling out around $99/year.  Adobe Story is another option, especially if you are an Adobe Creative Cloud customer.

For almost all other editing chores I use Microsoft Word. Talking to my colleagues in the comic-book industry, MS-Word is actually one of the most popular tools they use for creating scripts. If you’re specializing in this area, head over to Fred Van Lette’s pages for a free set of templates. Word is available by subscription from Microsoft and probably has more editing tools that most users need. It’s collaboration tools for markup are pretty much the standard for businesses the world over.

k380-multi-device-bluetooth-keyboardThat’s about it for my scripting software tools.  Of course, there’s other things in my bag of tricks like Powerpoint, but it’s more for collecting information together for producers and artists, than actually writing.   Likewise, I keep a stable of apps on my iPad for writing, but my best investment was a small, inexpensive Bluetooth keyboard (a Logitech K380) and a lightweight portable stand.  I toss both in my briefcase when I’m traveling light.   I tried keyboard iPad covers, but they turned out to not be for me.   I like to have my iPad light when I’m reading and the keyboard covers weighed me down.   A Bluetooth keyboard gives me a quality typing experience when I need it with little fuss.  It’s helped my productivity when writing more than any app on the iPad.

SAP BW/4HANA: The Next-Generation Data Warehouse, Delivered

modern libraryFrom its earliest deployments some three decades ago, the data warehouse has been a disruptive technology. As data has become more central to every aspect of what businesses do and ultimately what they are, the data warehouse has become an increasingly critical part of the enterprise data landscape – spinning off a series of subsequent disruptions in its own right (data marts, data warehouse appliances) and playing a central role in the emergence of many others (business intelligence, big data, data science.) Throughout this time, although data warehouses have handled a wide range of workloads in service a of a vast number of use cases, their core value proposition has remained fairly consistent.

In general, any data warehouse solution fulfills five basic requirements[1]Vincent Rainardi identifies these traits in his own blog  and with some additional annotation I concur.:

  1. An integrated view of the business’ data for strategic analysis
  2. A consistent view of the company’s data resources with data that has been cleared of anomalies which can lead to a false impression of the business’ function
  3. A consolidation of the company’s data history beyond what is retained by current operations for deep analysis of the business’ functions over time
  4. A tested and verified environment for analysts to access data so that each new draw of data doesn’t become a “science experiment” in and of itself
  5. A performant environment for doing data analysis that does not interfere with day-to-day activity of the business

Since its introduction, SAP Business Warehouse (BW) has served as the foundation for data warehousing solutions that meet all of these requirements. Now SAP BW/4HANA, merging the power of the SAP HANA in-memory platform with the business process expertise of SAP BW, takes that value proposition to a new level.  Compared with SAP BW environments running on on a traditional database (such as Oracle or IBM DB2), SAP BW/4HANA presents a whole new paradigm for data warehousing, delivering next-generation data warehouse capability for organizations facing unprecedented business and technical challenges.

Integrated View

As a true data warehousing solution, SAP BW/4HANA fully integrates data as required from multiple applications. But businesses today must integrate data from a wide variety of sources beyond the traditional operational business systems. Using SAP HANA Smart Data Access, SAP BW/4HANA can rapidly access live data in remote systems including other data warehouses, business systems, operational data stores, data marts, dynamic tiers of analytic storage (such as SAP IQ), and even Hadoop systems with big data.  A solution that brings all of these disparate sources together in real time into a single virtual repository is called a logical data warehouse. Designed from the ground-up as an in-memory solution, SAP BW4/HANA uniquely delivers this much-needed model.

Clean and Consistent View of Data Resources

Uniting the diverse data sources that today’s businesses rely on is an important first step, but it is only half the battle. A business must be confident that its data has been appropriately prepared and cleansed  to provide reliable results. Not only does SAP BW/4HANA support the logical data warehouse concept, it adds the necessary management and control over these data sources to provide consistent views of data where it is – avoiding the traditional requirement for an ETL  process that physically moves that data into local storage.

Consolidation of Data History

In keeping with core data warehousing requirements, SAP BW/4HANA provides a consistent view of data history for  the business. But when incorporated with technologies such as SAP HANA Streams for streaming data and SAP HANA Vora for data managed by big data technologies (Hadoop, Spark), SAP BW/4HANA provides a much more complete and up-to-the-minute picture of data history, including Internet of Things data from sources such as consumer devices, RFID, smart meters, and portable monitoring devices.

Tested and Verified Environment

SAP BW/4HANA organizes not only the data, but the metadata of the logical data warehouse. This creates a comfortable and logical environment in which an analyst, a data scientist, or an end user can access this data in a consistent and reliable fashion – such as with SAP BusinessObjects Cloud.

High-Performance Environment

Because SAP BW4/HANA is exclusively tuned to leverage the SAP HANA infrastructure, which was built from the ground up to solve business analytics data problems, it can deliver outstanding performance far beyond BW on traditional databases. For example, SAP BW4/HANA can resolve in seconds data inquiries that used to take hours.  With this vastly enhanced performance, companies with SAP BW/4HANA can operationalize real-time solutions, such as real-time customer sentiment analysis and retail offers, self-adjusting marketing campaigns, and in-clinic health solutions. Where previously the sheer volume of data and complexity of relationships within it stretched the capability of traditional environments to the breaking point, SAP BW/4HANA delivers real-time results.

Although data warehousing has changed significantly over the years, at a fundamental level what businesses need a data warehouse to do has remained much the same. The real challenge has been delivering those same core capabilities in the face of fundamentally transformed data environments and business processes. Designed  from day one to address the requirements of a new business and technological landscape, SAP BW/4HANA delivers true next-generation data warehousing capability, while helping businesses to ready themselves for the inevitable next wave of disruptive change.

Follow the conversation on Twitter at #TheFutureOfDW AND #BW4HANA

References   [ + ]

1. Vincent Rainardi identifies these traits in his own blog  and with some additional annotation I concur.

More than a Database

Old wooden card catalog with open box in the archive library

The modern data warehouse calls for capabilities that go far beyond what a traditional database can provide. SAP BW/4HANA fills that gap.

There was a time, not long ago, when even the stickiest data management problems for business had a simple solution.

You need to keep track of day-to-day business operations?

Get a database.

You need to do some quick reporting on some of that data?

You’d get a database for that, too.

You need to do more advanced analysis on all that transactional data?

Hey, what do you know—that sounds like another database problem.


Over the years there has been a steady progression from online transaction processing to operational reporting to online analytics processing. As the need for more powerful and sophisticated data warehousing solutions has grown, databases have been reoriented from rows to columns and have been optimized for massively parallel processing. But the basic underlying technology has remained much the same. Even in the era of big data, we’ve seen oversize repositories of semistructured and unstructured data evolving new features that push them in a more and more database-like direction.

It’s a formula that has worked for a long time: Got a data problem? Get a database.

But today your business faces an unprecedented sets of challenges. Bigger data volumes. New data types. A deluge of machine data from the Internet of things.  Digital business models that require real-time performance all the time drive the need for zero-latency reporting. Data-driven businesses need more complex, more extensive, and yet paradoxically faster and more easily accessed analytics. To succeed, you  need a deeper understanding of the Why behind what your customers, your competitors, and the market as a whole is up to. These are the challenges of the modern data warehouse. And to meet these challenges, you need something more than just a database.

Time for a New Formula

SAP BW/4HANA is more than a database. BW/4HANA merges the power of the SAP HANA in-memory platform with the unmatched business savvy of SAP Business Warehouse.

BW/4HANA provides a single version of the truth. It’s is the only data warehouse system built from the ground up to enable real-time analytics and real-time transactions on the same data and the same time. Traditional databases still require you to split analytics and transaction processing and to copy data from place to place throughout the organization.

BW/4HANA lets you solve in seconds analytics problems that take other systems days. It’s the only data warehouse system built from the ground up for extreme performance by using such techniques as  memory-first, column-based calculation. Traditional databases, by contrast, continue  to plod along with column-based caching.

BW4/HANA saves you time with a pre-delivered structure. It’s the only data warehouse system with pre-built data objects for SAP applications (and other systems)  as well as with industry-oriented templates.Traditional databases typically leave it to the user to develop governance and schema techniques, making implementations slower and much more complex.

BW/4HANA is ready for the Internet of things at petabyte scale. It is the only data warehouse with integration for streams (HANA Streams), Hadoop computation (through SAP HANA Vora), and multi-temperate data (Dynamic Tiering/NLS)

Perhaps most importantly, only BW/4HANA is backed by SAP, the world leader in business application technology—ensuring that your business can run smarter, better and faster.

Differences that Make all the Difference

In a world where “get a database” is no longer a sufficient answer, SAP BW/4HANA brings all of your data together and makes it actionable. A data warehouse solution built on BW/4HANA can  accelerate your business into real-time—eliminating the boundaries between operations and analysis, putting data into the hands of decision-makers throughout your organization.

Follow the conversation on Twitter at #TheFutureOfDW AND #BW4HANA

The Data Warehouse Revolution Is Coming

Winding Boardwalk through Forest, Pohara, Golden Bay District, Nelson Region, South Island, New ZealandModernizing the data warehouse is no longer just a passing thought in most major enterprises, but is increasingly becoming the imperative. A centralized structure for all our data that took shape in the 90’s is increasingly appearing to be outdated and incomplete as the sole architecture for business analytics.

Why is this?

Three trends are working strongly against the centralized, single-database approach to the data warehouse. First, is business is becoming increasingly transacted through web and digital interfaces. Just as the ATM displaced human interactions for banking transactions, now business are interacting with the customers, employees, partners, and even machines through digital interaction. And that interaction is creating a wealth of data, if we can leverage it.

Second, but strongly correlated with the first is the proliferation of data sources and the amount of data with which business professionals want and need to engage. It is becoming increasingly difficult or impractical to move such vast amounts of data. In some cases, it might even make sense that the data be treated as impermanent stream of time-sensitive content. The practicality of dealing with big data and its consequences begs for new solutions over centralized of reservoirs of storage.

The third trend is continuation of increasing pace of digital transactions. The demand is always to conduct business more quickly and efficiently. This pressure, usually spawned by competition places increasing strain to make decisions and analysis ever more quickly. Business problems like fraud detection, real-time web interactions, customer service, and customized consumer offers all become increasingly part of this his speed decision making process.

SAP customers already are reaping the fruits of this trend towards more powerful computing. Leveraging power of SAP HANA, SAP’s business suite S/4HANA powerfully combines core business applications and operations with in-memory computing. This enables real-time operations. By extending this idea to warehouse, real-time business operations.

What is needed is a new approach to the data warehouse. We need an approach that combines the power of an in-memory data engine with access across a range of data sources and stores. A new system for managing the data warehouse would need to understand multiple temperatures of data (that is, how important and urgent data is) as well as be able to work with vast distributed technologies such as Hadoop. Of course such an engine would need to understand streams and other forms of temporal data. And most importantly, we would need a warehouse that with our applications and BI tools.

Sound like too much?

Well, at SAP we’ve been revolutionizing the platform for data analysis. We invite you to find out more about a data warehouse system that can do all this and more: a revolution in data warehouse management is coming this September.

Follow the conversation on Twitter at #TheFutureOfDW