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 Metrics designer?
What are all the components of Report Studio?
what is catalog and types of catalogs in cagnos and which is better?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
Why is auto-regression used in forecasting used on cognos platform?
Why cognos scenario is used?
which type of project we r going to snowflake schema
what is stitch query in reportnet?
What is difference between page break and section report?
How Metrics Studio is better than Report Studio?
What do you understand by the term 'aggregate cache'?
----------------------What are the User Securities?
Can you define a query subject?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Can you define bitmap index?