How to write the necessary TSQL to create data sets, pull the
data sets in Cognos Report Studio WITHOUT using framework
manager.
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 model filter?
What are all the types of hierarchies?
How Metrics Studio is better than Report Studio?
What is the use of cognos decision stream?
Can you define slice?
Can you explain the advantage of using shortcuts?
What are the types of studio?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How security is concerned with Reportnet? Explain its implementing steps.
Tell me about Dnamic and Static Dashboards?
What are products of cognos?
is there any difference between operational database and data base?if yes what r they?
What is the difference between group and associare?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?