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
- 5952 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 are the advantages of cognos?
--------------Explain Table of contents?
what are slowly changing dimensions? Why we are used scd?
How can you link a query to a data container manually in Report Studio?
What do you mean by drill across?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
how to merge 2 crosstabs thans
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What do you understand by the cognos?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
Can you define confirmed dimension?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Can you explain a cognos controller?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
New coloums are added in database, then how you know in report level
