No data in datapreview

[Former Member]

Hi All,

I have created an analytic view using a table. Am able to see data in the table. But when i see the data preview of the analytic view i couldnot see any data.

Please suugest.

best regards,

Krishna.

[sagarjoshi · Accepted solution]

Did you check if the view Default Client is set to 'Session Client' and if the user you are using has set correct session client (Security -> <User> -> Session client field?

This may be one of the reasons why you may be seeing this problem.

[Former Member · Accepted solution]

Hi sagar,

Thank you. We have selected the Default Client as Dynamic which was not supporting here. When i changed to cross client am able to prview the data.

Thanks a lot.

best Regards,

Krishna.

[former_member182302]

Hi Krishna,

Did you have any joins in the analytic view? Did you check them?

Are you facing any error or it is just no data ?

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

No joins. Simply i used the table. Do i need any schema level access to be assigned to _SYS_REPO???

Krishna.

[rindia]

Hi Krishna,

Could you paste your AN view and also Query result of the table.

Regards

Raj

[former_member182302]

Hi Krishna,

If authorization is the issue then it would be throwing the error.

Did you check all the required auhoriazations are given to the _SYS_REPO.

Regards,

Krishna Tangudu

[former_member674890]

There could be different reasons

please try this

Take SQL statement from data preview log and execute the statement from SQL console.

1). assume you are RAW data tab and no data showed up

2). click show log to view sql statement

[Former Member]

Hi ,

Thanks a lot for your valuable suggestions. The issue got resolved. The issue was with Session Client.

Best Regards,

Krishna.

[Former Member]

Hi Krishna,

Thanks a lot for your valuable suggestions. The issue got resolved. The issue was with Session Client.

Best Regards,

Krishna.

[Former Member]

Hi Raj,

Thank you. The issue got resolved. The issue was with Session Client.

Best Regards,

Krishna.