Skip to Content
avatar image
Former Member

Why HANA views not visible in composite provider?

Hello, colleagues.

I'm a newcomer in HANA modeling and have some problems with composite provider and hana views. So, my HANA views aren't visible in search, also i haven't radio button search option (search in InfoProvider or HANA views). HANA system are available in project.

Look at screenshots. 1.png 2.png

1.png (4.6 kB)
2.png (29.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 30, 2017 at 04:20 PM

    hi, i had the same problem which was resolved by updating BWMT components to 1.18.20 version and HANA studio as 2.3.27. Also, you can only use views within composit provider as long as HANA instance for both BW & HANA system is same otherwise you won't be able to activate your CP.

    Thanks,

    Kamaljeet

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2017 at 09:18 AM

    Hi...

    Seems User has insufficient privileges to access views.

    Please add following Object Privileges to the SAP<SID> data base user profile:

    Catalog Object: _SYS_REPO

    Privilege: SELECT

    Grantable to Others: No

    Regards,

    Santhosh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17 at 10:04 AM

    Hello,

    Please check if the following solution from the SAP note 2353707 helps.

    Solution

    Please add following Object Privileges to the SAP<SID> data base user profile:

    Catalog Object: _SYS_REPO

    Privilege: SELECT Grantable to Others: No

    Privilege: EXECUTE Grantable to Others: No

    Catalog Object: ACTIVE_OBJECT(_SYS_REPO)

    Privilege: SELECT

    Grantable to Others: No

    Best Regards,

    Radhika Desai

    Add comment
    10|10000 characters needed characters exceeded