Validating an attribute view

[Former Member]

Hi,

I very new to Hana and started on the free trial on the cloud. I've built a simple attribute view on the sFlight sample data. When i try to validate the view i get the following please help;

Validation of multiple objects Summary of Validation Validation of AT_SFLIGHT Detail Validation Result Validation of sflight-demo.AT_SFLIGHT Client side validation Table Validity Rule sflight-demo.AT_SFLIGHT: SQL Table Validity Successful Check join: SQL sflight-demo.AT_SFLIGHT: Join - SQL Validity Successful Join Data Type Compatibility sflight-demo.AT_SFLIGHT: Join Data Type Validity Successful Attribute Existence Check sflight-demo.AT_SFLIGHT: Attribute Existence Check Successful Key Attribute Validity Check sflight-demo.AT_SFLIGHT:No Visible Key Attribute Found in the Attribute View Hierarchy Level Validate Rule sflight-demo.AT_SFLIGHT:Hierarchy Level Validate Rule:Skipped Unique Constraint Check sflight-demo.AT_SFLIGHT: Unique Constraint Check Successful Participant Element check sflight-demo.AT_SFLIGHT:Participant Element check Successful BI Virtual InfoProvider Rule sflight-demo.AT_SFLIGHT:Name Validate Rule successful Filter Validate Rule sflight-demo.AT_SFLIGHT:Filter Validate Rule:Skipped Large object data type check rule sflight-demo.AT_SFLIGHT: Large object data type validation check successful Data foundation Join Validate Rule sflight-demo.AT_SFLIGHT :Data foundation  Join Validate Rule successful ABAP Name Check sflight-demo.AT_SFLIGHT: ABAP name validity successful Server side validation Activation Id:15 Repository: Activation failed for at least one object;At least one runtime reported an error during activation. Please see CheckResults for details

Best regards

Desmond

[lbreddemann · Accepted solution]

Hi Desmond,

looks like you missed to choose one (or several) output columns that should be the logical key for the attribute view:

Key Attribute Validity Check

• sflight-demo.AT_SFLIGHT:No Visible Key Attribute Found in the Attribute View

Just mark the columns you want to be the key of the attribute view as such in the semantics view and re-try the activation.

- Lars

[Former Member · Accepted solution]

Thanks very much it worked.

[Former Member]

HI,

As mentioned by Lars , you missed to add one of your column in view as key attribute. you have to specificly mark in attribute view , a particular field as your key field. Just change the attribute as key field in type column.

Thnkss

Kulwinder

[Former Member]

Thanks very much it worked.