Question Re: Datasphere - shared view is not available in Database in Technology Q&A

Datasphere - shared view is not available in Database

Venky999 — Mon, 08 Apr 2024 08:38:44 GMT

Hi ,

I shared a view from SPACE A to SPACE B in datasphere. The view is accessible for the users in Space B application layer but not visible in database for the SPACE B database user. The view is already exposed for consumption.

Is there any way to make view available in database or it's just a limitation in SAP datasphere ?

Please share your thougths

Thanks,

Venky

Re: Datasphere - shared view is not available in Database

tmeyer — Mon, 08 Apr 2024 07:15:22 GMT

Hi,

when it is shared, you could use the "SPACE"."VIEW" to access the object on the HANA Database Explorer.

Re: Datasphere - shared view is not available in Database

Venky999 — Mon, 08 Apr 2024 07:23:55 GMT

It’s not visible in database explorer under views folder

Re: Datasphere - shared view is not available in Database

tmeyer — Mon, 08 Apr 2024 07:43:54 GMT

That is right but it should work either

Re: Datasphere - shared view is not available in Database

Venky999 — Mon, 08 Apr 2024 08:02:15 GMT

Unfortunately its throwing error that ‘couldn’t find table/view’

Re: Datasphere - shared view is not available in Database

XaviPolo — Mon, 08 Apr 2024 08:09:28 GMT

I don't know if the "expose by default" option in the space configuration affects the views shared with this one, but if you have it activated and you don't see it, you can always create a new view in the SPACE B that reads from shared view, and then expose the new view.

Regards,

Re: Datasphere - shared view is not available in Database

Venky999 — Mon, 08 Apr 2024 08:16:30 GMT

Well, actually i need the shared view visible in DB explorer as my actual requirement is to access this view from the shared space in Power BI ODBC.

its a security requirement that i need to share a view to another space (Business self-service) and let users acccess it from there..

Re: Datasphere - shared view is not available in Database

XaviPolo — Mon, 08 Apr 2024 08:32:25 GMT

yes, you have the A SPACE where original view is allocated. Shared with B SPACE where the users wan to consume that view.
To allow access from B SPACE SQL Schema, you need to expose the view in that space.

Is the shared view is not exposed automatically then you can create in B SPACE a new view reading from the shared one, and then activate the "expose" in that view to be published in SQL of the B SPACE.

Re: Datasphere - shared view is not available in Database

Venky999 — Mon, 08 Apr 2024 08:37:04 GMT

Yes the original view in space A is already exposed for consumption but Space B database user not able to access it in db explorer , and same in odbc power bi. That’s the issue, i do not want to create another view on top of original view in space B. Its a security design limitation i have..

Re: Datasphere - shared view is not available in Database

XaviPolo — Mon, 08 Apr 2024 08:49:54 GMT

This is not an issue.

You defined the original view as exposed in SPACE A, ok, this is something related to SAPCE A over an object of SPACE A.

Then you shared it to SPACE B, and it's here in SPACE B where you must define the security of the object in SPACE B. if it is exposed or not to the SQL of SPACE B. Something defined in the SPACE A (as exposed attr) can't overwrite the security of the SPACE B.
So to define the usage in the SPACE B, create an object in SPACE B and manage it.

Regards,

Re: Datasphere - shared view is not available in Database

Venky999 — Mon, 08 Apr 2024 08:56:13 GMT

I agree, that’s the ideal way to deal this case.

shared object purpose in datasphere is defeating i believe. The purpose of shared object is that other space can consume the object as it is without need to create it. If it is accessible at only shared space application layer but not available in shared space database schema, then i see some gap.

Re: Datasphere - shared view is not available in Database

Venky999 — Tue, 09 Apr 2024 16:45:42 GMT

SAP confirmed in case that it's a limitation issue, The sharing view works on datasphere level, not at DB level, this is why the view is not replicated to another space. I raised an improvement request #320530.