COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: Sugs on 12 Jul 2019 05:45:21 AM

Title: FM SQL - XQE-PLN-0012 column could not be found in the model
Post by: Sugs on 12 Jul 2019 05:45:21 AM
I am writing some simple SQL in Framework manager writing back to a Teradata database. In the SQL I have created a new column called Diff and yet when i try to reuse that column as a filter later on in the code I get the error message above saying it does not exist. Can anyone shed any light on this?     
Title: Re: FM SQL - XQE-PLN-0012 column could not be found in the model
Post by: bus_pass_man on 12 Jul 2019 08:24:33 AM
I suspect that you're trying to over-complicate things and your filter expression could be created without too much fuss.  Have you just tried to create a filter with the required expression? 

If so, what results did you get?

If not, why not? 



Other things to consider:

1.  Write back isn't supported.
2.  If you need the column so bloody much why doesn't it already exist in your dw?
3.  Why are you writing a SQL statement?
4.  Assuming you really really really need to do such a thing, a normal SQL statement should allow you to create the column in the projection list.
5.  Have you tried creating a model query subject and create the column with an analogue to whatever expression you are trying to use and then use it as the basis for your filter?