What do you do to make a report result in showing 4
different regions in an xl sheet in individual sheets(like
Region1-sheet1,Region2-Sheet2 soon)?
Answer Posted / test
Select the Regions data item and click on "Set Page Break"
from structure (Menu).
Run report in Excel you will have different sheets for each
region.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a Datastore in Cognos?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
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 difference between low affinity and high affinity connections?
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?
How can I test reports in cagonos?
---------------Tell me about DWH Concepts?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Mention the difference between ‘macros’ and ‘prompt’?
What are the different types of reports present in cognos?
Explain the difference between native sql and cognos sql?
5. Which type of report you build more, list, crosstab or chart and why?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
Cleared COG-112 with 100% score today. What next certification should i go for?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance