How to write the necessary TSQL to create data sets, pull the
data sets in Cognos Report Studio WITHOUT using framework
manager.
- 2 Answers
- 5461 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of powerplay web viewer in cognos?
What do you mean by query studio?
Can you explain the advantage of using shortcuts?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Write types of folders present in cognos?
what is the difference between native sql and cognos sql?
What is Online View?
What are all the types of hierarchies?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What is difference between content store and content manager?
What is Additive function?
How can you link a query to a data container manually in Report Studio?
What errors and types of errors you faced in Cognos ReportNet?
