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
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.