Skip to Content

Hi Everyone,

I hope you have been enjoying Lumira 1.27 and all its powerful and long-awaited set of features that established Lumira as the absolute best of breed in agile data visualization and trusted data discovery. We are very excited and extremely proud to unveil our newest product release: Lumira 1.28.

As innovative and feature-rich as Lumira 1.27 was, Lumira 1.28, which was officially released on August 14th, is packed with a great number of innovations aimed at making trusted data discovery efficient and effective in any business context it is applied.

Lumira 1.28 is the outcome of several weeks of hard work and relentless dedication translating the large amount of invaluable feedback we have received from clients and partners into product features that directly facilitate the process of discovering business insights from corporate data sources, big data repositories and locally stored files, providing simplicity, flexibility and speed.


The list of innovations in Lumira 1.28 ranges from single sign-on option in data acquisition from SAP BW to data blending of multiple SAP HANA online views while preparing data for visualization and from new chart types and enhanced filtering capabilities in stories to new options of conditional formatting and better story page management. Moreover, we have added support for Windows 10 operating system and big data systems such as Spark SQL and Amazon Redshift. Not only has Lumira desktop been significantly enhanced with key functionalities, but also Lumira server for BI Platform and Lumira server for Teams have gained several important features such as prompting for parameter input when refreshing a visualization or story based on SAP BW data.

For detailed information about the innovations on Lumira server 1.28 and the new features related to promotion management, please check out the blog posts of my colleague Gowda Ramu: Lumira Server 1.28 and  Promotion Management.

Update today your Lumira deployment to version 1.28 and experience all the innovations and benefits of our newest release.

In Lumira 1.28, users can now edit SQL statements from queries created through “Query with SQL”. When editing a SQL statement, if the fields in the initial dataset are removed or renamed, Lumira will display a data mapping window to allow for corrections or confirmation of field deletion.


Building on the conditional formatting features of Lumira 1.27, now in Lumira 1.28 it is possible to apply conditional formatting on pie, line and time series charts.


Connect seamlessly to a trusted corporate data source using Windows user account through the secure Kerberos protocol.


Exporting records from a dataset is now easier and more flexible. It is possible to export all data points or a selection of data points. Additionally, records can be exported as aggregated or detailed.


Filtering data in Lumira 1.28 became significantly more powerful with support for wildcard. Use the _ character and the % character to replace a single and multiple characters respectively.


There are 2 new chart types: combined stacked column line chart with 1 Y axis and with 2 Y axes.


From a crosstab table, it is possible to perform conditional formatting on multiple values of a dimension, filter certain values and exclude undesired records.


Applying global filters on a story has been a popular request that has been delivered in Lumira 1.28. Filters can now be applied to all pages of a story or to a specific page. The filtering scope can be defined in the story settings.


Continue expanding support for Big Data systems


Lumira 1.28 is supported on Windows 10 operating system. Furthermore, Internet Explorer 11 on Windows 10 is also supported when accessing Lumira server for BI Platform or Lumira server for Teams.


One of the most awaited features has been the ability to perform data blending on multiple SAP HANA online views. In SAP HANA online views, data are not acquired into Lumira’s velocity engine, rather the data are managed and maintained in HANA. Combining data from multiple SAP HANA online views and visualizing them in Lumira charts are powerful innovations delivered in Lumira 1.28.


Continue usability enhancements from previous Lumira versions, Lumira 1.28 delivers now the ability to re-order and rename pages in a story.


Week-based time hierarchies in SAP HANA data source are now supported in Lumira.


Counter calculations can now be added to a dataset to perform “count all” or “count distinct” operations on a dimension.


The importance of big data systems as main data sources for trusted data discovery has grown exponentially. Lumira 1.28 delivers key improvements in optimizing file generation in Hadoop and allowing the monitoring of Oozie jobs from within Lumira desktop.


One of the features that had been eargerly expected was the ability to display input parameter prompts when refreshing a Lumira visualization or story that is based on the Query Panel Extension. This feature has been delivered in Lumira 1.28 and it works great.


Another area that received several improvements is data acquisition from  SAP BW: there is now data acquisition summary and auto hierarchy generation. Additinally, hierarchical filtering with hierarchy node variable is now available.Pic18.PNG

Now from Lumira server for BI Platform and Lumira server for Teams, when accessing SAP BW, there is SSO support for managed OLAP connections, refresh with prompts in visualizations and stories based on SAP BW and scheduling of Lumira stories that were initially saved with prompt values.


Another long-awaited feature that has been delivered in Lumira server for BI Platform and Lumira server for Teams version 1.28 is the ability to Save, View and Edit Lumira documents that are based on either SAP HANA online views or SAP HANA acquired data.


Finally, now in Lumira server for BI Platform and Lumira server for Teams 1.28, Lumira documents can be promoted across a system landscape of SAP BI systems.


We hope you are as excited as we are about all the innovations in Lumira 1.28. We look forward to receiving your feedback and comments about this great new release.


To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Former Member

    Good to see the new features in Lumira 1.28.

    sometimes i noticed Lumira (1.27) hangs when working on large datasets.

    Are there any improvements to the In-memory engine in terms of performance/stability?

    1. Former Member

      Hi Jerry,

      Support for Linux OS is definitely something that our product and development teams are discussing for future releases of our Lumira server solutions. Stay tuned.

      Best regards,


    2. Former Member Post author

      Hi Jerry,

      We are planning a Linux version of Lumira server for next year. For now, we recommend a heterogeneous BI clusters.



  2. Former Member

    Thanks for sharing, is also planned to include a functionality to automatically update the data when Data Source is changed?

    For example you have a Lumira Storyboard with Sales Data S, where the graphics in the Viasualize tab are built on that data, then changing Data Source, you can adapt the graphics to the new Data  in the Visualize tab set but these changes are not reflected on the Compose Tab and graphics.

    That would be great to have as a real copy of graphics from Visulaize in the Compose part otherwise is to annoying  and time consuming to update manually.

  3. Former Member

    Great article Carlos

    It would be great to hear about the exact blending capabilities : which data sources are supported ,Which types of joins and options are available

    1. Henry Banks


      there are already a few great Blogs here on Lumira SCN about data blending, by Kenneth Li, namely “introducing data blending”  + “joining vs. blending”

      in the meantime, I’ve added a screenshot to illustrate the kind of join behaviour you can try out in SP28


      that example was on BW data .


  4. Shaunak Ashtaputre


    I’ve not been able to connect to Redshift.  The driver is installed correctly.  I am able to use other SQL and BI tools.  Lumira shows the driver and then on providing requisite credentials (that work with other tools) shows that the connection failed.

    Can you help?



    1. Lothar Heusel

      Yep, that would be very helpful. 🙂

      Think about it: QlikView does not yet have a Mac Desktop Client, however Tableau does!

      I hope the platform is built platform independently to the most part .

      Best, Lothar

    2. Ty Miller

      We obviously started with Windows, but our strategy is to create a browser-based data analyst experience to support all platforms (OS X, Linux, Chromebook, etc.) rather than OS specific versions.

    3. Ty Miller

      We obviously started with Windows, but our strategy is to create a browser-based data analyst experience to support all platforms (OS X, Linux, Chromebook, etc.) rather than OS specific versions.

  5. Former Member


    I am using Lumira 1.25 and trying to get upgrade for 1.28.

    My upgrade option is disabled by administrator. Any help to solve this issue.

    Thanks in Advance,


    1. Former Member Post author

      Hi Shamila,

      It appears that your IT organization migth have locked down upgrades. My suggestion would be to talk with your IT team.



  6. Lalit Gandhi

    Nice informative blog…

    There was an issue with 1.27 Cloud  version while using sorted crosstabs. Hopefully they have resolved it in 1.28.

  7. Former Member

    Hi Carlos and other experts,

    I wonder when BW Connection (dataset creation and refresh) will be available for Lumira Cloud, or no plan to apply it for lumira cloud?

    Best regards.

      1. Former Member

        Thank you, Miller

        Even the BW-based report which is created by Lumira Desktop is not and will not be supported with the dataset refresh?

        Best regards.

  8. Former Member

    Hi Carlos,

    I tried to connect Hadoop Sandbox 2.3 with Apache Hive 0.14 to SAP Lumira 1.28 Client but Driver for Hive 0.14 is not available. Could you inform how I can manage this issue?

    Best Regards,


    1. Former Member Post author


      For now the support to Apache Hive 0.14 has been provided through the driver version 0.13. We are working to eliminate this confusion.



  9. Former Member

    About the BW data refresh in Lumira Desktop:

    If I created a story in the compose room, then every time I open the document and try to refresh the charts in the story by the latest BW data, do I have to return to the visualize room to refresh the chart?

    I turned on the button ‘Refresh page on open’, but it is to only reflect the latest charts in visualization tab. Is there no option for directly updating the charts in story at compose tab without returning to visualize tab? or maybe I have missed something.

    BTW, it works perfectly on BIP.

    1. Eric Yew

      Hi Chong.

      Quick question. Did you try to click on the refresh button in Compose room? The “refresh on open” option setting in Compose room is a bit misleading. If enabled as “on”, it will show the latest data from the underlying data set. But the user needs to refresh and fetch the data first by clicking on the refresh button in either the Visualize or Compose Room.

      We plan to rename this option, so that it does not create confusion for users. Users mistakenly (and rightly so) interpret this as refreshing the data automatically upon document open.

      Hope this clarification helps.


      1. Former Member

        Thanks for your explanation, Eric

        “But the user needs to refresh and fetch the data first by clicking on the refresh button in either the Visualize or Compose Room.”

        –> Here is my situation.

        With the button ‘refresh on open’ as ‘on’, when I open a document and go the compose room to refresh the chart by clicking on the refresh button in Compose room, nothing happened, no prompt, no data refreshing. When I go to the visualize room to refresh the chart by clicking on the refresh button, the BW connection prompt is showed. So I cannot get the latest data directly on Compose Room without returning to the Visualize Room…

        BTW, I do confused a little bit when I first saw the button ‘refresh page on open’…

        Best regards.

  10. Former Member

    Hi Carlos,

    Nice blog!

    A question though, i see you are mentioning a new graph: combined stacked column line chart with 1 Y axis (i was specifically looking for that in this version but couldn’t find it). however the screenshot is saying otherwise: combined stacked line column chart with 1 Y axis.

    Can you help me on that?



    1. Thomas Nielsen

      Combined stacked column with one Y axis is merely called Combined Stacked Line chart

      2015-09-09 13_31_51-SAP Lumira.png

      If you want the one with two axis, you choose the other one 😉

      But do note, that only the first measure is stacked, the rest is shown as lines.
      In order to change that, got to the properties for the graph on the compose tab.


Comments are closed.