on 09-19-2014 6:53 PM
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
Can you check the data types of the columns? Are they same?
Regards,
Krishna Tangudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.