Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Data Access - Acquiring

 SAP Lumira DesktopSAP Lumira Desktop connecting to BI Platform to consume a 'managed' connection or universeSAP Lumira Server for BI PlatformSAP Lumira Server for TeamsComments
flat files (.csv, .txt)

YES

(1)

NO

NO

NO

  1. You should place the.xls/.csv/.txt file at a shared location and use UNC path while creating a connection to the source file.
Microsoft Excel

YES

(1)

NO

NO

NO

  1. You should place the.xls/.csv/.txt file at a shared location and use UNC path while creating a connection to the source file.
Clipboard

YES

NO

NO

NO

 
Freehand SQL

YES

NO

NO

NO

 

Download from SAP HANA (offline) (1)

YES

YES

NO

NO

  1. See KBA 2250165 for Multi tenant Database Container 
Connect to SAP HANA (online) (3)

YES

(1) (2)

YES

YES

 (4)

NO

  1. Query sizes of over 3 Billion (3,223,329,867) rows perform without any issues.
  2. There are restrictions when connecting to HANA - see the Lumira user documentation and the section "Restrictions for Connecting to SAP HANA"
  3. See KBA 2250165 for Multi tenant Database Container
  4. When accessing HANA Views
SAP BusinessObjects Universe (.UNV)

YES

 

 

YES

(1)

NO

NO

  1. See the Universe Feature matrix for more details.
SAP BusinessObjects Universe (.UNX) using the Query Panel Extension

YES

YES 

(1)

NO

NO

SAP BW

YES

YES

NO

NO

 
Hadoop

YES 

NO

NO

NO

 
Data limits (rows/columns)None (1)None (1)None (2)None (2)
  1. You will be warned when an acquisition includes 30 million cells for 64-bit operating systems or 15 million cells for 32-bit operating systems. There is no limit, just a warning when the data size is getting large.
  2. Benchmark Tests (sizing) have been conducted by SAP with the number of cells (rows x columns) of both 700,000 and 60,0000,000.

Universe Feature Matrix

 SAP Lumira DesktopSAP Lumira Server for BI PlatformSAP Lumira Server for TeamsComments
SAP BusinessObjects Universe (.UNV)  

 YES (1)

 
  1. Simple query panel, basic filtering.
 SAP BusinessObjects Universe (.UNX) using the Query Panel Extension

YES

YES (1)

 
 

* General Comments for both UNV and UNX:

  1. Not available with SAP Lumira Personal edition (the free edition)
  2. Requires to connect to a BI Platform which will host the Universe and Data Access. May need to increase the Web Intelligence Parameters "Maximum Character Stream Size" and "Maximum Binary Stream". See KBA 1826015.
  3. Requires minimum BI 4 Platform version. See the PAM - also for further restrictions
  4. Relational based Universes only supported. Some OLAP sources can be connected to using a 'relational-based' Universe
  5. ?Universe/Connection parameter BEGIN_SQL support may be limited?
  6. Multi flow SQL not supported. Only a single result set is currently possible
  7. No Navigation Paths supported
  8. Multi Source UNX universes only supported on the client. Lumira documents consuming Multi source UNX can not be refreshed on the server KBA 2295036 (With Lumira 1.31.7 this may be provided and so this restriction would then be removed)

 

Data Access - Interactive Refresh

 SAP Lumira DesktopSAP Lumira Desktop connecting to BI Platform to consume a 'managed' connection or universeSAP Lumira Server for BI PlatformSAP Lumira Server for TeamsComments
flat files (.csv, .txt)

YES (1)

 

NO

(1) but works

NO

(1) but works

  1. You should place the.xls/.csv/.txt file at a shared location and use UNC path while creating a connection to the source file so the same path is used by the client as the server.
    Additionally, for Windows: The Server Intelligence Agent that is hosting the Lumira Service needs to be running as an Operating System user that is not 'Local System Account', but as an Administrator user with network access and rights to run as a service.
Microsoft Excel

YES (1)

 

YES(1)

 YES

 
Clipboard

NO (1)

 

NO

(1)

NO

(1)
  1. You can't refresh against the clipboard.
Freehand SQL

YES (1)

 

YES (1)

YES(1)

  1. Databases support: SQL Server 2008 & 2012, Oracle, Generic JDBC
HANA online

YES

YES

YES

YES

 
HANA offline

YES

YES

YES

YES

 
SAP BusinessObjects Universe (.UNV)

YES (1) (2)

YES (1) (2)

 

NO

 

NO

  1. not available with SAP Lumira Personal edition (the free edition)
  2. See Universe Feature matrix for restrictions
SAP BusinessObjects Universe (.UNX)

YES (1) (2)

YES (2)

YES (2)

YES(2) 

  1. not available with SAP Lumira Personal edition (the free edition)
  2. See Universe Feature matrix for restrictions
Option to Refresh Visualization within the Story on Opening the Lumira document. Setting is called 'Refresh page on open'

YES (1)

YES (1)

 YES (1)

YES (1)

  1. With the setting 'off' this allow you to view a visualization with the original data used at design time. Setting this to 'on' will refresh the visualization against the data held within the Lumira document, it does not refresh the data against the data source. The setting is in Compose room.
Refresh data on Open

 YES

 YES

 YES

 YES

 
SAP BW

YES

YES

YES

YES

 

 

Data Access - Scheduled Refresh

 SAP Lumira DesktopSAP Lumira Server for BI PlatformSAP Lumira Server for TeamsComments
flat files (.csv, .txt)




YES
enable Lumira Agent to setup local refresh schedules

YES (1)

NO

  1. You should place the.xls/.csv/.txt file at a shared location and use UNC path while creating a connection to the source file.
Microsoft Excel

YES

NO

 
Freehand SQL

NO

NO

 
SAP BusinessObjects Universe (.UNV)

NO

NO

 
SAP BusinessObjects Universe (.UNX)

YES

NO

 
SAP BW

YES

NO

 
Connect to SAP HANA (online)

NO

NO

 
Download from SAP HANA (offline)

YES

NO

 

General Comments

  • Saved values are used for any prompts. It is not currently possible to set the prompts at schedule time. See the table above for which data sources are supported for refresh.

 

 

SSO to Database

  SAP Lumira DesktopSAP Lumira Desktop connecting to BI Platform to consume a 'managed' connection or universeSAP Lumira Server for BI PlatformSAP Lumira Server for TeamsComments
Freehand SQLMicrosoft JDBC

YES

(1)

NO

NO

NO

  1. See KBA 2181269 for setup instructions. Databases support: SQL Server 2008 & 2012.
UniverseUNV

 NO 

YES

(1)

NO

NO

  1. The connection in the Universe needs to be defined as 'SSO' Single Sign-On. See KBA 1995864, 2210624, 2172746
  2. Although officially not supported, it should work.
UNX  

YES

 (1) 

NO  (1) (2)

NO (1) (2)

SAP BWSAP BW

YES(4)

   
 

NO

(1) (3) (5) but works

 YES(1) (2)

NO

  1. Requires an 'OLAP' connection, with Authentication set as 'SSO' (Single Sign-On).
  2. When logging into BI Platform and you do NOT authenticate against SAP, then need to use SAP STS for the two systems to trust each other, otherwise no need for STS.
  3. A Lumira document created on the Desktop using a managed connection hosting on the BI Platform, can take advantage of this connection, but only once the user has entered the credentials to authenticate against the BI Platform.
  4. This is a 'direct' connection to BW and uses SNC
  5. Technically not supported, but works and commonly used. SAP expects documents to be created, in development environment. with a specified user/pass in the managed connection. Then for the LUMX document to then be promoted to Production where the connection is defined as SSO. Thus SSO is supported once the document is on the BI Platform. However it works on the Desktop client too, it just not technically supported.
SAP HANA (4)

Download from SAP HANA (offline)

SAML

SAML No 

KERBEROS

Kerberos Yes (1)

SAML

SAML No  

KERBEROS

 Kerberos Yes (3) 

SAML

SAML Yes (2) 

KERBEROS

Kerberos   Yes   (3)



SAML

SAML Yes (2)    

KERBEROS

Kerberos  Yes   (3)

  1. Requires use of Kerberos and Microsoft Active Directory and a direct connection to HANA, i.e. not using the BI Platform. HANA Server needs to be enabled to delegate authentication. See KBA 1837331
  2. SSO is enabled with the use of SAML. This does NOT require Microsoft Active Directory, instead a SAML Certificate forms a trust relationship between BI Platform and HANA allowing for any authentication means to be used when logging into the BI Paltform. However each BI Platform / HANA user will require a SAML alias in HANA with an identical case of the username (upper/lower case).  KBA 1900023. If using SAML SSO for the BI Platform (typically needed for Linux machines where Kerberos doesn't work), then Kerberos MUST be configured for the desktops in addition to SAML.
  3. Use of Kerberos to both HANA and BI Platform. This requires Microsoft Active Directory Authentication when logging into BI Platform and Active Director Groups to be mapped. See  Setting up Single Sign-On (SSO) with SAP HANA and SAP BI 4 and KBA 1811398
  4. All Lumira to HANA connectivity is provided by an OLAP connection (as defined in the CMC-OLAP Connection) using a JDBC driver (that uses SQL) and not using a HTTP driver.

Connect to SAP HANA (online)

SAML

SAML No

KERBEROS

Kerberos Yes    (1)

SAML

SAML No  

KERBEROS

 Kerberos Yes (3) 

 

 

SAML

SAML Yes (2) 

KERBEROS
Kerberos   Yes (3)

   

SAML

SAML Yes (2)  

KERBEROS

Kerberos   Yes   (3)    

Master KBA on Lumira SSO 2303956

Platform

  SAP Lumira DesktopSAP Lumira Server for BI PlatformSAP Lumira Server for TeamsComments
Life-cycle Management   

YES

(1)
 
  1.  Promotion Management and Version Management support from BI 4.1 SP6 on-wards. Identification of dependencies not yet available.
OpenDocumentLink to Lumira Documentn/a   
Link from Lumira to another on BI Platform passing parametersn/a

YES

  
Audit No

YES

  
Scheduling   

YES

 (1)
 
  1. Saved values are used for any prompts. It is not currently possible to set the prompts at schedule time. See the table above for which data sources are supported for refresh.
Governance and control 

YES

(1)

YES

YES

  1. SAP Lumira Desktop Governance feature is enabled from BI 4.1 SP05 patch5 onwards

 

 

 

For common issues related to Lumira 1.31 please refer to KBA 2334099

If updating your BI Platform to BI 4.2 Support Pack 4 please refer to this blog for particular issues around Lumira

 

 

 

  • No labels

6 Comments

  1. Hi Matthew,

    I'm currently engaged in a Lumira project and I bumped into a limitation documented in note 2342537 - Issues with using Managed HANA OLAP Connection in Lumira Desktop. Under SSO to Database, SAML SSO is not used when you create a Lumira document with a managed connection from the BI platform using the Lumira desktop client. It can only utilize SSO when Kerberos on HANA is setup. Perhaps it would be possible to adjust this part.

    With kind regards,

    Martijn van Foeken | Interdobs

    1. Thank you. Sorry for the confusion and mistake. This has now been corrected in the wiki. Generally speaking, there has been some confusion around the support status of SSO, and part of the reason for creating this wiki is to make it clear and resolve those anomalies. We're working to provide very clear SSO status support with Lumira 2. Stay tuned for a new wiki page for Lumira 2.

  2. Hi Matthew,

    Thanks for the update! Like the update with the colors (wink).

    With kind regards,

    Martijn van Foeken | Interdobs

  3. Hi,

    Above for "General Comments for both UNV and UNX"  #8 mentions "With Lumira 1.31.7 this may be provided and so this restriction would then be removed"   Do you have any more update for this multi source refresh issue on BI Platform?  Is there any version 1.31.7 like that?  I haven't seen anywhere version 1.31.7 !

    1. Hi Tuncay,

      I learned that patch 1.31.7 is planned to be released mid-June. 1.31.6 will be released early June. In 1.31.7 this issue is resolved amongst a lot of other things I have been working on together with SAP Development (wink).

      With kind regards,

      Martijn

      1. Hi Martijn,

        Great news! We are in middle of testing and it's very good to hear 1.31.7 coming soon with multi-source universe support.

        Thanks a lot for the quick response. (smile)