Table not found in the Caluclation view for XS WebIDE

[venkataramana_paidi]

Hi,

We are planning to connect to the database tables for information models.

I created the multi target application Project. Then I created the SAP HANA Database module. When we creating the module it creates the HDI container and that doesn't have any tables. I need use the SAP HANA schema tables in the modelling.

1. How can I link HDI container with HANA schema to use in the Information models.
2. The system we installed WebIDE has HANA 2 SP04. But we have second test contains HANA 2 SP03. Can we use the database outside the webIDE system?

Thanks & Regards,

Venkata Ramana Paidi

[SreekanthSurampally]

HA300_TEST_HDI_HDB_TEST#OO is the object owner of the HDI container. Let me explain the process in 3 steps for the scenario of accessing classic db schema objects in HDI container developments.

1. Create Customer User provided service to your classic database.(It is like a odbc connection, established between xs classic and HDI container).

2. Create a DB role in XS classic HANA studio, which contains the privileges to access your HANA schema objects.

3. Create the .hdbgrants file in XSA Web IDE in your DB module, by providing the CUPS you created in Step 1 and Role you created in Step 2. It provides the role access to your container object owners.

4. With that, you established connection and privileges on your classic database schema to container object owner(HDI), now you can create synonyms in Web IDE DB module for the the objects of XS classic schema.

That is it, now you can start using the synonyms in your DB module object developments just like they are native in XSA Web IDE.

You can watch HANA academy video or Thomas jung Playlist on this topic.

[david_alzate13]

Hi Sreekanth,

I faced the same error, but It failed when I tried to assign a role created in HANA Studio to the hdbgrants file. The CUPS user has the role "MyPackage.Test::dashboard_view", which it was assigned with gratable to others option enabled (IS_GRANTABLE=TRUE)

Error: Error executing: GRANT "MyPackage.Test::dashboard_view" TO "DASHBOARD_HDI_HDB_CONTAINER#OO";
 (nested message: insufficient privilege: Cannot grant activated roles: line 1 col 7 (at pos 6))
grantor service: "ServiceName_1", type: "sql", user: "CUPSUSER"

The hdbgrants file is like the one below. It started failing when I added the role "MyPackage.Test::dashboard_view", with the schema privileges it was building succesfully. Do you have any idea what else can be failing.

{
	"ServiceName_1": {
		"object_owner": {
"global_roles": [{
				"roles": ["MyPackage.Test::dashboard_view"]
			}],
			"schema_privileges": [{
				"reference": "MY_SCHEMA",
				"privileges_with_grant_option": ["SELECT", "EXECUTE", "SELECT METADATA", "UPDATE", "INSERT", "DELETE"]
			}, {
				"reference": "_SYS_BIC",
				"privileges_with_grant_option": ["SELECT", "EXECUTE"]
			}, {
				"reference": "SAPABAP1",
				"privileges_with_grant_option": ["SELECT"]
			}]
		},
		"application_user": {
"global_roles": [{
				"roles": ["MyPackage.Test::dashboard_view"]
			}],
			"schema_privileges": [{
				"reference": "MY_SCHEMA",
				"privileges_with_grant_option": ["SELECT", "EXECUTE"]
			}, {
				"reference": "_SYS_BIC",
				"privileges_with_grant_option": ["SELECT", "EXECUTE"]
			}, {
				"reference": "SAPABAP1",
				"privileges": ["SELECT"]
			}]
		}
	}
}