Interested to Buy Any Domain ? << Click Here >> for more details...
How to write the necessary TSQL to create data sets, pull the
data sets in Cognos Report Studio WITHOUT using framework
manager.
- 2 Answers
- 5953 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
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
how to perform back drill through in cognos 8 what is the use of it
what is the role of cognos comsultant?what actually it means?pls reply
What do you understand by user class in cognos?
How can you link a query to a data container manually in Report Studio?
What are cognos connection initial page components?
how you provide security to reports? How you provide security to packages ?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
is cognos 7 is better than cognos 8
how to create measures and dimensions?
What is the difference b/w macros and prompt?
What is Metrics designer?
What is the information present in the cognos configuration file?
What are the main services provided by application tier?
What are the components of report net?
