How to write the necessary TSQL to create data sets, pull the
data sets in Cognos Report Studio WITHOUT using framework
manager.
- 2 Answers
- 5007 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
where we use page break and page set. with example?
Are you aware of any limitations in Cognos?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
what do u mean by bridge group? where we r using this one?
What is model?
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
what is dimention?explain dimentable with example?
How to Create users in cognos Access Manager from 1) front end 2) back end
how can you create a project creation
How to Improve the Performance of the Report? i need this urgently .
How can we change any header or footer for a group of reports
1 Answers Satyam, Tech Mahindra,
Teradata 
