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
- 6052 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / mounika
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 |
Post New Answer View All Answers
What is defined as Cognos Impromptu?
Define the slice and dice?
how to create measures and dimensions?
4. How many dimensions did you use in your reports?
how to perform single sign in cognos by using url?
----------------Diff b/w Dimensional modeling and Relational modeling?
hi friends pls forward impropmtu interview question
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
What are the services provided in cognos 8?
What are the types of studio?
---------------Describe OLAP Reporting and RDBMS Reporting?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is set to be cardinality?
What is a Query Subject?
What errors and types of errors you faced in Cognos ReportNet?
