Question Re: Why default schema is empty ? in Technology Q&A

Why default schema is empty ?

Former Member — Fri, 19 Dec 2014 15:35:27 GMT

Hi Experts,

I have two questions about default schema ( I use SAP HANA SP6) :

1- Why the default schema when i create an analytic view is empty

2-How can full the list( i tried using mapping schema non succes)

Best regards

justin_molenaur2 — Fri, 19 Dec 2014 17:27:19 GMT

Maybe your _SYS_REPO user doesn't have SELECT access to any of the schemas you are looking at for reading data?

You need to provision the security appropriately.

Regards,

Justin

Former Member — Sun, 18 Jan 2015 17:10:44 GMT

Hi,

Sorry for my reponse late...

Of course The user _SYS_REPO have SELECT privilege ( Because If he haven't this privilege he can't activate my views of this schema.

justin_molenaur2 — Mon, 19 Jan 2015 21:13:21 GMT

Maybe you need to have at least one schema defined within the schema mapping configuration?

Regards,

Justin

Former Member — Thu, 22 Jan 2015 10:39:43 GMT

Hi,

Please go through this thread.. Hope it helps.

Regards,

Safiyu