Wednesday, April 15, 2015

What is Clipboard ? How to Export and Import ?

Clipboard is a temrorary space provided by windows Os to store data temproary for Cut, Copy and Paste Operation.

You can use Clipboard to perform quick export and import operation in Report Studio.

Follow below steps to export a report.
1. open Your Report
2. Go to tools -> Copy Report to Clipboard -> Ctrl+A to selct every thing and Ctrl_C to copy every thing
3. open a text editor and save all the copied content here.
4. save the text file in any format (Normally XML is used with .xml extension) .

Follow below steps to import a report from a flat file or clipboard.
1. open Your file where report contents are available.
2. Ctrl+A to select every thing, Ctrl_C to copy every thing.
3. open a blank report in report studio
4. Go to tools -> Open Report from Clipboard -> Ctrl+P to paste all the contents. Click on Ok
4. Save Your Report

Monday, April 13, 2015

What is dashboard

A dashboard is a visual display of the most important information needed to achieve one or more objectives which fits entirely on a single computer screen so it can be monitored at a glance.

So many people get this wrong. It has to be simple, readable. most important thing to a user/viewer to achieve their objective. Key thing is it should fit on a single screen other wise the dashboard is useless.

What is Frmaework Manager ?

Framework Manager or IBM Cognos Framework Manager is a window based GUI tool to create metadata for presentation layer used in creating Cognos Reports.

Cognos Report Interview Questions

  1. What is Cognos Report Studio ?
  2. Explain Cardinality ?
  3. Name Different types of Prompts are available in Cognos Report Studio ?
  4. What is Report Net ? name components of Report net?
  5. What is Drill through Report ?
  6. How to create a drill through report ?
  7. What is Prompt ?
  8. What is Macros ? 
  9. What are the components of Report Studio ?
  10. What types of reports are available in Cognos Report Studio ?
  11. Types of Gateway used for Report Studio?
  12. What are the three types of folder present in Cognos?
  13. What do you mean by Drill Down and Drill Up ?
  14. What is Framework Manager ?
  15. Which Studio is used to create reports ? Ans Cognos or IBM Cognos Report Studio is used to create reports. 
  16. What is the difference between list and Cross tab ?
  17. What is Query Subject ?
  18. Different types of layers in Cognos Framework Manager?
  19. Loop in Cognos Report Studio ?
  20. What is running total and how to use it in Cognos Report Studio ?
  21. How to display Parameter Values ?
  22. I have a list report with two columns and I want to create a report in such a way that for a specific group only Column one is display and for other group all the columns display ?
  23. How to improve perfoemacne at database side ?
  24. How to combine two crosstab report in to a single cross tab report ?
  25. How to convert Cross tab into list ?
  26. There is a prompt page having the options for ascending and descending, based on the prompt value selected , the report page generates the list column value sorted in either ascending or descending
  27. How Cognos Report Run ?
  28. How to ensure the value of the value prompt contains only alphabets ?
  29. You have a requirement in which you have to create a report containing list and Cross tab ? Who List or Cross tab based on User input ?
  30. What is Burst Report ?
  31. What is dashboard ? How to create a Dashboard ?
  32. How to add more than one measure in cross tab ?   Explain reason why it is not ?
  33. What is aggregate function ? What is roll up aggregate function ?
  34. What is IQD ? How to create it ?
  35. How to restrict number of selection a list prompt ?
  36. Difference Between Content Store and Conetent Manager ?
  37. Whats is Determinants ? Why to use it ?
  38. How to create dynamic Columns in Report Studio ?
  39. What is difference between burst and schedule ?
  40. How to improve performance of Cognos Report ?
  41.  Create a report to retrieve last 7 day data ?
  42. How to create a new database for Content Store ?
  43. Create a list report which shows number rows on first page is multiple of 5?
  44. How to create join in Cognos Report Studio ?
  45. How to use union in Cognos Report Studio ?
  46. What is the use of metadata in Cognos Report Studio ?
  47. Different types of Dimension in Framework Manager ?
  48. Standalone and Embedded filter in Cgonso Framework Manager ?
  49. What is Complex Report ?
  50. Difference between Scope and Relation ship ?
  51. What is the difference between Parameter and Variable ?
  52. Handling Empty Reports ?
  53. What is Timestamps ? Explain use of it ?
  54. How to create school time table in Cognos Report Studio ?
  55. Show user specific or Group Specific Data ?
  56. Cognos Mashup Services ?
  57. How to use stored procedure in Cognos ?
  58. How to publish FM Package using Scripts ?
  59. What is the difference between Page Break and Page Set ?
  60. Find Second Highest Salary from each company ?
  61. Difference Between Box type and Visible ?
  62. What is Clipboard ? How to import and Export Report Using Clip Board ?
  63. In Which report page break is applicable ?
  64. Add empty space after each m th rows ?
  65. What is Conditional Formatting How to use it ?
  66. How to hide blank page in a multipage report ?
  67. How to hide items without using render variable ?
  68. Explain difference between Render Variable, Conditional Block, and Style Variable ?
  69. Create a value promt required. When not provide data generate blank report ?
  70. Difference between Database Only and Limited Local ?
  71. Display Column Conditionally ?
  72. Display Drill Through Conditionally ?
  73. Display Date based on user Region ?
  74. What is the difference between HTML and Java Script in Cognos ?
  75. Can we provide Package level security to two different
    groups i.e for finance and HR dept should access only their
    data.
  76. Which one is faster Value Prompt or Select and Search Prompt ?
  77. Difference between Drill through and Drill Down ?
  78. How to delete Temproray file in Cognos ?
  79. What is the use of BIBusTKServerMain.exe ?
  80. How to get user realted information in Reports ?
  81. When we deploy the report to live the client get the data error how can we resolve that
  82. How to create a Left Outer Join in FM? Please explain.
  83. What Start Schema is denormalizid ?
  84. Difference e between Star Schema and Snow flake schema ?
  85. What is the use of Max no of rows property ?
  86. What is Segment in Framework Manager ? How to use it ?
  87. What is the Use of Link in Framewwork Manager ?
  88. How can you schedule a report based on different time zone ?
  89. what happens when date function has taken as attribute
  90. Highlight alternate rows in Cognos Report ?
  91. What is model filter and Query Filter ?
  92. What is limited local how to use it ?
  93. How schedule a  report with prompt page ?
  94. What are the use of Dimension Table in Cognos ?
  95. What is model versioning ?
  96. how to get the all values from a prompt using 'ALL' ?
  97. How to apply drill through for analysis report using report studio ?
  98. How to generate report from Monday to Friday ?
  99. How to break Customer Full Name into First Name and Last Name ?
  100. Generate Report Between two date ?
  101. What is hints in Report Studio? Where we use it ?
  102. I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

What is Cognos Report Studio

Cognos Report Studio is a web based GUI tools provided by IBM. It is a part of IBM Cognos Business Intelligence Suite and used to create enterprise or business related reports for analysis Purpose.