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?
Answer / Satydev Tripathi
1. Hash prompts refer to interactive menus or commands displayed within a terminal session, often used for navigation or configuration purposes.n
2. To add five more columns to the report when using a package and database:n- Modify the SQL query to include the desired columns (e.g., SELECT column1, column2, column3, column4, column5 FROM table).n- Update the report layout to accommodate the additional columns.n
3. Automatic optimization is a feature that automatically adjusts settings within a reporting tool to improve performance.nOptimization refers to adjusting various properties (e.g., caching, rendering options) to optimize a report's speed and resource usage.nProperties you set for optimization in Report Studio may include:n- Cachingn- Paginationn- Refresh moden- Page header/footer settingsn- Sorting and grouping optionsn- Rendering optionsn
4. The command to display the first 10 records from a table varies depending on the database management system (DBMS) you are using:n- For SQL Server: SELECT TOP 10 * FROM table_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is called cognos reporting tool?
What do you mean by Drill down and Drill Up?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
What are the types of catalogs in cognos?
What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?
1 Answers Cognizant, Niteo, SacSoft,
what is Governor settings in cagnos?
How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What is difference between content store and content manager?
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?