SAP Knowledge Base Article - Public

2196362 - Cannot add a dataset via Connect to SAP HANA in SAP Lumira

Symptom

Attempting to add a dataset via Connect to SAP HANA in SAP Lumira shows a blank list of SAP HANA Views

For the first list of SAP HANA Views Trace Log at HIGH level shows:

[com.sap.hilo.datasource.hanaview.internal.context.Helpers]Query[###] : select "COLUMN_OBJECT", "CATALOG_NAME", "CUBE_NAME", "DESCRIPTION", "VIEW_TYPE" FROM "_SYS_BI"."BIMC_CUBES" BIMC_CUBES INNER JOIN "SYS"."ACCESSIBLE_VIEWS" ANALYTIC_PRIVILEGES ON (BIMC_CUBES."CATALOG_NAME" || '/' || BIMC_CUBES."CUBE_NAME" = ANALYTIC_PRIVILEGES."VIEW_NAME") LEFT OUTER JOIN "SYS"."VIEWS" VIEWS_INFO ON (ANALYTIC_PRIVILEGES."VIEW_NAME" = VIEWS_INFO."VIEW_NAME") WHERE ANALYTIC_PRIVILEGES.USER_NAME = 'MYUSER' AND ANALYTIC_PRIVILEGES.SCHEMA_NAME = '_SYS_BIC' ORDER BY "CATALOG_NAME" ASC, "CUBE_NAME" ASC

For the second list of SAP HANA Views Trace Log at HIGH level shows:

[com.sap.hilo.datasource.hanaview.internal.context.Helpers]Query[###] : select "COLUMN_OBJECT", "CATALOG_NAME", "CUBE_NAME", "DESCRIPTION", "VIEW_TYPE" FROM "_SYS_BI"."BIMC_CUBES" BIMC_CUBES INNER JOIN "SYS"."ACCESSIBLE_VIEWS" ANALYTIC_PRIVILEGES ON (BIMC_CUBES."CATALOG_NAME" || '/' || BIMC_CUBES."CUBE_NAME" = ANALYTIC_PRIVILEGES."VIEW_NAME") LEFT OUTER JOIN "SYS"."VIEWS" VIEWS_INFO ON (ANALYTIC_PRIVILEGES."VIEW_NAME" = VIEWS_INFO."VIEW_NAME") WHERE ANALYTIC_PRIVILEGES.USER_NAME = 'myuser' AND ANALYTIC_PRIVILEGES.SCHEMA_NAME = '_SYS_BIC' ORDER BY "CATALOG_NAME" ASC, "CUBE_NAME" ASC

Environment

  • SAP Lumira 1.27.1 upgraded from SAP Lumira 1.25 or earlier
  • SAP HANA SPS9 upgraded from SAP HANA SPS8 or earlier

Reproducing the Issue

  1. Start SAP Lumira and create a New Document
  2. Select Connect to SAP HANA as the data source
  3. Select an SAP HANA server from the drop down that has Save Password checked and connect
  4. Select an SAP HANA View and click Create
  5. Select Data | Add Dataset...
  6. Select Connect to SAP HANA as the data source
  7. Notice that the list of SAP HANA Views is empty

Cause

At some point the SAP HANA User was entered in lower case "myuser" instead of uppercase "MYUSER".

Uppercase is required with SAP HANA SPS9 and later versions of SAP Lumira enforce this.

Resolution

  1. Start SAP Lumira and create a New Document
  2. Select Connect to SAP HANA as the data source
  3. Select an SAP HANA server from the drop down that has Save Password checked
  4. Uncheck Save Password and delete both the user and the password
  5. Renter both the user and the password and connect
  6. Select an SAP HANA View and click Create
  7. Select Data | Add Dataset...
  8. Select Connect to SAP HANA as the data source
  9. Notice that the list of SAP HANA Views is no longer empty

Keywords

no views empty list can't add additional second analytic calculation views , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , HAN-DB , SAP HANA Database , Problem

Product

SAP Lumira, desktop edition 1.0