Not able to do data preview for a calculation view in sap hana

[Jagadeesh]

Hi,

I have created a calculation view and i am able activate it. But the problem is when i am try to do data preview , it is showing an error Data Preview is not possible;

object is either inactive or broken. If it is an inactive object, activate it, else redeploy.

Can any one help on this?

Thanks in advance.

Best Regards,

Jagadeesh kenguva

[pfefferf]

Have you followed the information given by the error message? Have you checked if your view is inactive or broken?

[Jagadeesh]

Hi florian,

Thank you for your quick reply,

Yes, i fallowed the error and my view is in active state only.

[former_member183326]

Check the traces to see what is occurring, check the console for a more detailed error.

[sap_cohort]

Are you able to run an SQL on the Calculation View?

[sai_v]

Hi Jagadeesh,

Are you able to see the data preview at node levels before semantic.?

Regards,

Sai.

[Jagadeesh]

Hi Kenneth,

Thank you for your reply.

When i run an SQL on this view ,it is showing an error that

could not execute 'select * from "_SYS_BIC".<viewname> '

insufficient privilege: Not authorized,

I know how to grant the 'select/insert/delete/update' to my schema( GRANT SELECT ON SCHEMA <myschema> TO _SYS_REPO ). But i can't understand how to do it for _SYS_BIC.

[Jagadeesh]

Hi sai,

i didn't get your point (Are you able to see the data preview at node levels before semantic.?).

Could you please be more specific?

Regards,

jagadeesh

[deepikasesh]

Hi,

Use this. Thanks.

[Former Member]

Could you please suggest how did you get out this issue.Now, I am facing the same issue.