SAP Knowledge Base Article - Preview

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


Read more...

Environment

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

Product

SAP Lumira, desktop edition 1.0

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.