Skip to Content
0

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

Dec 06, 2017 at 02:13 PM

298

avatar image

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

capture1.png (10.2 kB)
10 |10000 characters needed characters left characters exceeded

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

0

Hi florian,

Thank you for your quick reply,

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

0

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

0

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

0

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.

0
Former Member

Hi Jagadeesh,

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

Regards,

Sai.

0

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 20 at 11:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded