I have created a table and used that table in the attribute view.I made one of the colums as Key attribute in the Semantic Layer. When I am validating the Attribute View . I am getting the below error .
Appreciate your help on this.
if "_SYS_REPO" user doesn't have "select" privilege on your schema, you will get this error while validation of view.
Please fallow below procedure:
1. go to security node of your HANA DB-->user-->
2. click on _SYS_REPO user
3. go to object Privilege tab
4. add either your schema or table then provide select privilege on it.
now try to validate your view again. Validation will go through now.