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
- 5823 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
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What are the batches and it’s details?
How do we drill through from a powerplay cube to reportnet?\
What is the difference between a cascading report and drill through the report?
What is the complex report you faced in real time?
How the Bursting happens in same report and how to Print the bursting Report?
What is the size of the cube?
What is set to be cardinality?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
------------- How to identify the Revenue Column in Report?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you define transformer?
How do you call a store procedure within a transformation?
What are the different types of important services used in cognos?
What is meant by Reportstudio shortcut?
