Symptom
SAP Lumira in HANA Online mode does not run on SAP HANA Live analytic/calculation views
Other Terms
SAP Lumira, SAP HANA Studio, SAP HANA Live, analytic view, calculation view, Hana Online, access error
Reason and Prerequisites
Additional SQL, Analytic, and System privileges need to be set in SAP
HANA Studio to allow SAP Lumira to run the analytic/calculation view in
Hana Online mode.
Solution
To ensure that SAP Lumira can run analytic/calculation views
available in SAP HANA Live, the following SQL, Analytic, and System
privileges must be activated in SAP HANA Studio:
Lumira 1.14 :
SQL privilege for _SYS_BI:The SELECT privilege on schema _SYS_BI is required to grant access to BI system views (metadata on information views).
SQL privilege for your column views in _SYS_BIC:The SELECT privilege on the runtime objects corresponding to the modeled analytic/calculation views is required to let Lumira query your views.
Example: GRANT SELECT ON "_SYS_BIC"."MyPackage/MyAnalyticalView" TO MyUser
Analytic privileges on analytic/calculation views:For the views that are enabled for analytic privileges, make sure your BI user has been granted an analytical privilege on each of these views.
System Privilege SCENARIO ADMIN:For complex queries, Lumira generates calculation scenarios. The SCENARIO ADMIN privilege is thus required to CREATE and DROP these scenarios.
Lumira 1.14 :
SQL privilege for _SYS_BI:The SELECT privilege on schema _SYS_BI is required to grant access to BI system views (metadata on information views).
SQL privilege for your column views in _SYS_BIC:The SELECT privilege on the runtime objects corresponding to the modeled analytic/calculation views is required to let Lumira query your views.
Example: GRANT SELECT ON "_SYS_BIC"."MyPackage/MyAnalyticalView" TO MyUser
Analytic privileges on analytic/calculation views:For the views that are enabled for analytic privileges, make sure your BI user has been granted an analytical privilege on each of these views.
System Privilege SCENARIO ADMIN:For complex queries, Lumira generates calculation scenarios. The SCENARIO ADMIN privilege is thus required to CREATE and DROP these scenarios.
Header Data
| Released On | 22.01.2014 14:54:43 | ||
| Release Status | Released for Customer | ||
| Component | BI-LUM-DSK SAP Lumira (Desktop) | ||
| Other Components |
| ||
| Priority | Correction with high priority | ||
| Category | Help for error analysis |
It's so nice article thank you for sharing a valuable content. Sap hana Online Access
ReplyDelete