Skip to Content
avatar image
Former Member

Can I use a SQL generated view in Calc View?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 05, 2015 at 01:37 PM

    Hi Alex,

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

    Regards,

    Safiyu

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 05, 2015 at 12:32 AM

    Nope, it's not allowed.

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

    - Lars

    Add comment
    10|10000 characters needed characters exceeded