Answer / divya.k

1)In Cognos Connection Page go to Launch and select IBM
Cognos Adminstration.
2)Select Configuration,select data source connections if the
selected data source is not there in the list.
3)Select New data source icon and create data source that is
in TSQL.
4)Now open report studio and click Query Explorer and select
Queries.
5)Drag new query in insertable objects into the page and
drag SQL from insertable objects right to the corresponding
new Query .
6)In Properties SQL select corresponding data source and
write the syntax n validate it.
The above steps can be done without publishing the package
through FMW in COGNOS.

Answer / mounika

We can report by adding SQL from an external source without
using Query items from Framework.
Steps:--
-->Create a new report with blank page
-->Pause the pointer over the query explorer button and
clink Queries.
-->In intersect objects pane,to build the SQL query drag
SQL to the query.
-->In properties pane double click the datasource property
and click data source
-->Double click SQl or MDx and type SQL
-->validate the SQL.
-->If SQL is valid,then Query items defined in SQl appear
in the data item pane.
-->From insertable pane click list or crosstab or chart or
repeater in working area.
-->Drag query items in to working area from data items tab.
-->save the report.

hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...

2 Answers  

---

Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting

2 Answers   IBM, TCS,

---

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

---

What are the Macros?

3 Answers  

---

What is the difference between macros and prompt?

2 Answers   IBM,

---

can we create master detail report where master and detailed container is separate?

2 Answers   JPMorgan Chase,

---

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'

2 Answers   Cap Gemini,

---

Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  

---

Can you define report item?

0 Answers  

---

Can i apply drill through on chart in report studio?

4 Answers   TCS,

---

how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  

---

Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  

---