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?



Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they c..

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

Post New Answer

More Cognos Interview Questions

What is called cognos reporting tool?

1 Answers  


What do you mean by Drill down and Drill Up?

1 Answers  


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.

1 Answers  


What are the types of catalogs in cognos?

1 Answers  


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?

5 Answers  


How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

1 Answers   AIG, Niteo,


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1 Answers   IBM,


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..

1 Answers  


What is difference between content store and content manager?

1 Answers  


can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers  


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 ?

4 Answers  


Categories