COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: sameena on 09 Apr 2014 05:11:02 AM

Title: cant create query subject in FM
Post by: sameena on 09 Apr 2014 05:11:02 AM
Hi all,

I am getting the following error on creating query subjects..BMT-MD-0003 RQP-DEF-0060 The source of the query subject CARTON_HDR is invalid. 

Thanks,
Sam
Title: Re: cant create query subject in FM
Post by: saumil287 on 09 Apr 2014 05:37:32 AM
Hi

  What datasource you are using?
Are you writing the query to get the table, If yes then first check the datasource whether that table is present in the database.



Regards
saumil
Title: Re: cant create query subject in FM
Post by: sameena on 09 Apr 2014 05:51:35 AM
Hi,
    I am trying to create a model query subject from the existing query subjects in the model.i have created a package and published it and  it works fine, but when I try to create a new query subject or import data from other models it throws error.. please let me know if there are restrictions set any where for security issues.

Thanks in advance
Sam
Title: Re: cant create query subject in FM
Post by: saumil287 on 11 Apr 2014 11:31:15 PM
Hi,

You are saying that you are not able to create a model query subject based on existing query subjects. This is what you are trying to say?

You are getting issue while creating a datasource query subjct or model query subject?

Can you explain the smt in details you entered "I try to create a new query subject or import data from other models it throws error."

Regards
saumil

Title: Re: cant create query subject in FM
Post by: sameena on 12 Apr 2014 05:52:42 AM
Hi..
   You are right..I am not able to create model query subjects based on existing query subjects. 

But all the tables that are used in the current model are present in the database. i have attached the error snapshot along.

We do not have access to database from the model. So cant test  data too..

Regards
Sam

Title: Re: cant create query subject in FM
Post by: saumil287 on 14 Apr 2014 01:33:25 AM
Hi
what datasource you are using?
are you using notes sql or something which is not rdbms?



regards
saumil
Title: Re: cant create query subject in FM
Post by: Lynn on 14 Apr 2014 07:51:01 AM
Quote from: Sam85 on 12 Apr 2014 05:52:42 AM
...

We do not have access to database from the model. So cant test  data too..

...

:o

You should have access to the database from the model. Database access is needed for meta data as well as for data.
Title: Re: cant create query subject in FM
Post by: sameena on 21 Apr 2014 01:50:21 AM
Thank you all...:-) ???