How to write the necessary TSQL to create data sets, pull the
data sets in Cognos Report Studio WITHOUT using framework
manager.
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 difference between data mart and data warehouse?
Define the cognos reporting tool?
What is the use of Cognos scenario?
Please explain the different stages in creating a report in cognos report net?
What do you mean by drill across?
What is a Folder?
How to join multiple db in catalog?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
is there any difference between operational database and data base?if yes what r they?
What is the difference between Standard and Metrics folder?
What are all the advantages of Cognos?
What are the components used in web tier?
difference between impromptu and cognos8
How to a create header dynamically in a crosstab report in cognos 8.1?