How to write the necessary TSQL to create data sets, pull the data sets in Cog

How to write the necessary TSQL to create data sets, pull the
data sets in Cognos Report Studio WITHOUT using framework
manager.

Question Posted / vvk

2 Answers
5951 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WI..

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.

Is This Answer Correct ?

2 Yes

0 No

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WI..

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.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer