Skip to Content
0

Unable to find all HANA views in Analysis for Excel

Sep 28, 2017 at 06:17 AM

94

avatar image
Former Member

Hi

I have logged on to Analysis for Excel with my BW credentials.

When selecting a Data Source and I search for HANA views I do not see all the Analytic and Calculation views that have been created under the same package.

I do have access to _SYS_BIC schema and can see the views in the 'Column Views' folder.

I have checked all the properties and compared the views I can find in Analysis against the views I can't find and everything is the same - including the Data Category set as 'CUBE"'.

What am I missing that I can't find all HANA views?

Rgds

Anton

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Sep 29, 2017 at 07:38 AM
0

Hi Erdem - below is a screenshot of the steps I am taking...


analysis.png (113.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Erdem Pekcan Sep 28, 2017 at 07:13 AM
0

Hi Anton,

If you logon to BW application layer, you will not see HANA objects.
To access them you should create a connection in BO and then logon with BO credentials. If you don't have a BO installation then you should create an Open ODS View and connect it to your HANA views.

Regards,
Erdem

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Erdem

Thanks for the reply, but I don't agree with you.

As per my initial post, I can find and execute some HANA views in Analysis, but others don't appear when I search for them - even though they are created under the same package and the properties are all the same.

Rgds

Anton

0

If you're logging on to HANA with your BW credentials, that's fine. Then we should investigate the restrictions for the views you're looking for.

However if you logon to BW directly, then please share a screenshot of the views that you see in info areas.

0
Former Member

Hi Erdem - below is a screenshot of the steps I am taking...

0