Interested to Buy Any Domain ? << Click Here >> for more details...
how the values be passed to prompts in report studio?
when a data item is dragged n dropped in to report, after
the default query generated first which sql will the query
query hit for processing means (native or cognos)?
plz answers to these questions?
- 3 Answers
- 9328 Views
- TCS, Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / kumar
Hi Friends,
In Cognos We have 3 Kinds of SQL's
1) Cognos SQL --Default in Report Studio, Frame Work Manager.
2) Native SQL
3) Pass Through SQL
The Default SQL is Cognos SQL why it is It can be used to
create New Query Subjects or Edit , change existed.
it cal hold multiple data bases Query where Data Source
Query can be used for that specific DB.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
2. What functional area you worked on.
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
Can you define pivot?
What actually a project contains?
what is online view?
What are the considerations regarding performance kept in mind while setting up cognos?
What is cognos connection?
What is cognos reporting tool?
What are the components of report net?
How do you Parametermap variables in Quiries?
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?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
what is the procedure for scheduling conditional rendering?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
