Why default schema is empty ?

[Former Member]

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

[Former Member]

Hi,

Please go through this thread.. Hope it helps.

Regards,

Safiyu

[justin_molenaur2]

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]

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]

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

Regards,

Justin