Skip to Content
avatar image
Former Member

Unable to find all HANA views in Analysis for Excel

Sep 28, 2017 at 06:17 AM | 226 Views

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

SAP BW/4HANA
SAP Analysis for Microsoft Office | calculation view | analysis for office
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Erdem Pekcan
    Sep 28, 2017 at 07:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded