Skip to Content
avatar image
Former Member

Cannot get Data Provider outline

Hi,

I created an Analytic view with three tables. The middle table is an association table which connects the two tables with ID's. I activate it fine and then when I go to do the data preview I get:

SAP DBTech JDBC: [2048]: column store error: search table error:  [6941] Error executing physical plan: AttributeEngine: this operation is not implemented for this attribute type;index=NIEM_CORE:FACILITYPERSONASSOCIATIONTYPEen,attribute='PERSONNAMETYPEID' (203),BwPopJoin2Inwards pop10(NIEM_CORE:FACILITYPERSONASSOCIATIONTYPEen.PERSONNAMETYPEID, .PERSONNAMETYPEID to .FACILITYTYPEID),in executor::Executor in cube: _SYS_BIC:UNICEF/AN_FACILITY_NEEDS

No idea why I am getting this. When I have it as an attribute view it works fine.

Screenshot of analytic view attached.

Thanks,

Connor

Analytic View.JPG (167.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 22, 2014 at 08:53 AM

    Can you check the data types of the columns? Are they same?

    Regards,

    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      In my association table I had them as stings and in my other tables as integers. It worked in the Attibute view but not in analytic. Thanks Krishna.

  • avatar image
    Former Member
    Sep 22, 2014 at 10:28 AM

    Hi,

    check once in sql console by writing select syntax from "_SYS_BIC".

    minimum one aggregate function must be used to access Analytical view...

    for checking purpose whether any simple aggregation function can be used..

    so that whether tables joined relationships (inner/left join) conditions on primary key columns is working or not..

    check the no of records is coming correct or not..

    then it will me easy to debug in analytical view.

    Hope this will helpful for you..

    Thanks.

    Thara

    Add comment
    10|10000 characters needed characters exceeded