COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: mastan on 05 Nov 2018 01:31:01 AM

Title: where do we write the sql queries in Cognos 11
Post by: mastan on 05 Nov 2018 01:31:01 AM
Hi Team,
I have connected the Hive data source successfully. After that, I need to write some SQL queries which will help me to create the dashboard. I could n't find out the option to write the query.

Could anyone please help on this?
Title: Re: where do we write the sql queries in Cognos 11
Post by: Lynn on 05 Nov 2018 01:59:33 AM
Quote from: mastan on 05 Nov 2018 01:31:01 AM
Hi Team,
I have connected the Hive data source successfully. After that, I need to write some SQL queries which will help me to create the dashboard. I could n't find out the option to write the query.

Could anyone please help on this?

You can use the dashboard tool using packages built in Framework Manager, uploaded data files, or data modules.
Title: Re: where do we write the sql queries in Cognos 11
Post by: mastan on 08 Nov 2018 01:08:23 AM
Hi, thanks for the reply where can I see the Framework Manager in the Cognos 11. Could you please help me on this?
Title: Re: where do we write the sql queries in Cognos 11
Post by: Lynn on 08 Nov 2018 01:54:26 AM
Quote from: mastan on 08 Nov 2018 01:08:23 AM
Hi, thanks for the reply where can I see the Framework Manager in the Cognos 11. Could you please help me on this?

Framework Manager is a modelling tool that is installed on a client machine. You use this to produce a meta data layer over your data source.

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/c_install_fm.html
Title: Re: where do we write the sql queries in Cognos 11
Post by: mastan on 12 Nov 2018 06:15:37 AM
Does the Framework manager come with the Cognos server.exe file? Or we have to buy and install it separately?
Title: Re: where do we write the sql queries in Cognos 11
Post by: Lynn on 12 Nov 2018 07:50:13 AM
Quote from: mastan on 12 Nov 2018 06:15:37 AM
Does the Framework manager come with the Cognos server.exe file? Or we have to buy and install it separately?

You should spend some time reviewing the available documentation
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.cbi.doc/manuals.html

Framework Manager is a modeling tool that is available as part of the product.
Title: Re: where do we write the sql queries in Cognos 11
Post by: mastan on 28 Nov 2018 01:05:36 AM
Hi Thanks for your reply...!
Now I have a queries in my FM how would I use these for my dashboard?


Thanks,
Mastan.