Archive for the ‘Lumira’ Category

Lumira 2.0 Discovery

During some downtime recently, I decided to play around with the new Lumira 2.0. I had not used Lumira 1.0 in about eight months. I was excited to see what improvements were made to the tool from the first iteration.

I knew that 2.0 is similar to 1.0 in that users have to deploy an add-on to the BI server. Lumira 2.0 renamed Lumira Desktop to Lumira Discovery and integrated Design Studio’s functionality into another tool called Lumira Designer. This blog focuses on Lumira Discovery and, in particular, about connecting to a universe.

What I Like Best about Lumira Discovery:

  1. Previously, Lumira Desktop had three screens: Prepare, visualize, and compose. In Discovery, these are integrated into one single canvas page. It removes what I thought to be excessive amount of steps, especially since this solution is supposed to be user friendly and able to provide quick access to data.
  2. After a short period of time getting used to where all the options available are, navigation was easier and seemed intuitive. Like Web Intelligence: its many options for charts can be accessed by either right clicking or from the contextual menu icons.
  3. While I didn’t do an in-depth analysis on this, it was nice to see there is an ability to consume anything created in Lumira Discovery with Lumira Designer. This is will allow for reusability and collaboration between IT and business users.
  4. Easily connecting to a Live BW source. Discovery supports BEX hierarchies and variables.
  5. I was able to connect to a universe from my BI Launchpad. The query builder screen is the same as the one in WebI, which will make any Webi user comfortable. There are a couple caveats to using a UNX, which I detail in the “Needs Improvement” section below.
  6. While users cannot create a LUMX file from BI Launchpad, it is possible to edit these kinds of files. This is a great feature if you have published something from Discovery application, but then noticed a quick fix is needed. Hopefully, future versions will include a create option from within BI Launchpad.
  7. Merge, Append and linking datasets: I remember glitches with these in Lumira 1.0. In 2.0, once you understand which one you need to use based on your use case, it’s fairly easy.
  • MERGE DATASET – While Append adds the records of data set B to data set A, Merge adds columns from dataset B to dataset A. The prerequisite is to have a common key column of the same data type.
  • APPEND DATASET – Appending two datasets is similar to performing a union between them. The mandatory prerequisite for appending one dataset to another is that both the datasets must have equal number of columns of similar data types.
  • LINK DATASET – Linking Datasets can be done when there is no common key but having a common column (e.g. Country) into which the data can be blended.

To download and Continue Reading…

About Mitesh Shah

Mitesh is a manager in Protiviti’s Data Management and Advanced Analytics solution. He specializes in data services, front-end reporting and analysis, and Information Governance for numerous enterprise customers across the country. Specifically he works with SAP Data Services, SAP Information Steward, SAP BusinessObjects and SAP HANA.

Categories: Lumira

Lumira Edge Install

As a moderately experienced user of SAP Lumira Desktop, I am knowledgeable in the utility and functionality that it provides. It is ideal for manipulating, editing, and formatting data to create visualizations and share them throughout an organization. Its user-friendly interface enables users to easily compose engaging documents from multiple data sources that don’t need to be 100% clean.

From my experience, implementing SAP Lumira at an enterprise level is most successful when the sharing of visualizations is managed effectively. Enter SAP Lumira Edge. SAP Lumira Desktop has several options for enterprise integration, including Lumira Cloud, SAP BI and Lumira Server on HANA. However, SAP Lumira Edge is a streamlined, light-weight, and cost-effective option that may be the best solution for an organization.

SAP has stated that Lumira Edge is very easy to install and use, so I have taken it upon myself to perform a test install of the product and document my findings.


Since I did not have a physical test environment available to use, I chose to install SAP Lumira Edge on a local virtual machine. The virtual machine is a Windows Server 2008 R2 SP1 with 4 GB of RAM, 2 CPU’s, and 14 GB free Disk Space, meeting the “Evaluation Purposes” hardware requirements from the SAP Lumira Edge Installation Guide. (For reference, the “Production Ready” hardware requirements from the Installation Guide are 8+ GB RAM, 4 CPU, and 4 GB of Disk Space.) With my environment ready, the first step was to download the installation file from the SAP Service Marketplace. The file can be found by navigating to the “SAP Lumira Server For Teams” node (this is the new nomenclature for SAP Lumira Edge).

Lumira Edge Install pic

The installation process for SAP Lumira Edge was similar to that of other BusinessObjects products I’ve installed in the past. The installation ZIP file must be downloaded from the Service Marketplace and the setup.exe file must be run locally. The setup.exe file was easy to find, in the “LumiraTeamServer” subfolder.

To download full PDF and to Continue Reading…

JT About James Mason
James Mason is a business intelligence consultant specializing in report, dashboard, and semantic layer  development.  James delivers customized SAP BusinessObjects solutions for customers across all  industries.  With Decision First Technologies, James utilizes Web Intelligence, Dashboards, Universe  Designer, Information Design Tool, and Explorer.

Categories: Lumira

St. Patrick’s Day! March 17, 2015

Every year on March 17th, everyone all across the world celebrates and hold international festivals for Saint Patrick’s Day. This infographic shows that there are many aspects to Saint Patrick’s Day. From Boston to Savannah, there are many cities across the United States to visit for all those who wish to be Irish for a day. It is commonly known that drinking is an essential part of the holiday. Many Catholics are Irish-American, and some may be required to give up drinking in the process of Lent.  It is a little known fact that they are allowed to break this during these celebrations! However with drinking, comes responsibility and safety. With many drunk driving accidents happening on Saint Patrick’s day it is important to take preventive measures.  We hope that you enjoy reviewing Decision First’s St. Patrick’s Day Infographic and find it informative as well as entertaining and have a safe and festive St. Patrick’s Day!

Categories: Lumira

Introducing SAP Lumira Edge Edition

Just recently we installed the new SAP Lumira Edge Server at Decision First.  I’ve done quite a bit of testing and implementations within client engagements on SAP Lumira Server on HANA, but was particularly excited about the release of SAP Lumira Edge.  Ad hoc visualizations, dashboards and reporting are requirements of the vast majority of my engagements.  However, the issue has always been one of end-user training.  SAP Lumira provides the ability to quickly get up and running with little to no training to create compelling visualizations and reports without the need for IT intervention.  You have the ability to create polished ad hoc dashboards, reports (!), infographics and storyboards.

I placed the exclamation beside “reports” because you typically see ad hoc reports in systems like Web Intelligence.  But if you look at the requirements of these reports, the requirements can sometimes be met by a tool like SAP Lumira.  Things such as simple charts, vertical tables, labels and logos can be built inside of SAP Lumira and assembled into a layout that resembles an ad hoc report.

To download full PDF and Continue Reading…

contributor_chris_hickman_lg  About Chris Hickaman
 Chris is a certified SAP BusinessObjects consultant. His specific areas of expertise include  reporting, analysis, dashboard development and visualization techniques. Chris’ software  development background has enabled him to achieve proven effectiveness in architecting,  developing, testing and supporting both desktop and web-based applications for many customer  engagements representing various industries. Chris also speaks globally at SAP and ASUG events.


Categories: Lumira

Groundhog Day!

Early spring or more winter?  For the last 128 years, Punxsutawney Phil in Punxsutawney, PA has predicted for the country whether or not spring will come early.  With the data aggregated from and other sources, DFT used SAP Lumira to discover some interesting facts around his predictions.  Check out what we came up with in this infographic!

Categories: Lumira

Analyzing and Predicting Hospital Readmission Rates

For the 2014 Data Geek Challenge, I decided to build an analysis to look at one of the most costly issues resulting from a surgical procedure: complications requiring re-admission to the hospital.  In my dataset, I track a set of patients that were successfully discharged from Smalltown Hospital after a routine medical procedure and determine whether they were re-admitted to the hospital within 30 days.  In order to share the results of this analysis with others, I have created a SAP Lumira Cloud Infographic.

The Problem
With the introduction of the Affordable Care Act, more emphasis is being placed on the ability to understand and reduce re-admissions because of the financial incentives offered to hospitals with low or improving re-admission rates.  Smalltown Hospital has identified one particular surgical procedure as a high source of overall re-admissions.  Smalltown contacted me to request an analysis of their patient data to determine if there are any general risk factors that can be used to identify at-risk patients before they are discharged.

Analysis Results
After examining overall patient distributions across risk factors and noting there is sufficient data to analyze hypertension, depression, smoking, BMI, and gender as risk factors, I proceeded to examine re-admission rates by factor, noting that the re-admission rate is much higher for patients with hypertension and much lower for patients reporting healthy behaviors, as shown in the pie charts below.

Patients with both smoking and depression indicators have a re-admission rate almost 7 times higher than those with neither indicator.

To download full PDF and Continue Reading…

Hilary Bliss About Hillary Bliss
Hillary Bliss is a Senior ETL Consultant at Decision First Technologies, and specializes in data  warehouse design, ETL development, statistical analysis, and predictive modeling. She works  with clients and vendors to integrate business analysis and predictive modeling solutions into  the organizational data warehouse and business intelligence environments based on their  specific operational and strategic business needs. She has a master’s degree in statistics and an  MBA from Georgia Tech.

Categories: Lumira

Exploring GIS Integration Options for SAP BusinessObjects


In conversations with various individuals and businesses over the years, I hear a common question being raised:  How do I integrate maps in with SAP BusinessObjects.  This is a diverse question with many different answers.  In this document, I will introduce the different methods of integration of mapping technologies with standard SAP BusinessObjects reports and analytics.  These options include what’s available not only out of the box but also some third-party options that I’ve used in the past.  Also, I will discuss some mapping options using technologies such as Tom Tom and ESRI as well as custom development from any available mapping source.

Integration Options

SAP / ESRI Direct Integration

The first option that we have is the direct integration between SAP and ESRI with no reliance on 3rd party tools.  The direct integration between SAP and ESRI takes many forms.  First of all, we have the integration of GIS data with the Dashboards application.  SAP and ESRI have a solution that provides an “xlx” file that plugs into the Dashboards application.  Using the plugin, dashboard designers can take advantage of fully functional, BI directional maps within the SAP Dashboards application.  There is some configuration on both the client and server sides in SAP BusinessObjects.


Also included in the latest versions of SAP Lumira (1.17+) is the ability to add story board components that appear as fully functional maps.  The capability is automatically built-in to the Lumira interface.  However, the only GIS support for ESRI that is available is through ArcGIS Online.   This scenario is undesirable for enterprise level applications given issues with data security.  The ability to interface with an Enterprise installation of ArcGIS Server is on the roadmap but currently has no projected availability date.

To download full PDF and Continue Reading…

contributor_chris_hickman_lg About Chris Hickman

Chris is a certified SAP BusinessObjects consultant. His specific areas of expertise include reporting, analysis,  dashboard development and visualization techniques. Chris’ software development background has enabled him to  achieve proven effectiveness in architecting, developing, testing and supporting both desktop and web-based  applications for many customer engagements representing various industries. Chris also speaks globally at SAP and  ASUG events.

Categories: BusinessObjects, Lumira

What’s New in SAP Lumira and Predictive Analysis 1.17?

In mid-June 2014, SAP released SAP Predictive Analysis version 1.17. While this release does not include that many changes, the algorithm expansion is notable, along with improvements in visualizations for predictive results.

Lumira Updates

Since Predictive Analysis shares the same visualization interface with SAP Lumira, it is important to note that enhancement to Lumira are also included in Predictive Analysis. These updates include:

  • Support for additional data sources (copied from clipboard, additional database support via JDBC drivers)
  • Automatic saving of charts and visualizations (THANK GOODNESS!!!!)
  • Updated features on the Compose tab to take advantage of Infographics (using pictograms, shapes, and lines to enrich the data story)

lumira 1.17

  • Lumira now suggests potentially interesting relationships related to the visualization you have currently created on the “Related Visualizations” tab of the Chart Feeder. In addition, by clicking on a measure, a dialog pops up in the Chart Feeder allowing the user to click “Run Analysis” and determine which factors contribute most to the variation within the measure. This automated discovery tool might be helpful in uncovering relationships between predictors and responses during modeling.

lumira 1.17.1

  • BusinessObjects integration has been enhanced with the ability to publish Lumira stories to the BI platform, and the ability to update existing Explorer Info Spaces created by Lumira, and to schedule updates to documents in Lumira Cloud.


To download full PDF and Continue Reading…

Hilary Bliss About Hillary Bliss

Hillary is a Senior ETL Consultant at Decision First Technologies, and specializes in data warehouse  design, ETL development, statistical analysis, and predictive modeling. She works with clients and  vendors to integrate business analysis and predictive modeling solutions into the organizational data  warehouse and business intelligence environments based on their specific operational and strategic  business needs.  She has a master’s degree in statistics and an MBA from Georgia Tech.

Publishing Stories to Lumira Cloud

The latest release of SAP Lumira and Lumira Cloud included the ability to publish “stories” designed in Lumira (or Predictive Analysis) to Lumira Cloud. Today’s blog shows the process of designing visualizations, creating story boards, and uploading them to SAP Lumira Cloud using the data set from the Customer Lifetime Value case study blog. Our story board will describe the customers for AdventureWorks Cycle Company, as well as summarize the Customer Lifetime Value and purchase habits for different groups of customers.

Building Stories

The first step in building a story board is creating saved visualizations on the “Visualize” tab in Lumira. Only saved visualizations can be included in story boards, it is not possible to design visualizations within the “Compose” tab, so the story board author should think about the analysis story and design visualizations to convey all of the important components.

Once a library of saved visualizations has been developed, click on the “Compose” pane to start a new story. There are a variety of multi-panel board designs, or the use can design their own by dragging saved visualizations up from the library of saved visualizations at the of the Compose pane. Visualizations and controls can be added in “Edit” mode, as shown below, where the author can design and control what the user will see. Authors can also add pictures and additional text notes to call out insights or personalize the story board with product images, for example.

Lumira Blog 1

Developing a logical plan for the analysis is critical to story design. In order to explain the customers at AWCC, I’m building 3 boards within my story. The first profiles customers and determines how many customers are in each demographic segment. The second looks at the purchase of Product X and the breakdown by different demographic groups, while the last board summarizes customer lifetime value across demographics. Once I have added my saved visualizations to the board, I can enter “View” mode, shown below, and interact with the story board the way a user would.

Lumira blog 2

To download full PDF and Continue Reading…

Hilary BlissAbout Hillary Bliss 

Hillary Bliss is the Analytics Practice Lead at Decision First Technologies, and specializes in data warehouse design, ETL developement, statistical analysis, and predictive modeling. She works with clients and vendors to integrate business analysis and predictive modeling solutions into the organizational data warehouse and business intelligence environments based on their specific operational and strategic business needs. She has a master’s degree in statistics and MBA from Georgia Tech.

Categories: Lumira

What the heck is self-service BI?


Times are changing in the world of business intelligence it seams. Over the past decade we have seen BI tools evolve from the crude integrated development environment (IDE) into stunning tools that can be used by business analysts and power users. In many cases these tools have become so easy to use, that even a novice business user could analyze data. Many years ago BusinessObjects started this trend with Desktop Intelligence (As it’s known today) and Web Intelligence. While these tools were often labeled “ad hoc” reporting tools, a new breed of “self-service” BI tools have recently emerged.  With self-service BI gaining ground every day, one should ask why this trend has momentum. I believe there are a few reasons self-service is becoming a necessity in the mind of some organizations. At the same time I see huge potential for these tools to repeat the mistakes of the past. Within…

View original post 3,252 more words

Categories: Lumira