SAP Knowledge Base Article - Preview

2767583 - Analytic Privilege: Creating 2 views with restrictions on the same column

Symptom

- You have an Analytic Privilege (AP0)

- Within AP0, there are 2 views: View A and View B

- View A has a restriction on column Test for value "testA"

- View B has a restriction on column Test for value "testB"

- When querying View A for column Test:

Expected result: It only returns value testA

Actual results: It returns values testA and testB


Read more...

Environment

Hana 1.0 and 2.0

Product

SAP HANA, platform edition 2.0

Keywords

Analytic; Privilege; restriction; view; filter; AND; OR; column; model; modelling , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

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