No Data In HANA View

[Former Member]

Hi Experts,

I have a simple calculation view on a single table without any filters. I can see data when I do Table > Data Preview.

But when I run the calculation View I can't see any data coming through.

I am not sure what may be the problem. What I know is data volume is huge in this table. May that be a reason here?

Or some authorization problem.

Regards

Jitendra

[chandan_praharaj · Accepted solution]

Hi Jitendra,

You just check the setting of your calc view, try chaning the Default Client to Session client or Cross Client.

It will work. For some system I have seen this issue is there.

[Former Member · Accepted solution]

Hi All,

Just to bring clarity, CV properties are:

Data Category: Cube

Client: Session

Privileges: None

When I can the CV in SQL or run data preview I see no data.

No filters or variables in CV.

Regards

Jitendra

[Former Member · Accepted solution]

Hi Jitendra,

Hope you know the concept of client, please go through What is the "Session Client"? | SCN , Default Client Values - SAP HANA Modeling Guide for SAP HANA Web Workbench - SAP Library once.

If you put as Session Client in view, it checks for the value set in user session client. If the values of table are not matching to the client value, no data will be fetched.

Change your client to 'Cross client'(which ignores the value set in session client and filters all data), activate and try data preview.

Best Regards,

Shireesha

[chandan_praharaj · Accepted solution]

Change the Client to Cross Client ,and check you can be able to see the data.

[gulshan_tejaswi · Accepted solution]

I had the same Issue.
I changed my Session client to Cross , and it fixed it.

[former_member200930]

Hi Jitendra,

Please use following query to verify data.

select top 10 * from "_SYS_BIC"."<<Your_VIEW_Name>>";

if still you are not able to view data then please share some screenshot. So, we can provide more information for your problem.

[former_member182997]

hi Jitendra,

meanwhile to clear the confusion why not run a select statement in SQL editor calling the came table on which calculation view you have created.

thanks- Aparajit

[Former Member]

Hi,

I tried as well. Can see data in CV but in table.

regards

Jitendra