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-STD-DEV-MOD , SAP HANA Analytical Modeling , 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.