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.
SAP Knowledge Base Article - Preview