Which features do SAP HANA SQL-based analytic privileges offer compared to classic XMLbased ones? Note: There are 2 correct answers to this question.

Question

Options

• AControl of read-only access to SQL views
• BControl of read-only SAP HANA procedures
• CTransportable
• DComplex filtering

• A
  73% (30)
• B
  20% (8)
• C
  7% (3)

Explanation

These are some of the features that SAP HANA SQL-based analytic privileges offer compared to classic XML-based ones. Analytic privileges are privileges that restrict access to data in analytical views or calculation views based on certain conditions or filters. SAP HANA supports two types of analytic privileges: SQL-based and XML-based. SQL-based analytic privileges are defined using SQL statements and stored as database objects. XML-based analytic privileges are defined using XML files and stored as repository objects. SQL-based analytic privileges offer more features and flexibility than XML-based ones, such as control of read-only access to SQL views, which prevents users from modifying data in the views, and complex filtering, which allows users to define multiple filters with different operators and expressions.

No community discussion yet for this question.