Can I use a SQL generated view in Calc View?

[Former Member]

Hi Gurus,

I created a view in hana via SQL with 4 columns I am wanting to use in a calculation view but I am getting the following error:

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:exception  1: no.9500000  (mdx/metadata/deployment/deployCalcView.cpp:638)n    An internal error occurred. Assertion failed with error message DeployCalcView::xmlDataSourceTagStart: unsupported view type for D_ROUTING_PIVOTnexception throw location:n 1: 0x00007f0fdfe1c911 in ltt::logic_error::logic_error

D_ROUTING_PIVOT is the name of my view Studio allows me to add the View in a projection and I can join and add the fields but cannot activate the model.

Is this not allowed?

[former_member210482 · Accepted solution]

Hi Alex,

You cannot use a table view in graphical calculation view, but you can use it in scripted calculation view.

Regards,

Safiyu

[lbreddemann]

Nope, it's not allowed.

The information modeler wants to see either tables or other information views as base objects.

- Lars