Skip to Content

Refresh and Data Source support for Lumira Document in SAP BI

SAP Lumira, server for BI Platform supports Refresh on following data sources.

SAP Lumira, server for BI Platform 1.25

  • XLS/CSV/TXT
  • FHSQL
    • MS SQL Server 2008
    • MS SQL Server 2012
    • Oracle 11
    • Generic JDBC
  • Universe based on Query Panel Extension

SAP Lumira, server for BI Platform 1.28

  • SAP Business Warehouse 7.x
  • HANA Online (Revision 82, 83, 84, 85, 96, 97)
  • HANA Offline (Revision 82)

SAP Lumira, server for BI Platform 1.29

  • FHSQL
    • Oracle 12c
    • Teradata 14.1
    • Teradata 15
    • My SQL 5.0
  • HANA Online (Revision 102)
  • HANA Offline (Revision 83, 84, 85, 96, 97, 102)

Refresh on Open (added from SAP Lumira, server for  BI Platform 1.29)

  • Ability to Save document without data to enforce refresh on open for enhanced security to restrict the users to view document only with authorized data (also referenced as Refresh on Open)
  • Supported for HANA, BW and UNX Datasources

To support refresh on the BI Launchpad, you would have to make sure pre-requisites are met for respective data sources. Refer to Configuring Pre-Requisites for Data source support

You must be aware of the following behavior based on data source while refreshing a document.

  • XLS/CSV/TXT
    • Refresh goes through with no credential prompt


  • FHSQL
    • User would be prompted for credentials on data base


  • Universe based on Query Panel Extension
    • DB Authentication
      • The behavior depends on the authentication mode configured on Connection
        • Pre-Defined: Passed the pre-defined credential to DB for refresh
        • SSO: does SSO to DB with user credentials and mapping
      • In both the case user wouldn’t be prompted for credentials

    • Prompts (Parameter / Query Panel)
      • Ability to change prompt values while refreshing the document is added from SAP Lumira, server for  BI Platform 1.28
      • Following is the behavior in case you are on release earlier than SAP Lumira, server for  BI Platform 1.28
        • Prompts aren’t supported for Universe in refresh workflows
        • Prompt values provided during query creation / edit will be used for refresh workflows in BI Launchpad

  • SAP Business Warehouse
    • DB Authentication
      • User would be prompted for SAP BW credentials if the document is created with Local connection (imported from SAP GUI or Connection details manually entered in desktop) to SAP BW
      • The behavior depends on the authentication mode configured on OLAP connections in CMC for Managed connections
        • Pre-Defined: Passed the pre-defined credential to DB for refresh
        • SSO: does SSO to DB with user credentials and mapping
        • Prompt: User would be prompted for SAP BW credentials

    • BEx Variables
      • User would be able to change the values for BEx variables while refreshing the document

  • HANA Online and Offline  
    • DB Authentication
      • HANA Online and Offline only supports Local connections created in Lumira Desktop.
      • SSO is supported for Lumira Document based on SAP HANA, if SAML SSO is configured between BI 4.1 and SAP HANA, otherwise user would be prompted for credentials

    • Variable and Parameters
      • Change Variable and Input Parameter values supported (added from SAP Lumira, server for  BI Platform 1.29)
        • during Refresh for HANA Offline
        • With Prompt Icon for HANA Online
      • Following is the behavior in case you are on release earlier than SAP Lumira, server for  BI Platform 1.29
        • Values provided during query creation / edit will be used for refresh workflows in BI Launchpad
Tags:
Former Member