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
- 5914 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
Name the types of report?
What are the methods by which it non-durable model could be changed into the durable model?
Cleared COG-112 with 100% score today. What next certification should i go for?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
how to create measures and dimensions?
What are shortcuts? Where it can be used? What are the advantages?
How do you call a store procedure within a transformation?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
Explain what is the main advantage of impromptu over cognos reportnet?
What are the types of hierarchies?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
--------------Explain Table of contents?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Can you explain dynamic query mode?
in u r data u having duplicates how to fetch the latest data in our report?
