cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA analytical attribute - active version of the object does not exist

bhat_vaidya2
Active Participant
0 Kudos

Hi,

I have created an analytical attribute but unable to preview the data content because  I always get error message that " Active version of the object does not exist".

Does anyone knows how I can resolve it.

thanks,

Bhat

Accepted Solutions (1)

Accepted Solutions (1)

former_member184768
Active Contributor
0 Kudos

Hi Bhat,

It seems your view is not activated. Can you please click on validate and Activate buttons (on right hand top corner) and check if there is any error in activation.

On successful activation, please try the Preview option.

Regards,

Ravi

bhat_vaidya2
Active Participant
0 Kudos

Hi,

I cannot validate and activate as  I get error message.

Former Member
0 Kudos

Hi Vaidya,

please choose one error record, and right-click it to click "open job log file" item to check error detail information, I think that you may not define measure for your analytic view.

Regards,

Jerry

Former Member
0 Kudos

Hi Bhat,

  Please make sure that, you need to select at least one attribute as "Key attribute".

I hope in your scenario COACH_ID as key attribute.

Change the properties of attribute as  Key Attribute= True. 

Please try .

Thanks

Basha.

former_member184768
Active Contributor
0 Kudos

Hi Bhat,

As mentioned please add the Key column, also please look into the Error log. It generally provides more details on what the issue is.

Regards,

Ravi

bhat_vaidya2
Active Participant
0 Kudos

Hi,

thanks for letting me know. I have change the COACH_ID attribute to Key and there is some improvement as  I can validate the model.

However, I still cannot activate it as I can see from the logs that it might be because  I do not have sufficient privilege.

Former Member
0 Kudos

Hi Bhat,

Execute the below command on SQL editor.

Try.

grant select on schema <your schema name> to _SYS_REPO with grant option

after that execute the your model.

Thanks

Basha.

bhat_vaidya2
Active Participant
0 Kudos

Hi Basha,

Wow, it worked like a charm. Big thanks to you.

- Bhat

Answers (1)

Answers (1)

Former Member
0 Kudos

HI Vaidya,

You did not save and activate your analytic view, please refer to attached.

It maybe help you to resolve your trouble.

Regards,

Jerry