where do we write the sql queries in Cognos 11

[mastan]

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?

[Lynn]

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.

[mastan]

Hi, thanks for the reply where can I see the Framework Manager in the Cognos 11. Could you please help me on this?

[Lynn]

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

[mastan]

Does the Framework manager come with the Cognos server.exe file? Or we have to buy and install it separately?

[Lynn]

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.

[mastan]

Hi Thanks for your reply...!
Now I have a queries in my FM how would I use these for my dashboard?


Thanks,
Mastan.